Database not C/S and not SQLite for Mac
lazarus / 16-Databases

----------------------------------------------------------------------
justapps · 2013-04-22 14:55

Is there a database that I could use that doesn't require libraries
and possible permission changes?  I need something like DBISAM that
allows file sharing and doesn't need to run as a server.  I need it
for OSX.  I want to share the database with multiple users on a
network.  The users may have Windows and OSX clients connecting to the
database.

----------------------------------------------------------------------
Graeme · 2013-04-22 15:11

Quote from: justapps on April 22, 2013, 04:55:10 pmIs there a database
that I could use that doesn't require libraries and possible
permission changes?
If it is a small app, you might get away with TDBF (in fcl-db).
Otherwise contact NexusDB and ask if they support FPC yet - last I
heard there were considering it. You can also try TurboPower
FlashFiler - a very early version of what is now NexusDB.

Alternatively, I suggest you try some embedded RDBMS. I know you said
no libraries, but Embedded Firebird is very simple to deploy, and is
an excellent database server. Nice thing is you can scale it up to a
full C/S system later, without any database change.

----------------------------------------------------------------------
justapps · 2013-04-22 18:07

Do you know if FlashFiler works with OSX? 

Thanks!
Brent

----------------------------------------------------------------------
marcov · 2013-04-22 19:38

Since you require crossplatform locking on a share, I would be very,
very careful.  At least if you value your data.

Essentially you have at least two (Windows, OS X) and potentially
three (server, e.g. if it is a NAS) sets of platform dependencies.

I would seriously urge you to go in the direction of a RDBMS.   E.g.
by running postgresql on a Raspberry PI which mounts your filer via
NFS.

----------------------------------------------------------------------
taazz · 2013-04-22 19:46

flashfiler is an rdbms set of components that supports a client server
architecture if it can be converted to fpc then it should be able to
be compiled on all platforms that fpc supports.

----------------------------------------------------------------------
Graeme · 2013-04-22 22:46

Quote from: justapps on April 22, 2013, 08:07:52 pmDo you know if
FlashFiler works with OSX? 
I have no idea. All I believe I saw, was that FlashFiler was ported to
FPC, but that obviously doesn't mean it works on all platforms.