cppcms-users Mailing List for CppCMS C++ Web Framework (Page 13)
Brought to you by:
artyom-beilis
You can subscribe to this list here.
2009 |
Jan
|
Feb
(22) |
Mar
|
Apr
(3) |
May
|
Jun
(4) |
Jul
|
Aug
|
Sep
|
Oct
(15) |
Nov
(16) |
Dec
(13) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2010 |
Jan
(4) |
Feb
|
Mar
(8) |
Apr
(8) |
May
(8) |
Jun
(36) |
Jul
(63) |
Aug
(126) |
Sep
(47) |
Oct
(66) |
Nov
(46) |
Dec
(42) |
2011 |
Jan
(87) |
Feb
(24) |
Mar
(54) |
Apr
(21) |
May
(22) |
Jun
(18) |
Jul
(22) |
Aug
(101) |
Sep
(57) |
Oct
(33) |
Nov
(34) |
Dec
(66) |
2012 |
Jan
(64) |
Feb
(76) |
Mar
(73) |
Apr
(105) |
May
(93) |
Jun
(83) |
Jul
(84) |
Aug
(88) |
Sep
(57) |
Oct
(59) |
Nov
(35) |
Dec
(49) |
2013 |
Jan
(67) |
Feb
(17) |
Mar
(49) |
Apr
(64) |
May
(87) |
Jun
(64) |
Jul
(93) |
Aug
(23) |
Sep
(15) |
Oct
(16) |
Nov
(62) |
Dec
(73) |
2014 |
Jan
(5) |
Feb
(23) |
Mar
(21) |
Apr
(11) |
May
(1) |
Jun
(19) |
Jul
(27) |
Aug
(16) |
Sep
(5) |
Oct
(37) |
Nov
(12) |
Dec
(9) |
2015 |
Jan
(7) |
Feb
(7) |
Mar
(44) |
Apr
(28) |
May
(5) |
Jun
(12) |
Jul
(8) |
Aug
|
Sep
(39) |
Oct
(34) |
Nov
(30) |
Dec
(34) |
2016 |
Jan
(66) |
Feb
(23) |
Mar
(33) |
Apr
(15) |
May
(11) |
Jun
(15) |
Jul
(26) |
Aug
(4) |
Sep
(1) |
Oct
(30) |
Nov
(10) |
Dec
|
2017 |
Jan
(52) |
Feb
(9) |
Mar
(24) |
Apr
(16) |
May
(9) |
Jun
(12) |
Jul
(33) |
Aug
(8) |
Sep
|
Oct
(1) |
Nov
(2) |
Dec
(6) |
2018 |
Jan
(5) |
Feb
|
Mar
|
Apr
|
May
(14) |
Jun
(1) |
Jul
(9) |
Aug
(1) |
Sep
(13) |
Oct
(8) |
Nov
(2) |
Dec
(2) |
2019 |
Jan
(1) |
Feb
(1) |
Mar
(3) |
Apr
(3) |
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
2020 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(9) |
Jul
(6) |
Aug
(25) |
Sep
(10) |
Oct
(10) |
Nov
(6) |
Dec
|
2021 |
Jan
|
Feb
|
Mar
(7) |
Apr
(1) |
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
(9) |
Oct
(1) |
Nov
|
Dec
|
2022 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Mohd H. M. S. <hel...@ya...> - 2017-01-13 10:48:04
|
mawan sugiyanto, did you successfully installed on Mac? What your MacOS ver? On Friday, January 13, 2017 6:36 PM, Shiv Shankar Dayal <shi...@gm...> wrote: It wont compile on Mac OS. I tried many times and it never works because it can never find some symbols. It might work but it would be not worth the effort. On Fri, Jan 13, 2017 at 3:51 PM, mawan sugiyanto <ma...@gm...> wrote: i use macport to install more library for cppcms On Jan 13, 2017 5:07 PM, "Paolo Bolzoni" <pao...@gm... > wrote: Did you try to install cmake? On Fri, Jan 13, 2017 at 10:52 AM, Mohd Helmi Mohd Shariff <hel...@ya...> wrote: > Hello, I'm successfully installed cppcms on my OpenSUSE vm. But no success > on Mac OS. It seems problem with cmake not found icu. Thanks. > > ------------------------------ ------------------------------ ------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > ______________________________ _________________ > Cppcms-users mailing list > Cpp...@li...urceforge .net > https://lists.sourceforge.net/ lists/listinfo/cppcms-users > ------------------------------ ------------------------------ ------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ______________________________ _________________ Cppcms-users mailing list Cpp...@li...urceforge .net https://lists.sourceforge.net/ lists/listinfo/cppcms-users ------------------------------ ------------------------------ ------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi ______________________________ _________________ Cppcms-users mailing list Cppcms-users@lists. sourceforge.net https://lists.sourceforge.net/ lists/listinfo/cppcms-users -- Respect, Shiv Shankar Dayal ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi _______________________________________________ Cppcms-users mailing list Cpp...@li... https://lists.sourceforge.net/lists/listinfo/cppcms-users |
From: Shiv S. D. <shi...@gm...> - 2017-01-13 10:35:17
|
It wont compile on Mac OS. I tried many times and it never works because it can never find some symbols. It might work but it would be not worth the effort. On Fri, Jan 13, 2017 at 3:51 PM, mawan sugiyanto <ma...@gm...> wrote: > i use macport to install more library for cppcms > > On Jan 13, 2017 5:07 PM, "Paolo Bolzoni" <pao...@gm...> > wrote: > >> Did you try to install cmake? >> >> On Fri, Jan 13, 2017 at 10:52 AM, Mohd Helmi Mohd Shariff >> <hel...@ya...> wrote: >> > Hello, I'm successfully installed cppcms on my OpenSUSE vm. But no >> success >> > on Mac OS. It seems problem with cmake not found icu. Thanks. >> > >> > ------------------------------------------------------------ >> ------------------ >> > Developer Access Program for Intel Xeon Phi Processors >> > Access to Intel Xeon Phi processor-based developer platforms. >> > With one year of Intel Parallel Studio XE. >> > Training and support from Colfax. >> > Order your platform today. http://sdm.link/xeonphi >> > _______________________________________________ >> > Cppcms-users mailing list >> > Cpp...@li... >> > https://lists.sourceforge.net/lists/listinfo/cppcms-users >> > >> >> ------------------------------------------------------------ >> ------------------ >> Developer Access Program for Intel Xeon Phi Processors >> Access to Intel Xeon Phi processor-based developer platforms. >> With one year of Intel Parallel Studio XE. >> Training and support from Colfax. >> Order your platform today. http://sdm.link/xeonphi >> _______________________________________________ >> Cppcms-users mailing list >> Cpp...@li... >> https://lists.sourceforge.net/lists/listinfo/cppcms-users >> > > ------------------------------------------------------------ > ------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users > > -- Respect, Shiv Shankar Dayal |
From: mawan s. <ma...@gm...> - 2017-01-13 10:22:12
|
i use macport to install more library for cppcms On Jan 13, 2017 5:07 PM, "Paolo Bolzoni" <pao...@gm...> wrote: > Did you try to install cmake? > > On Fri, Jan 13, 2017 at 10:52 AM, Mohd Helmi Mohd Shariff > <hel...@ya...> wrote: > > Hello, I'm successfully installed cppcms on my OpenSUSE vm. But no > success > > on Mac OS. It seems problem with cmake not found icu. Thanks. > > > > ------------------------------------------------------------ > ------------------ > > Developer Access Program for Intel Xeon Phi Processors > > Access to Intel Xeon Phi processor-based developer platforms. > > With one year of Intel Parallel Studio XE. > > Training and support from Colfax. > > Order your platform today. http://sdm.link/xeonphi > > _______________________________________________ > > Cppcms-users mailing list > > Cpp...@li... > > https://lists.sourceforge.net/lists/listinfo/cppcms-users > > > > ------------------------------------------------------------ > ------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users > |
From: Paolo B. <pao...@gm...> - 2017-01-13 10:06:57
|
Did you try to install cmake? On Fri, Jan 13, 2017 at 10:52 AM, Mohd Helmi Mohd Shariff <hel...@ya...> wrote: > Hello, I'm successfully installed cppcms on my OpenSUSE vm. But no success > on Mac OS. It seems problem with cmake not found icu. Thanks. > > ------------------------------------------------------------------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users > |
From: Mohd H. M. S. <hel...@ya...> - 2017-01-13 09:55:16
|
Hello, I'm successfully installed cppcms on my OpenSUSE vm. But no success on Mac OS. It seems problem with cmake not found icu. Thanks. |
From: Josh H. <jo...@ni...> - 2017-01-12 16:41:34
|
Artyom Beilis wrote: >> I have created a stand-alone test that shows the difference between >> sharing a single SQLite database connection between threads, and >> creating a new connection for each thread. It can be viewed here: >> >> https://gist.github.com/nispio/fe2955c9a0978532cf7b864a8b1b54db >> > > > Actually it shows exact behaviour I expected > > This is my run (note on PC with 4 cores): > > > SAME CONNECTION > Thread 1: library routine called out of sequence > Thread 2: library routine called out of sequence > Thread 3: library routine called out of sequence > FAILED run(insert_random, "/var/tmp/testdb1.db") > NEW CONNECTION > Thread 2: database is locked > Thread 3: database is locked > FAILED run(new_connection_insert_random, "/var/tmp/testdb2.db") > I'm sorry. I made a mistake when posting to Gist. I made a slight tweak to the code when posting, and forgot to check if it worked. (Rookie mistake, I know). The error that you are seeing in the first case is not related to threading at all; it is just a bad pointer. Will you please humor me and try one more time with the updated code? https://gist.github.com/nispio/fe2955c9a0978532cf7b864a8b1b54db |
From: Artyom B. <art...@gm...> - 2017-01-12 08:55:05
|
> I have another question. Why are you trying to support BSD and Solaris? > Linux is good enough and we can skip other Unix stuff. > Several reasons: - the code is cross platform and should remain so. Using additional platforms allows you to catch some important stuff. - BSD is quite popular platform that CppCMS runs well on it (same for Solaris also less popular than BSD) - Finally there is Mac OS X (that is quite close to BSD) and I can't run Mac OS X VM for testing due to licensing restriction. The bugs are small and should be quite fixable - in any case this isn't the main reason the release is delayed. If I would drop support of something that would be Windows :-) but I don't want to as too many developers for some reasons I can't understand use one ;-) > > What format do you accept patches in? Patch file format :-) (svn diff creates one) Artyom |
From: Stanimir M. <sta...@zo...> - 2017-01-12 08:53:19
|
On Thu, Jan 12, 2017 at 10:12 AM, Shiv Shankar Dayal <shi...@gm...> wrote: > > I have another question. Why are you trying to support BSD and Solaris? Linux is good enough and we can skip other Unix stuff. > A bit of sarcasm, but do you think that Artyom created CppCMS only for your needs? ;) > I have not tried to look at CppCMS source code. I just use it. Seems I can help some but I am also busy writing my books. If I manage sometime I will try to send some patches say after 3 months. > > What format do you accept patches in? > There was a wide discussion for this type of question in this group. Example thread is https://sourceforge.net/p/cppcms/mailman/cppcms-users/thread/1673022.4D2CPS5jAE%4099d44166af322fc16a4774097a5f271d/#msg35455754 Just search first and you will probably find an answer to your questions. > On Thu, Jan 12, 2017 at 1:40 PM, Shiv Shankar Dayal <shi...@gm...> wrote: >> >> I am not asking you to commit. Any wild guess is good enough. :) >> >> On Thu, Jan 12, 2017 at 1:37 PM, Artyom Beilis <art...@gm...> wrote: >>> >>> First of all I suggest to use trunk - it is very stable. I think many >>> users are switched to trunk. >>> Indeed I need to release the new version. >>> >>> And fix this: http://cppcms.com/wikipp/en/page/cppcms_1x_tasks#Update.external.modules.to.updated.API >>> >>> Additionally I still have some unit test fails on BSD and Solaris I >>> need to resolve: >>> >>> http://cppcms.com/files/nightly-build-report.html >>> >>> Unfortunatelly I can't commit to a specific time. >>> >>> >>> Artyom >>> >>> On Wed, Jan 11, 2017 at 3:46 PM, Shiv Shankar Dayal >>> <shi...@gm...> wrote: >>> > Hi Artyom, >>> > >>> > Can you please tell us when would you be able to release code lying in >>> > trunk? I know you are busy with job and family but it would be very kind of >>> > you to do a new release. >>> > >>> > -- >>> > Respect, >>> > Shiv Shankar Dayal >>> > >>> > ------------------------------------------------------------------------------ >>> > Developer Access Program for Intel Xeon Phi Processors >>> > Access to Intel Xeon Phi processor-based developer platforms. >>> > With one year of Intel Parallel Studio XE. >>> > Training and support from Colfax. >>> > Order your platform today. http://sdm.link/xeonphi >>> > _______________________________________________ >>> > Cppcms-users mailing list >>> > Cpp...@li... >>> > https://lists.sourceforge.net/lists/listinfo/cppcms-users >>> > >>> >>> ------------------------------------------------------------------------------ >>> Developer Access Program for Intel Xeon Phi Processors >>> Access to Intel Xeon Phi processor-based developer platforms. >>> With one year of Intel Parallel Studio XE. >>> Training and support from Colfax. >>> Order your platform today. http://sdm.link/xeonphi >>> _______________________________________________ >>> Cppcms-users mailing list >>> Cpp...@li... >>> https://lists.sourceforge.net/lists/listinfo/cppcms-users >> >> >> >> >> -- >> Respect, >> Shiv Shankar Dayal > > > > > -- > Respect, > Shiv Shankar Dayal > > ------------------------------------------------------------------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users > |
From: Artyom B. <art...@gm...> - 2017-01-12 08:49:55
|
On Thu, Jan 12, 2017 at 10:10 AM, Shiv Shankar Dayal <shi...@gm...> wrote: > I am not asking you to commit. Any wild guess is good enough. :) > I did several in the past and they proved wrong. Artyom |
From: Shiv S. D. <shi...@gm...> - 2017-01-12 08:12:39
|
I have another question. Why are you trying to support BSD and Solaris? Linux is good enough and we can skip other Unix stuff. I have not tried to look at CppCMS source code. I just use it. Seems I can help some but I am also busy writing my books. If I manage sometime I will try to send some patches say after 3 months. What format do you accept patches in? On Thu, Jan 12, 2017 at 1:40 PM, Shiv Shankar Dayal < shi...@gm...> wrote: > I am not asking you to commit. Any wild guess is good enough. :) > > On Thu, Jan 12, 2017 at 1:37 PM, Artyom Beilis <art...@gm...> > wrote: > >> First of all I suggest to use trunk - it is very stable. I think many >> users are switched to trunk. >> Indeed I need to release the new version. >> >> And fix this: http://cppcms.com/wikipp/en/pa >> ge/cppcms_1x_tasks#Update.external.modules.to.updated.API >> >> Additionally I still have some unit test fails on BSD and Solaris I >> need to resolve: >> >> http://cppcms.com/files/nightly-build-report.html >> >> Unfortunatelly I can't commit to a specific time. >> >> >> Artyom >> >> On Wed, Jan 11, 2017 at 3:46 PM, Shiv Shankar Dayal >> <shi...@gm...> wrote: >> > Hi Artyom, >> > >> > Can you please tell us when would you be able to release code lying in >> > trunk? I know you are busy with job and family but it would be very >> kind of >> > you to do a new release. >> > >> > -- >> > Respect, >> > Shiv Shankar Dayal >> > >> > ------------------------------------------------------------ >> ------------------ >> > Developer Access Program for Intel Xeon Phi Processors >> > Access to Intel Xeon Phi processor-based developer platforms. >> > With one year of Intel Parallel Studio XE. >> > Training and support from Colfax. >> > Order your platform today. http://sdm.link/xeonphi >> > _______________________________________________ >> > Cppcms-users mailing list >> > Cpp...@li... >> > https://lists.sourceforge.net/lists/listinfo/cppcms-users >> > >> >> ------------------------------------------------------------ >> ------------------ >> Developer Access Program for Intel Xeon Phi Processors >> Access to Intel Xeon Phi processor-based developer platforms. >> With one year of Intel Parallel Studio XE. >> Training and support from Colfax. >> Order your platform today. http://sdm.link/xeonphi >> _______________________________________________ >> Cppcms-users mailing list >> Cpp...@li... >> https://lists.sourceforge.net/lists/listinfo/cppcms-users >> > > > > -- > Respect, > Shiv Shankar Dayal > -- Respect, Shiv Shankar Dayal |
From: Shiv S. D. <shi...@gm...> - 2017-01-12 08:10:32
|
I am not asking you to commit. Any wild guess is good enough. :) On Thu, Jan 12, 2017 at 1:37 PM, Artyom Beilis <art...@gm...> wrote: > First of all I suggest to use trunk - it is very stable. I think many > users are switched to trunk. > Indeed I need to release the new version. > > And fix this: http://cppcms.com/wikipp/en/page/cppcms_1x_tasks#Update. > external.modules.to.updated.API > > Additionally I still have some unit test fails on BSD and Solaris I > need to resolve: > > http://cppcms.com/files/nightly-build-report.html > > Unfortunatelly I can't commit to a specific time. > > > Artyom > > On Wed, Jan 11, 2017 at 3:46 PM, Shiv Shankar Dayal > <shi...@gm...> wrote: > > Hi Artyom, > > > > Can you please tell us when would you be able to release code lying in > > trunk? I know you are busy with job and family but it would be very kind > of > > you to do a new release. > > > > -- > > Respect, > > Shiv Shankar Dayal > > > > ------------------------------------------------------------ > ------------------ > > Developer Access Program for Intel Xeon Phi Processors > > Access to Intel Xeon Phi processor-based developer platforms. > > With one year of Intel Parallel Studio XE. > > Training and support from Colfax. > > Order your platform today. http://sdm.link/xeonphi > > _______________________________________________ > > Cppcms-users mailing list > > Cpp...@li... > > https://lists.sourceforge.net/lists/listinfo/cppcms-users > > > > ------------------------------------------------------------ > ------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users > -- Respect, Shiv Shankar Dayal |
From: Artyom B. <art...@gm...> - 2017-01-12 08:07:19
|
First of all I suggest to use trunk - it is very stable. I think many users are switched to trunk. Indeed I need to release the new version. And fix this: http://cppcms.com/wikipp/en/page/cppcms_1x_tasks#Update.external.modules.to.updated.API Additionally I still have some unit test fails on BSD and Solaris I need to resolve: http://cppcms.com/files/nightly-build-report.html Unfortunatelly I can't commit to a specific time. Artyom On Wed, Jan 11, 2017 at 3:46 PM, Shiv Shankar Dayal <shi...@gm...> wrote: > Hi Artyom, > > Can you please tell us when would you be able to release code lying in > trunk? I know you are busy with job and family but it would be very kind of > you to do a new release. > > -- > Respect, > Shiv Shankar Dayal > > ------------------------------------------------------------------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users > |
From: Artyom B. <art...@gm...> - 2017-01-12 08:01:34
|
> > I have created a stand-alone test that shows the difference between > sharing a single SQLite database connection between threads, and > creating a new connection for each thread. It can be viewed here: > > https://gist.github.com/nispio/fe2955c9a0978532cf7b864a8b1b54db > Actually it shows exact behaviour I expected This is my run (note on PC with 4 cores): SAME CONNECTION Thread 1: library routine called out of sequence Thread 2: library routine called out of sequence Thread 3: library routine called out of sequence FAILED run(insert_random, "/var/tmp/testdb1.db") NEW CONNECTION Thread 2: database is locked Thread 3: database is locked FAILED run(new_connection_insert_random, "/var/tmp/testdb2.db") Now I explain: In fact new connection worked as expected to work, some threads succeed and some failed due to locked database. Using single connection created out of sequence error! IN fact the use of new connection works properly as sqlite3 does not support writing the same database from different threads simultaneously and would return the error the locked database and user need to handle such a error - i.e. try to run the statement same time - similarly that in "bigger" DB you receive deadlock errors. In fact you try the test with sqlite3 in exact situation where the sqlite3 is suboptimal - high concurrency updates. https://sqlite.org/whentouse.html If you for example run select queries in all threads it would succeed and if you turn on WAL you would likely succeed doing simultaneous single write multiple reads. Bottom line - sqlite3 behaves exactly as expected. You probably misunderstand the use case. If you want to run high amount of inserts to DB the optimal way is to do it from a single thread in a single transaction (on Rollback journal mode) or from single thread in big chunks each in a single transaction of WAL mode. In any case you have to be ready to handle errors - similar to the way you need to handle deadlocks in "big" DBs. Best Regards, Artyom > ------------------------------------------------------------------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users |
From: Josh H. <jos...@ni...> - 2017-01-11 21:15:19
|
Josh Hunsaker wrote: > Artyom Beilis wrote: >>> Currently the cppdb_sqlite3 driver attempts to open a new >>> connection to the database via sqlite3_open_v2() for each thread. >>> From the SQLite documentation, it would seem that a given process >>> should only have one shared connection to the database. If that >>> is the case, then the cppdb_sqlite3 driver is written contrary to >>> the intended usage of sqlite3. It seems that the right thing to >>> do may be to open a single connection and share it between the >>> threads. >> >> You are wrong, sqlite3 fully supports multi-threading but you need to >> be sure that >> you are using the sqlite3 library that was compiled properly. > > I'm sorry, let me attempt to express myself more clearly: A > given process may share a *single* connection to the database > between multiple threads. In other words, the call to > sqlite3_open_v2() should only happen once within a given process, > and all threads within that process should then utilize that > single connection, so long as it is open. > > The way in which SQLite supports multi-threading is via its own > internal mutexes. However, creating multiple database > connections to the database (via multiple calls to > sqlite3_open_v2) will cause multiple mutexes to be created, > therefore nullifying their usefulness. The SQLite FAQ says the > following: > >>> SQLite is threadsafe because it uses mutexes to serialize >>> access to common data structures. > > I am not suggesting that multi-threaded access cannot be achieved > with SQLite. I am suggesting that the correct way to do > multi-threading with SQLite is to create a single database > connection within a given process, and share that connection > between the threads. This allows the internal mutexes in SQLite > to work as intended. I have tested this, and can provide test > code to demonstrate SQLite behavior, if desired. I have created a stand-alone test that shows the difference between sharing a single SQLite database connection between threads, and creating a new connection for each thread. It can be viewed here: https://gist.github.com/nispio/fe2955c9a0978532cf7b864a8b1b54db |
From: Shiv S. D. <shi...@gm...> - 2017-01-11 13:46:08
|
Hi Artyom, Can you please tell us when would you be able to release code lying in trunk? I know you are busy with job and family but it would be very kind of you to do a new release. -- Respect, Shiv Shankar Dayal |
From: mawan s. <ma...@gm...> - 2017-01-11 13:19:51
|
thank you Stanimir. On Jan 11, 2017 7:32 PM, "Stanimir Mladenov" < sta...@zo...> wrote: > Hello Mawan > > This has been discussed before and you can find more help in the history > of this group. > Generally you can read this in the documentation http://cppcms. > com/wikipp/en/page/cppcms_1x_tut_web_server_config > > On Wed, Jan 11, 2017 at 12:32 PM, mawan sugiyanto <ma...@gm...> > wrote: > >> Dear All >> >> When i upload and config web app as cgi , css file, js can not load from >> web server. How to setup / mapping this file in config.js >> >> Thanks >> >> >> Mawan >> >> ------------------------------------------------------------ >> ------------------ >> Developer Access Program for Intel Xeon Phi Processors >> Access to Intel Xeon Phi processor-based developer platforms. >> With one year of Intel Parallel Studio XE. >> Training and support from Colfax. >> Order your platform today. http://sdm.link/xeonphi >> _______________________________________________ >> Cppcms-users mailing list >> Cpp...@li... >> https://lists.sourceforge.net/lists/listinfo/cppcms-users >> >> > > ------------------------------------------------------------ > ------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users > > |
From: Stanimir M. <sta...@zo...> - 2017-01-11 12:31:54
|
Hello Mawan This has been discussed before and you can find more help in the history of this group. Generally you can read this in the documentation http://cppcms.com/wikipp/en/page/cppcms_1x_tut_web_server_config On Wed, Jan 11, 2017 at 12:32 PM, mawan sugiyanto <ma...@gm...> wrote: > Dear All > > When i upload and config web app as cgi , css file, js can not load from > web server. How to setup / mapping this file in config.js > > Thanks > > > Mawan > > ------------------------------------------------------------ > ------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users > > |
From: mawan s. <ma...@gm...> - 2017-01-11 10:33:38
|
Dear All When i upload and config web app as cgi , css file, js can not load from web server. How to setup / mapping this file in config.js Thanks Mawan |
From: Artyom B. <art...@gm...> - 2017-01-11 08:48:15
|
The problem with the number of rows is that in many APIs it isn't known in advance. For example sqlite3 and mysql fetches row by row until you get to the end of the query. You can store the entire result but it may be costly - and it isn't done by default. So the number of rows in advance can be used for only in limited set of drivers. Artyom On Tue, Jan 10, 2017 at 10:58 AM, CN <cn...@fa...> wrote: > Hi! > > If there are people being able to arrange time to enhance CppDB to > return the selected rows count from cppdb::statement::query(), maybe I > can take the PostgreSQL part. > I can't do this alone because I know nothing except PostgreSQL :-( > > Best Regards, > CN > > -- > http://www.fastmail.com - Access all of your messages and folders > wherever you are > > > ------------------------------------------------------------------------------ > Developer Access Program for Intel Xeon Phi Processors > Access to Intel Xeon Phi processor-based developer platforms. > With one year of Intel Parallel Studio XE. > Training and support from Colfax. > Order your platform today. http://sdm.link/xeonphi > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users |
From: Josh H. <jos...@ni...> - 2017-01-10 15:49:27
|
Artyom Beilis wrote: >> Currently the cppdb_sqlite3 driver attempts to open a new >> connection to the database via sqlite3_open_v2() for each thread. >> From the SQLite documentation, it would seem that a given process >> should only have one shared connection to the database. If that >> is the case, then the cppdb_sqlite3 driver is written contrary to >> the intended usage of sqlite3. It seems that the right thing to >> do may be to open a single connection and share it between the >> threads. > > You are wrong, sqlite3 fully supports multi-threading but you need to > be sure that > you are using the sqlite3 library that was compiled properly. I'm sorry, let me attempt to express myself more clearly: A given process may share a *single* connection to the database between multiple threads. In other words, the call to sqlite3_open_v2() should only happen once within a given process, and all threads within that process should then utilize that single connection, so long as it is open. The way in which SQLite supports multi-threading is via its own internal mutexes. However, creating multiple database connections to the database (via multiple calls to sqlite3_open_v2) will cause multiple mutexes to be created, therefore nullifying their usefulness. The SQLite FAQ says the following: >> SQLite is threadsafe because it uses mutexes to serialize >> access to common data structures. I am not suggesting that multi-threaded access cannot be achieved with SQLite. I am suggesting that the correct way to do multi-threading with SQLite is to create a single database connection within a given process, and share that connection between the threads. This allows the internal mutexes in SQLite to work as intended. I have tested this, and can provide test code to demonstrate SQLite behavior, if desired. |
From: CN <cn...@fa...> - 2017-01-10 08:58:10
|
Hi! If there are people being able to arrange time to enhance CppDB to return the selected rows count from cppdb::statement::query(), maybe I can take the PostgreSQL part. I can't do this alone because I know nothing except PostgreSQL :-( Best Regards, CN -- http://www.fastmail.com - Access all of your messages and folders wherever you are |
From: Artyom B. <art...@gm...> - 2017-01-10 06:56:41
|
> On Sun, Jan 8, 2017 at 12:17 AM, Artyom Beilis wrote: >> In general sqlite3 behaves poorly with multiple threads and you should >> make yourself ready to deal with the issue - simultanious updates and >> even query + update may fail. >> >> Artyom > > Currently the cppdb_sqlite3 driver attempts to open a new > connection to the database via sqlite3_open_v2() for each thread. > >From the SQLite documentation, it would seem that a given process > should only have one shared connection to the database. If that > is the case, then the cppdb_sqlite3 driver is written contrary to > the intended usage of sqlite3. It seems that the right thing to > do may be to open a single connection and share it between the > threads. > You are wrong, sqlite3 fully supports multi-threading but you need to be sure that you are using the sqlite3 library that was compiled properly. https://www.sqlite.org/threadsafe.html Artyom |
From: Josh H. <jo...@ni...> - 2017-01-09 17:36:11
|
On Sun, Jan 8, 2017 at 12:17 AM, Artyom Beilis wrote: > In general sqlite3 behaves poorly with multiple threads and you should > make yourself ready to deal with the issue - simultanious updates and > even query + update may fail. > > Artyom Currently the cppdb_sqlite3 driver attempts to open a new connection to the database via sqlite3_open_v2() for each thread. >From the SQLite documentation, it would seem that a given process should only have one shared connection to the database. If that is the case, then the cppdb_sqlite3 driver is written contrary to the intended usage of sqlite3. It seems that the right thing to do may be to open a single connection and share it between the threads. |
From: Artyom B. <art...@gm...> - 2017-01-08 07:17:24
|
In general sqlite3 behaves poorly with multiple threads and you should make yourself ready to deal with the issue - simultanious updates and even query + update may fail. Artyom On Fri, Jan 6, 2017 at 8:54 PM, Josh Hunsaker <jos...@ni...> wrote: > Is connection pooling expected to work for the SQLite backend? When I > spawn three threads and try to connect to the database from each, one > of the connections will succeed and the other two will fail. On the > two that fail, I get an error saying "database is locked." This > happens whether I am using the connection pool directly (via > cppdb::pool) or indirectly (via @pool_size). > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users |
From: Artyom B. <art...@gm...> - 2017-01-08 07:14:56
|
On Thu, Jan 5, 2017 at 4:32 PM, Patrick Wolf <pat...@ra...> wrote: > > Hi, > I would like to know if anyone could give me some insight on how to configure cppcms with mod_fcgid. First of all take a look on this: http://cppcms.com/wikipp/en/page/cppcms_1x_tut_web_server_config >From what I remember mod_fcgid does not support multi-threaded application (and CppCMS works this way) http://stackoverflow.com/questions/15623422/mod-fcgid-multi-threaded-fastcgi-now-or-in-a-planned-future you probably should give a try to mod_proxy_fcgi but also note it can't start your process. I'd suggest just use SCGI (it is in general as efficient as fastcgi) Artyom > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > _______________________________________________ > Cppcms-users mailing list > Cpp...@li... > https://lists.sourceforge.net/lists/listinfo/cppcms-users |