SQLite developer D Richard Hipp has posted to his mailing list to announce a third release in the space of a few days, to fix bugs discovered in version 3.6.10: Some concern has been expressed that we are releasing too frequently. (Three releases in one week is a lot!) The concern is that this creates … Continue reading SQLite developer argues for quick bug disclosure and fixes, despite egg on face
I created a simple Delphi wrapper for SQLite, the popular open source database library. I’ve just updated it to work with Delphi 2009 – I’m not happy with what I’ve done, because I’ve changed a bunch of declarations from PChar to PAnsiChar and from String to AnsiString, just to get it working quickly. SQLite is … Continue reading SQLite and Delphi 2009
I’ve committed some updates to the simple Delphi wrapper for SQLite. Most of the work was done by others. The main changes are to support named parameters (thanks Lukas Gebauer); and to support prepared queries for performance optimization (thanks Andrew Retmanski). I also recompiled the DLL with the current code, using Visual C++ 6.0. This … Continue reading SQLite with Delphi
I have a couple of open source projects on the go, one of which is a simple Delphi wrapper for SQLite. Lukas Gebauer has now added experimental support for user defined functions. This lets you in effect extend the SQL understood by SQLite to include your own custom functions, written in Delphi. To try out … Continue reading Extend SQLite with Delphi functions
A user emailed me to point out that my simple SQLite 3 wrapper for Delphi did not work with the latest SQLite 3 DLL. The problem was that SQLite 3 now likes pathnames to be in UTF8 format. I’ve made a tiny change to update it. I’ve also now placed the code in a Subversion … Continue reading SQLite wrapper for Delphi
I interviewed Dr D Richard Hipp, the main author of SQLite, for the Guardian Newspaper. Among the things I found interesting is that he attributes the high reliability of his database engine to the extensive test suite included in the code. I’m not sure whether he practices test-driven development as such, but it is a great case … Continue reading SQLite, test-driven development, and the inscrutable SQL standard
I’ve been trying out the Adobe AIR (formerly Apollo) SDK. It’s a confusing business. There are two varieties of AIR apps, Flex, or HTML. The HTML kind is essentially a browser app that runs in WebKit, as wrapped by the AIR runtime, instead of in the browser, while the Flex kind compiles Adobe’s MXML into a Flash … Continue reading Why doesn’t Adobe’s AIR dev guide mention SQLite?
One of the core components in Google’s new Gears API is SQLite, an open source database engine. I’ve been an enthusiast for SQLite for a while now – I first blogged about it in 2003. I’ve also worked a little on SQLIte wrappers for Java and Delphi. It’s a superb embedded database engine and I’m … Continue reading SQLite will be everywhere
I received an email from something trying my simple Delphi wrapper for Sqlite. He wanted to add a million rows to a table of 10 columns of doubles, but was disappointed with the speed. I tried with your SQL commands from the wrapper and just for 10000 elements it took me for ages… I had … Continue reading SQLite: what a difference transactions make
Developing for Apple iOS: cross-platform toolkits compared Interview: Nitobe president Andre Charland talks PhoneGap, web versus native Interview: Appcelerator CEO Jeff Haynie on Titanium and the future of mobile development How to show file extensions in SharePoint 2007 document lists How to backup Small Business Server 2008 on Hyper-V An Outlook mystery resolved: removing the … Continue reading Articles