csql-core Mailing List for CSQL Main Memory Database / Cache
Main Memory Database Cache
Brought to you by:
prabatuty
You can subscribe to this list here.
2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(16) |
Dec
(30) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2008 |
Jan
(3) |
Feb
(7) |
Mar
|
Apr
|
May
(1) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: prabakaran <pra...@ya...> - 2008-06-03 05:30:21
|
Hi Team, CSQL 2.0 GA released CSQL is open source updateable bi-directional table level caching solution to improve application performance by 20-100 times. It can also be used as stand alone ultra fast Main Memory Database. To know more about its capabilities, please go through this blog at http://csqlcache.wordpress.com/ This release includes 1.Primitive ODBC Driver 2.Updateable cache tables 3.Bi-Direction update propagation for cache tables 3.cachetable, cacheverify, csqldump tool 4.Recovery in case of gracefull shutdown 5.Transparent pass through to target database for non-cached tables. you can download your copy at http://sourceforge.net/projects/csql/ Hope you enjoy using csql. If you face any issues send an email to csq...@li.... Regards Prabakaran CSQL Team |
From: prabakaran <pra...@ya...> - 2008-05-20 04:26:10
|
Hi All, CSQL2.0 Beta Released. This release contains operation synchronous table level caching, gateway, odbc driver, csqldump and cachetable tool. Regards Prabakaran |
From: Gopal S. <gop...@gm...> - 2008-02-25 01:37:32
|
Hi Prabha, create/insert/select/drop using ODBCDriver is working now. I will submit code once, 1. Minor code comments. 2. Test basic parameters. 3. Run perf test. I should submit within 3 days, before 27th. I have not used SQLAPI absClasses yet. I will try if I can use it within this date. Regards Gopal S. On Tue, Feb 19, 2008 at 12:30 PM, prabakaran <pra...@ya...> wrote: > > Hi Team, > I have added new tool cachetable which shall be used > to load tables from any target database using the dsn > specified in csql.conf and unixODBC library. > > Also added code, to recover the rows of the table from > target database once it is cached during csqlserver > restart. > > Note: mkdir /tmp/csql > if you get any error. > > Let us plan to keep operation sync CSQL cache gateway > as first milestone.Later data sync and network sync > shall be planned. > > I am planning to concentrate on bug fixing and testing > for next 2 weeks. > Gopal: i will start writing test scripts for odbc. > > Hope we are progressing on ODBCAdapter, ODBCDriver and > Gateway.Let me know the progress. > > Regards > Prabakaran > > > > ____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Csql-core mailing list > Csq...@li... > https://lists.sourceforge.net/lists/listinfo/csql-core > |
From: Gopal S. <gop...@gm...> - 2008-02-24 16:34:43
|
Got it. I agree. -Gopal On Sun, Feb 24, 2008 at 8:42 AM, prabakaran <pra...@ya...> wrote: > As SELECT statements are part of DML in database > domain terminology, it is mapped the same way in sql > engine. there is no other specific reason for this. > > > > > > > ____________________________________________________________________________________ > Looking for last minute shopping deals? > Find them fast with Yahoo! Search. > http://tools.search.yahoo.com/newsearch/category.php?category=shopping > |
From: prabakaran <pra...@ya...> - 2008-02-24 14:42:13
|
As SELECT statements are part of DML in database domain terminology, it is mapped the same way in sql engine. there is no other specific reason for this. ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping |
From: Gopal S. <gop...@gm...> - 2008-02-24 04:29:22
|
Hi All, Is there any reason for deriving SelStatement from DmlStatement ? Regards Gopal S. |
From: prabakaran <pra...@ya...> - 2008-02-19 18:30:38
|
Hi Team, I have added new tool cachetable which shall be used to load tables from any target database using the dsn specified in csql.conf and unixODBC library. Also added code, to recover the rows of the table from target database once it is cached during csqlserver restart. Note: mkdir /tmp/csql if you get any error. Let us plan to keep operation sync CSQL cache gateway as first milestone.Later data sync and network sync shall be planned. I am planning to concentrate on bug fixing and testing for next 2 weeks. Gopal: i will start writing test scripts for odbc. Hope we are progressing on ODBCAdapter, ODBCDriver and Gateway.Let me know the progress. Regards Prabakaran ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ |
From: prabakaran <pra...@ya...> - 2008-02-06 05:05:29
|
Hi All, The response in conference was average. Some where around 35 students turned up as cricket match was going on that day. I am going to native this week so will not be able to attend meeting this week. Regards Prabakaran ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs |
From: Gopal S. <gop...@gm...> - 2008-02-03 03:16:54
|
Hi All, My status, 1. Still coding ODBC. 2. No progress toward talk on product line. I will not be in meeting today. As there was no meeting notice, I dont know if someone will join. But if required please conduct meeting. Thanks. Regards Gopal S. On Jan 26, 2008 9:27 PM, prabakaran <pra...@ya...> wrote: > Postponed to 9:30 AM IST > > > > > ____________________________________________________________________________________ > Looking for last minute shopping deals? > Find them fast with Yahoo! Search. > http://tools.search.yahoo.com/newsearch/category.php?category=shopping > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Csql-core mailing list > Csq...@li... > https://lists.sourceforge.net/lists/listinfo/csql-core > |
From: prabakaran <pra...@ya...> - 2008-01-27 03:27:13
|
Postponed to 9:30 AM IST ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping |
From: prabakaran <pra...@ya...> - 2008-01-26 06:31:31
|
Hi All, CSQL Team meeting tommorow(Sunday) at 8.30 AM IST through skype. Please confirm whether you will be available for the meeting by mail. Feel free to add items to the agenda. Regards Prabakaran Agenda: ------- Primary Tasks and decide on deadlines ------------------------------------- Primitive ODBC Driver - Gopal Tree Index - Ganga Architecture of Caching Gateway - Prabakaran ODBCAdapter - Aruna Ongoing task ------------ Architecture wiki updation Mapping wiki test cases to test scripts Identifying new test cases Bug Fixing code review and reorganization Other updates ------------- Decide on focus Area (storage, sql, repl, caching) FOSS conference in MIT, Chennai One developer at bangalore - jitendra Training at lakshya on csql Design of main memory db - book ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs |
From: prabakaran <pra...@ya...> - 2008-01-01 15:25:21
|
Hi All, I have written an article on csql in slashdot.org Kindly go through and let me know your comments. http://slashdot.org/~prabacsql/journal/191820 Regards Prabakaran ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping |
From: prabakaran <pra...@ya...> - 2007-12-27 19:41:59
|
Hi All, This release includes 1.Primitive SQL Engine 2.Primitive JDBC driver 3.Interactive SQL tool 4.Bug Fixes you can download your copy at http://sourceforge.net/projects/csql/ It contains a) linux binaries b) source code c) Design Diagrams d) CSQL- Introduction Webinar Regards Prabakaran ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ |
From: prabakaran <pra...@ya...> - 2007-12-24 04:37:28
|
Mom updated in wiki ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs |
From: prabakaran <pra...@ya...> - 2007-12-22 10:30:29
|
Hi All, I was completely lost in here for the past two days. Have more good news and updates to share with you. Let us meet tommorow at 9 AM IST. Regards Prabakaran ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ |
From: Gopal S. <gop...@gm...> - 2007-12-19 15:20:43
|
Hi Praba. Say I have 2 tables cached from targetdb1. If in case csqlserver dumps core, cache contents are lost. Do we have some concept of auto-populating cache from targetdb1 ? Like having a cachedtables.conf. Regards Gopal S. prabakaran wrote: > forgot the attachment > > > > ____________________________________________________________________________________ > Never miss a thing. Make Yahoo your home page. > http://www.yahoo.com/r/hs > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > ------------------------------------------------------------------------ > > _______________________________________________ > Csql-core mailing list > Csq...@li... > https://lists.sourceforge.net/lists/listinfo/csql-core > |
From: Gopal S. <gop...@gm...> - 2007-12-19 14:59:19
|
Great Praba... All the best... Regards Gopal S. prabakaran wrote: > Hi All, > I am going to Bhubaneswar day after tommorow to > lakshya training division. Seminar is arranged for me > there with 500 students, where i am going to discuss > on various topics. I am going to talk about csql and > invite students to join the project. I have uploaded > the latest source under 1.2 Alpha release in our > project page. > Hoping that atleast 20 will join the project out of > 500. > Regards > Prabakaran > > > ____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > |
From: prabakaran <pra...@ya...> - 2007-12-19 13:57:16
|
forgot the attachment ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs |
From: prabakaran <pra...@ya...> - 2007-12-19 13:53:59
|
More good news.... csql - jdbc is 15-20 times faster than mysql(with memory storage engine)- jdbc. Also,attaching the presentation for CSQL. Regards Prabakaran ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping |
From: prabakaran <pra...@ya...> - 2007-12-18 15:20:24
|
Hi All, I am going to Bhubaneswar day after tommorow to lakshya training division. Seminar is arranged for me there with 500 students, where i am going to discuss on various topics. I am going to talk about csql and invite students to join the project. I have uploaded the latest source under 1.2 Alpha release in our project page. Hoping that atleast 20 will join the project out of 500. Regards Prabakaran ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ |
From: prabakaran <pra...@ya...> - 2007-12-17 14:50:15
|
Hi All, Some good news to share....... Current Performance Numbers: DMLTest (int key) ----------------- Total rows inserted 100 11103 191476 14521 100 rows selected 5168 16549 5660 100 rows updated 10195 20949 10678 100 rows deleted 10195 24022 11882 JDBCTest (int key) ------------------ Insert : 100 Min:17597 Max: 28491 Avg: 19147 Select : 100 Min:21089 Max: 36591 Avg: 22400 Update : 100 Min:17387 Max: 27444 Avg: 18255 Delete : 100 Min:16131 Max: 314308 Avg: 19918 Regards Prabakaran ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping |
From: prabakaran <pra...@ya...> - 2007-12-15 13:49:28
|
This Week: Bug Fixes Added sqlapi/jdbc/isql examples csql tool testing with sql statements Next Week: jdbc testing Finish user manual Mock Release GW architecture document ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs |
From: prabakaran <pra...@ya...> - 2007-12-15 06:38:00
|
Hi All, No meeting tommorow. Will send status updates later. Regards Prabakaran ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ |
From: prabakaran <pra...@ya...> - 2007-12-15 05:17:51
|
Check whether you have replaced the input string for parserr. README file in src/sql explains about how to do that. This is a manual procedure we need to follow after we fix anything in yacc or lex or when we build it first time. ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping |
From: Ganga B K. <gan...@gm...> - 2007-12-15 04:26:57
|
Any ideas? ganga@ganga-laptop:~/csql/install/bin$ ./csql CSQL>select * from t1; hello [Parser: syntax error] hello Statement prepare failed with error -19 - Ganga |