Forum > Databases

Database advice needed

(1/4) > >>

Robert W.B.:
I have to move my sql databases to Lazarus databases and import cvs files to it.
What database in Lazarus, should I create, that is stable, shall I use?

Thanks in advance.
Sincerely
Old Bob  :-[

[Edited to make title meaningful before moving to the Databases forum]

MichaelBM:
This has been working perfectly for me:

http://firebirdsql.org/en/firebird-4-0/

Thaddy:

--- Quote from: MichaelBM on March 28, 2022, 06:09:31 pm ---This has been working perfectly for me:

--- End quote ---
Don't advise FireBird.
Take some mainstream, like MySql, MariaDB, Postgress (or Sqlite for lightweight). FPC supports all f them.

MarkMLl:

--- Quote from: Thaddy on March 28, 2022, 06:21:47 pm ---
--- Quote from: MichaelBM on March 28, 2022, 06:09:31 pm ---This has been working perfectly for me:

--- End quote ---
Don't advise FireBird.
Take some mainstream, like MySql, MariaDB, Postgress (or Sqlite for lightweight). FPC supports all f them.

--- End quote ---

Don't consider SQLite if you might need multiple users or even a single user working from a different system. I believe it now has that capability, but it wasn't "designed in".

I believe that MySQL/MariaDB have a somewhat fluid API. They're popular, but from the POV of Lazarus that doesn't confer much of an advantage.

Firebird and PostgreSQL have fairly compatible SQL dialects, and they both have a notification mechanism (supported by an LCL component) which can be extremely useful.

When experimenting with it around five years ago, I found the Firebird documentation to be poor: multiple manuals with version addenda.

I've been using PostgreSQL for 20+ years, so am biased.

So from my biased POV: SQLite for single-user operation, where it has supplanted e.g. Berkeley DB for configuration files and working storage. Postgres for everything else.

MarkMLl

af0815:
Without more information, all advices are personal POV.

What is your knowledge about DBs ?
Do you need SQL ?
One or more user/connections ?
How much data ? Forecast in the next 5  years ?
What system?

Navigation

[0] Message Index

[#] Next page

Go to full version