Re: [Cppcms-users] Distributed data

[Eric G. <con...@gm...>]

Maybe you should modulate your words/opinion a little bit around the
context of the question at first, seems to be a small app and also the fact
that a person able to use an api like cppcms sure have the ability to
understand sql eazily.

Telling me I'm wrong about sql is a database make me suspect you are just
in a mood to throll in playing with words...  of course I write sql is
database for short... and that was enough for the purpose of this answer to
the author in this context.  The long answer is sql is query langage to
access datas stored in database.

Any good faith person understood that I made a really short answer to go
fast only to have a general idea to interest someone to go further by
himself.

Sqlite is faster to dev yes for local files like with qt framework for
example where a direct class can connect to data without even any
coding...  with a model table widget for example.  But this is not a
subject of this mailinglist.

I won't take more time to justify my answers with you anymore.
 Le 2013-11-30 19:46, "Marcel Hellwig" <ke...@co...> a écrit :

> 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
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> Cppcms-users mailing list
> Cpp...@li...
> https://lists.sourceforge.net/lists/listinfo/cppcms-users
>
>