The night passes by, and you are already active. Massimo, you are quick, man! Thanks for your efforts.
And here are a few thing I would like to comment on. 1) As you have already noticed, you MUST start the db before connecting to or using it. Thus, you can control yourself which databases are ON, while turning OFF those which you do not need. b) You can also set to auto start the particular database(s) in case you are sure that you will always need to connect to it. See "Auto Start Database" at http://www.cubrid.org/manual/840/en/Managing%20Service. Briefly: - Select the host - then choose the "Action" menu - Choose "Properties" submenu. - Under the "Configure Parameter" click on the "Start Service" node. Then select which databases you would like to have auto started. 2) LAST_INSERT_ID is a part of MySQL Compatibility phase II, which is available since CUBRID 8.4.0. I would not mind if you put in the system requirements as CUBRID 8.4.0 and higher. After all, it's the most advanced and fastest engine so far. 3) I will open an issue for CUBRID Python API to fix the 'Unknown DBMS Error". We should display more information if a user forgets to turn ON the db. 4) DenesL, maybe you would want Massimo to see your patch, so that the work is more efficient than repeating each other. Talk to him. 5) I will now proceed with the testing. Once have results/issues, will post it here. 6) I will help to create a page for Web2py on cubrid.org/projects once Massimo confirms. So far, thanks to everybody for your contributions. I am very happy! Have a great day! Esen. On May 18, 5:55 am, DenesL <[email protected]> wrote: > LAST_INSERT_ID seems to be available only in Cubrid 8.4.0 (beta). > But after reinstalling version 8.4.0 I can not connect to it (worked > in 8.3.1) even after: > > C:\CUBRID\bin>cubrid server start demodb > ++ cubrid server start: success > > On May 17, 2:39 pm, DenesL <[email protected]> wrote: > > > > > > > > > Connect working after issuing > > > cubrid server start demodb > > > Testing... > > > On May 17, 10:58 am, DenesL <[email protected]> wrote: > > > > I mean that I patched the dal myself ;) > > > > Anyways, I have trouble connecting even from outside web2py. > > > Tried with 8.4.0 beta and 8.3.1 but I keep getting an error with the > > > demodb created during install: > > > > >>> conn = cubriddb.connect('localhost', 30000, 'demodb', 'dba', '') > > > > Traceback (most recent call last): > > > File "<pyshell#1>", line 1, in <module> > > > conn = cubriddb.connect('localhost', 30000, 'demodb', 'dba', '') > > > File "C:\Python26\lib\cubriddb.py", line 170, in __init__ > > > self._db = cubrid.connect(*args, **kwargs) > > > Error: (-1, 'ERROR: DBMS, 0, Unknown DBMS Error') > > > > >>> conn = cubriddb.connect('localhost', 30000, 'demodb') > > > > Traceback (most recent call last): > > > File "<pyshell#2>", line 1, in <module> > > > conn = cubriddb.connect('localhost', 30000, 'demodb') > > > File "C:\Python26\lib\cubriddb.py", line 170, in __init__ > > > self._db = cubrid.connect(*args, **kwargs) > > > Error: (-1, 'ERROR: DBMS, 0, Unknown DBMS Error') > > > > On May 17, 9:38 am, Massimo Di Pierro <[email protected]> > > > wrote: > > > > > :-) > > > > > Of course! It is in trunk. I have not tested it and I am not (yet) > > > > taking advantage of the sequence type and the full-text support (we > > > > need a more global strategy for that). > > > > > If anybody wants to try it: > > > > > 1) install cubriddb > > > > 2) use > > > > > db = DAL('cubrid://username:password@hostname:port/dbname') > > > > > Let me know if it works or what errors you get. > > > > > Massimo > > > > > On May 17, 2:00 am, pbreit <[email protected]> wrote: > > > > > > If it's pretty much compatible with MySQL, I'm guessing Massimo will > > > > > have it > > > > > supported in DAL by the time we wake up > > > > > tomorrow!http://code.google.com/p/web2py/source/browse/gluon/dal.py > > > > > > The performance and scalability features do sound attractive. I'm not > > > > > sure > > > > > I'd switch off of Postgres at this point but it might be worthwhile > > > > > to try > > > > > it out on a project.
