I’ve updated my SQLite3 Delphi wrapper for Unicode in Delphi 2009 and higher. Previous versions of the wrapper ducked the issue by using Ansi strings throughout. I actually used Embarcadero Delphi XE for the development, but I would expect it to work in Delphi 2009 and higher, since it was in that version that Delphi … Continue reading Using SQLite 3 with Unicode in Delphi
Most applications use a database, and there are many excellent database engines to choose from, both free and commercial. SQLite is a small C library that has several advantages. It is open source, free, cross-platform, fast, reliable, and well supported. I had a Delphi 7 application using Sqlite 2.0. There are various wrappers available for … Continue reading A simple Delphi wrapper for Sqlite 3
I have been porting a C# application which uses an MDB database (the old Access/JET format) to one that uses SQLite. The process has been relatively smooth, but I encountered a few oddities. One is puzzling and is described by another user here. If you have a column that normally stores string values, but insert … Continue reading SQLite with .NET: excellent but some oddities
The open source SQLite database engine goes from strength to strength, largely by not changing that much: it remains small, fast, reliable, cross-platform, and completely free. The engine is written in C but there are many wrappers for different languages, a recent addition being .NET Core 2.0 and .NET Standard 2.0: 1.0.109.0: Add preliminary support … Continue reading SQLite adds support for .NET Core 2.0 and .NET Standard 2.0
Embarcadero has announced a world tour to promote its forthcoming XE3 development suite. But what is in it? No details yet, but a few clues: Windows 8 “look and functionality” for VCL and FireMonkey apps A new edition of the FireMonkey cross-platform framework, called FM2 A new tool called HTML5 Builder. There are a few … Continue reading Embarcadero preparing Delphi, C++ Builder XE3 release
A new version of SQLite is in preparation. If you are not a developer, you might not have heard of SQLite, but you have almost certainly used it. It is built into Mac OS X and numerous web browsers, used by many applications which run on Adobe’s Flash runtime, and is the obvious choice if … Continue reading Updating the world’s most widely deployed SQL database engine: welcome to SQLite 4
A while back I worked on a Delphi wrapper for SQLite 3, which I published on this site as an open source project. Others amended it to support Free Pascal and Lazarus, so you can use it on Linux and on the Mac. I’ve not touched it for a couple of years; but recently received … Continue reading Updated SQLite wrapper for Embarcadero Delphi (and Free Pascal)
Noah Hart has ported SQLite to C#. I was intrigued to see whether the code could be adapted to run in Silverlight, which has a cut-down .NET Framework and prohibits platform invoke to native code. I hacked away at his code until it ran in Silverlight: Note that the sole purpose of the exercise was … Continue reading Proof of concept: C#-SQLite running in Silverlight
Noah Hart has published his port of SQLite to C#. The project is called C#-SQLite. The main SQLite author, D Richard Hipp, originally said that the project should not include SQLite anywhere in its name, but has now relented: I think I would be comfortable with a name like C#-SQLite. The prefix makes it clear … Continue reading C#-SQLite now published
Yesterday programmer Noah Hart announced a port of SQLite to C#: I am pleased to announce that the C# port is done to the point where others can look at it. Unfortunately the code was taken offline almost immediately afterwards, thanks to the intervention of the author of SQLite, D Richard Hipp: Noah, you are … Continue reading SQLite C# port raises hopes for a Silverlight local database manager