On Jun 15, 2013, at 1:04 PM, Mike Copeland <[email protected]> wrote:
> I might be comparing apples to rutabagas, but I'm wondering what advantages
> or disadvantages SQLite would have over MariaDB on a single-workstation
> application setup?
>
> In other words, I have an app. I need to store data locally, only locally.
> But, I plan to take the app up a step to be multi-user, so i am hesitant to
> use DBF files for data storage.
>
> Why not use MariaDB, installed locally and accessed through 127.0.0.1,
> instead of SQLite (installed locally.)
>
> That way, if I need to install the same app in a mult-user environment, I
> just install MariaDB on whatever box will be the server, and configure each
> workstation to access MariaDB. If I go with SQLite, I don't have that same
> expansion/growth option, do I?
File-based stores: SQLite and DBF
Server-based store: MariaDB
I would only recommend a file-based store for something that is
*always* going to be single-user: stuff like storing preferences for an app.
For everything else, you are always better off with a database server.
MariaDB or PostgreSQL are excellent choices here.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
