On 6/20/06, John Stanton <[EMAIL PROTECTED]> wrote:
Costas Stergiou wrote: >>Hello, >> >>I need a server-less SQL engine. Unless someone recommends a better tool >>(embedded FireBird? Something else?), I'm thinking of using SQLite. >> >>Problem is, several wrappers are listed in the SQLite wiki. Can you >>recommend one, ideally under active development, easy to use, etc. >> >>- Aducom open-source Delphi/BCC SQLite components >>http://www.aducom.com >> >>- ZeosLib >>http://sourceforge.net/projects/zeoslib/ >> >>- DISQLite3 >>http://www.yunqa.de/delphi/sqlite3/ >> >>- LibSQL >>http://libsql.dubaron.com/ >> >>- Simple Sqlite 3.0 for Delphi >>http://www.itwriting.com/sqlitesimple.php >> >>Thank you. >> > > > Having done a similar research in the past I would certainly suggest to not > use any library and use directly the sqlite procs. All you need is a file to > declare the functions in Delphi and then just use the functions directly. > > Personally, I have just created some simple wrapper functions in Delphi > (very simple - 3 lines each) to make it a bit easier to call the SQLIte > functions. > > Using a wrapper is usually bug-prone (unfortunately most of them have bugs) > and it usually wraps around the TDataset which is not a good idea (unless > you are using bound controls). > Also, if you use a wrapper you will need to learn 2 APIs: SQLite's and the > LIB's, which is again a bad idea. > > Hope this is of some help, > Costas > > P.S. I am not the 'do-it-yourself' kind but in this case, it is really > better to use sqlite directly! > > > I would endorse that approach. The Sqlite API is simple and easy to use, so why not take advantage of that and KISS (Keep It Simple Senor)?
A lot of the time using the vanilla API keeps you from coding in the style most suited for a modern lang, which may only help introduce bugs which the dev isn't used to worrying about. I don't think it's right to recommend using it when there are wrappers tailored to keep the dev thinking in their own lang. You certainly don't gain anything by using the flat API over a wrapper, unless the wrapper is bloated/buggy! -- Cory Nelson http://www.int64.org
