Fresh Install + sqlite

[moodsoft]

Hi all,

I've been trying to build an SQLite app with Lazarus and I seem to be having issues. So I'm hoping someone will be able to give me step by step instructions from a fresh install of Lazarus of how to add SQLite so I can get to coding as soon as possible. I tried to follow the directions here: http://sqlite4fpc.yolasite.com/update-fpc-component.php and wounded up getting the error: "The procedure entry point sqlite_changes could not be located in the dynamic link library sqlite.dll" this was with using the latest sqlite.dll from http://sqlite.org/download.html

Help is greatly appreciated!

Chris

[ludob]

Looks like you are trying to use TSqliteDataset with a sqlite3 dll. The dll you downloaded has to be used with TSqlite3Dataset  in unit sqlite3ds. The functions exported by sqlite.ddl start with sqlite3_ instead of sqlite_. 

[moodsoft]

OK I was able to confirm that I do have access to the unit sqlite3ds however I do not seem to see an icon called TSqlite3Dataset, can you tell me what I need to do to enable that?

Chris

[ludob]

You need to install the package sqlite3laz.lpk. If you installed sqlitelaz.lpk you can better uninstall that package to avoid mistakes later.

[moodsoft]

I did this and now told that I need sqlite.dll not sqlite3.dll, however I can't seem to find sqlite.dll for Windows anywhere.

Really wish it came fully installed in Lazarus .

[ludob]

You still use the wrong units. Sqlite3DS uses sqlite3 which does an include of sqlite3.inc. There you'll find

Code: [Select]

{$IFDEF WINDOWS}
  Sqlite3Lib = 'sqlite3.dll';
{$else}

Check that all references to sqliteDS or sqlite are gone from all the uses sections in your program. Better, start a new program, drop a TSQLite3Dataset on a form, configure it and test that.

[Leledumbo]

Really wish it came fully installed in Lazarus .

Possible since the license is very permissive (public domain), but I don't think any of the maintainer here want to add that burden to the package. It would be maintenance hell.

[moodsoft]

In case there is an easier way, are there any databases that do not require a server back end that Lazarus / Free Pascal supports out of the box?

[Pascaluvr]

I use SQLite3 for my own projects....   without a problem

If you use win7 ....   put the sqlite3.dll in c:windows\SYSWOW64 (works for both 32 bit and 64 bit)

[BigChimp]

In case there is an easier way, are there any databases that do not require a server back end that Lazarus / Free Pascal supports out of the box?

tdbf, zcsv. See the wiki for those two.

I wouldn't recommend them so quickly though. Yes, installing dlls is troublesome, but IMO a good tradeoff for the loads of features e.g. Firebird or sqlite can bring you.
That said: to each his own

[moodsoft]

I see that I have many copies of SQLite3.dll on my computer, while I know it is a waste of disk space is there anywhere in the Lazarus tree I can store the dll that Lazarus will see it?

[Leledumbo]

I see that I have many copies of SQLite3.dll on my computer, while I know it is a waste of disk space is there anywhere in the Lazarus tree I can store the dll that Lazarus will see it?

The top directory, where (start)lazarus executable exists.