Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

Advice: Single File Database (SQL) Multiuser 8 years 11 months ago #7505

  • atlandev.ct
  • atlandev.ct's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 50
  • Thank you received: 0
Hello,
I continue my CT exploration B)
I used Absolute Database Multiuser in my old time with delphi.
I'd like to find an equivalent with CT i.e. a single file database with SQL support.
I can not use mysql/firebird or else because they often being in use on computers where i deploy my apps. So i need to be independent from them.
Sqllite seems to be a good choice but it is not multiuser. isn't it ?
Thanks for reading and maybe answer.
Bye.

Please Log in or Create an account to join the conversation.

Advice: Single File Database (SQL) Multiuser 8 years 11 months ago #7507

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4518
  • Thank you received: 1102
Sir
I think Sqllite3 is a good choice
please read here for multiuser ability

(5) Can multiple applications or multiple instances of the same application access a single database file at the same time?
Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however.

....
....
PilotLogic Architect and Core Programmer
The following user(s) said Thank You: atlandev.ct

Please Log in or Create an account to join the conversation.

Advice: Single File Database (SQL) Multiuser 8 years 11 months ago #7508

  • Vbxler
  • Vbxler's Avatar
  • Visitor
  • Visitor
I often use file databases, because many customer does not allow the installation of a sql-server.
I make every access to the database in following scheme:
-Connect
-Query, Insert or Update
-Disconnect
Caution is particularly in UPDATE important, INSERT and SELECT is not the problem.

Please Log in or Create an account to join the conversation.

Advice: Single File Database (SQL) Multiuser 8 years 11 months ago #7509

  • avra
  • avra's Avatar
  • Visitor
  • Visitor
You can develop server application with SQLite or embedded Firebird, and then develop clients that talk to this application and not to database directly. It used to be hard and time consuming, but now it's not that hard thanks to Mormot .

This might also be worth a look, to be aware of what choices are available:
wiki.freepascal.org/Lazarus_Database_Overview

Please Log in or Create an account to join the conversation.

Last edit: by avra.

Advice: Single File Database (SQL) Multiuser 8 years 11 months ago #7510

  • atlandev.ct
  • atlandev.ct's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 50
  • Thank you received: 0
So much answers, thanks you all, guys. :woohoo:
Sqllite seems to be the lead to follow. Ok then.
I'm going to study all those links... Thanks you very much.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1