Okay, that clarifies my misunderstanding about SQLite...it's not in the
same category as MariaDB because it's ONLY local whereas MariaDB can be
used only local, but it can also be used non-local...i.e., Server-based.
Thanks Ed!
Mike
-------- Original Message --------
Subject: Re: SQLite vs MariaDB
From: Ed Leafe <[email protected]>
To: [email protected]
Date: 6/15/2013 1:41 PM
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
[excessive quoting removed by server]
_______________________________________________
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.
