All right, I will start replying one by one. 1) Organizations tips: at cubrid.org there are two search engines, one of which is a subset of the other.
a) cubrid.org search - http://www.cubrid.org/?vid=&mid=home&act=IS&is_keyword=AUTO_INCREMENT It has quite advanced search engine powered by nLucene. You can search anything there, including all manuals, tutorials, and cubrid.org pages. b) Search in CUBRID Manual - http://www.cubrid.org/?vid=&mid=manual40&category=&search_target=title_content&search_keyword=AUTO_INCREMENT&act=dispXedocsSearchResults&x=0&y=0 All manuals at cubrid.org can be searched separately and filtered by versions. This is the same search engine, just results are filtered to CUBRID Manual for specific version, thus a subset of cubrid.org search. 2) As you might already know last week we have released a new version of CUBRID 8.4.0 which has about 90% SQL syntax compatibility with MySQL. So almost everything, including statements, data types and implicit type conversions are the same in CUBRID. Anyway, here are the exact answer for your questions. AUTO_INCREMENT - http://www.cubrid.org/manual/840/en/AUTO_INCREMENT%20Clause Just like you do in MySQL, for example: - CREATE TABLE t (i int AUTO_INCREMENT); - CREATE TABLE ss (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, text VARCHAR(32)); 3) LAST_INSERT_ID() - http://www.cubrid.org/manual/840/en/LAST_INSERT_ID%20Function Just like in MySQL: INSERT into ss VALUES(’cubrid’); SELECT LAST_INSERT_ID(); // should return the last value of an ID if it has an auto_increment constraint. All the common operators and functions in CUBRID must be the identical. If not, just lookup the manual. If that doesn't help, I am always here. 4) Like I said in CUBRID 8.4.0 SQL syntax is almost identical to that of MySQL. In this release we focused on two important aspects. One is index enhancement (the reason of x2 faster performance), the other is MySQL Compatibility phase II. 5) What do you mean by "If I write the adapter"? If you mean CUBRID Python API, then we already have it. But I suppose you mean a new CUBRID DB Layer for Web2py. In that case, of course. I can probably dedicate a separate developer who can assist you in getting acquainted with CUBRID and DBL development. Just let me know what you want. Esen. On May 17, 12:11 pm, Massimo Di Pierro <[email protected]> wrote: > Hello Esen, > > it should be very easy for us to suport cubrid and I like the support > for sequence types. But we need some information that is not in the > online manual (at least I could not find it). > > How do I define a table with an autoincrement integer field? > How do I get the 'id' of the last inserted record? > Is the SQL syntax closer to MySQL, PostgreSQL, MSSQL or other? > > If I write the adapter, would you help me run the tests? > > Massimo > > On May 16, 8:37 pm, CUBRID RDBMS <[email protected]> wrote: > > > > > > > > > Hi, > > > I work at the CUBRID DBMS Project. I will be glad to respond to your > > questions, if you any particular. > > > In general, CUBRID is an open source relational database management > > system available on Linux and Windows platforms. CUBRID Manager, its > > most powerful database administration tool, is also available for Mac > > OS X. There are all kinds of programming APIs, including for Python. > > In fact, this or coming week we will update our Python API as a result > > of a new CUBRID 8.4.0 release, which will be more stable and will > > introduce new features available in the new database release. > > > Users can install CUBRID Python API directly from PYPI (http:// > > pypi.python.org/pypi/CUBRID-Python) which also distributes its source > > code. > > Other information about the driver, including the API manual, can be > > found on its official page athttp://www.cubrid.org/python_programming. > > > For the support, users can post their issues on the CUBRID Python > > forum athttp://forum.cubrid.org/viewforum.php?f=28. > > > If you have any question or suggestions, or would like to contribute > > in API development/documentaion, or have any other thought, feel free > > to contact me. I will be glad to hear from you. > > > Best Regards, > > Esen Sagynov. > > CUBRID Project > > Manager.http://www.cubrid.org/http://twitter.com/cubridhttp://facebook.com/cu... > > > On May 17, 6:48 am, mikech <[email protected]> wrote: > > > > Has anyone come across this DB? Seems like it might be big in Korea. The > > > screen shots of the manager app looks interesting. > > > >http://www.cubrid.org/home
