Re: [Cppcms-users] Distributed data

[Marcel H. <ke...@co...>]

On 01.12.2013 01:12, Eric Gendron wrote:
>
> SQL is a database...
>
Wrong!!! [0]
>
> It's almost easy to start using sql...  for simple queries.
>
Kind of wrong! In normal application you do not use simple queries like
'SELECT * FROM users;'.
>
> Easy to share datas between multiple computers on a network.
>
Wrong. It's not easy. You have so many details to be aware of and so
many configuration settings.
>
> Setup connexion
> Open database...
> Select or update query...
> Close database
>
You don't close the database, you close the connection! Please, be
accurate in you statements.
>
> even if you use read/write local files, I recommand using something
> like sqlite, doing sql queries on local database without server. 
>
What?! There is a huge difference between reading/writing/serving local
files and using a database. Also DBMSs are only useful if you have
structured data and a lot of it. Files are better for a small amount of
data (like 10-20 users with a password [.htaccess/.htpasswd], but if you
have >100 of them, I would recommend a DBMS).
And please, do not use SQLite in your productive environment. For >10k
entries the performance is really bad! Use something better, like PgSQL.
Also do not start with a certain DBMS and then change later to an other,
because you use hacks and non SQL-Standard statements. Even if you use
strict SQL(-99), there is not guaranty that you can use your statements
on an other machine.
Always use the same DBMS in enviroment and productiv. Setting up a PgSQL
Server is not as hard, as you might think (at least under *nix).
>
> For me, I found faster to dev with sql even on local database files
> than on manual read/write files...
>
See above!

Regards,
Marcel

[0] http://en.wikipedia.org/wiki/SQL