Re: [Cppcms-users] Distributed data

[Shiv S. D. <shi...@gm...>]

As I said data has to be distributed and SQL databases have to be sharded
which is a pain. That is because I then need to do things which I should
not be doing really. I will be doing databases' job.


On Sun, Dec 1, 2013 at 6:44 AM, Eric Gendron <con...@gm...> wrote:

> 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
>>
>>
>
> ------------------------------------------------------------------------------
> 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
>
>


-- 
Respect,
Shiv Shankar Dayal