From: Sergey V. U. <ser...@cl...> - 2001-08-06 22:07:16
|
Hi all > Ok. I hope this version will be released soon (SqlPlugin is almost ready > - I just have to add some final touches to SqlVFS). Well, the very strange thing SqlVFS is almost in place. Oracle and MySQL are supported at the moment. There is 3-level structure: 1. DB configurations. 2. Table groups (database for mysql, schemes/users for oracle). 3. Tables themselves. Almost AS/400 filesystem:))) Probably I would be able to implement some semantics of "load" or "open" on particular table. But I am not sure what it should be. There are variants: 1. Create DDL statement in the new buffer ( "CREATE TABLE name ( FIELD NUMBER, .... ); " ) 2. Just create text dump ( CVS? ) of the table data in the new buffer. Very dangerous for large tables. The restriction on number of rows can be applied. 3. Load SQL Result Set window with the table data (so no new buffer would be created). The restriction on number of rows is applied here. 4. Load SQL Result Set window with the table meta-date (see the result of SHOW TABLE in mysql). 5. Just create the statement "SELECT * FROM tablename" in the new buffer. So user can run it using same SqlPlugin:) 6. Any other ideas. I am not sure what would be the best thing for users. For implementing, the most interesting ones are most difficult ones (I already _really_ _really_ hate mysql for his non-ANSI SHOW statements:). So there is a poll for everyone who would like to use jEdit with databases (or at least has some opinion on this subject). Actually, without "load" function my SqlPlugin in CVS is ready for testing. I am not going to make release before XML plugin promised by Slava (with Xerces) and probably before I will make something about "load"/"open" functions. But if you have AntFarm (i.e. crimson) installed - you already can play with mysql and oracle (definitely, I would be grateful to anyone contributing configuration files for PostgreSQL, MS SQL, mSQL :) Thanks for any comments Sergey |