[Lazarus] Getting started with SQLite with Lazarus on Linux Mint

[Michael Van Canneyt]

On Wed, 10 Jul 2024, Arí Ricardo Ody via lazarus wrote:

> Hello friends!
>
> I tried to install libsqlite3-dev and it gave an error during installation.
> As for the symbolic link suggestion, I ask in which directory I must be
> logged in to execute the creation of the symbolic link.
> I really need to know where I can get the library necessary to use slqite3
> with Laazarus on Linux Mint. Where each module must reside for the Lazarus
> compilation to work.
> It's such a simple database...

It may be simple, but it is in fact a bad database for use with Pascal. 
It has no type safety.

> With Linux Mint I had left behind the idea that to do things on Linux you
> need to be an expert or have one nearby. But look at this problem. I can't
> use simple SQLite3...

I use linux mint myself, and I use sqlite3 without problems.

Installing libsqlite3-dev as suggested is the correct solution.

That you get an error installing an sqlite package is not a problem of FPC or Lazarus.

It would be helpful if you can give us the error, maybe then we can help.

Alternatively, you yourself can create the symbolic link that is created by
installing libsqlite3-dev.

The command as provided here in the mailing list is correct and can be 
executed in any directory, but must be executed by root:

sudo ln -s /usr/lib/libsqlite3.so.0 /usr/lib/libsqlite3.so

If that also does not work, please give us the error. Again, without detailed
information it is not possible to help.

Michael.