I had a disputation with one guy will GT.M work faster MySQL and PostgreSQL or not. I imitated processing of SQL SELECT query for one table and then we run test for one million records on the same test file. After this I made the site http://db.office-xxi.com where represented results of this tests. I want make GT.M more popular and for this I want develop SQL interface same as MySQL has but simpler and free of charge under Linux. For example, I want exclude any mention about indexes and create index for each field by default. There are and some other things for making this SQL variant as simple as possible but kept functionality not less MySQL. However, I have big doubts – is any sense in this? Will it attract new users or time and efforts will be waste. I would be very grateful for any comments or advices – work on this task or not?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I had a disputation with one guy will GT.M work faster MySQL and PostgreSQL or not. I imitated processing of SQL SELECT query for one table and then we run test for one million records on the same test file. After this I made the site http://db.office-xxi.com where represented results of this tests. I want make GT.M more popular and for this I want develop SQL interface same as MySQL has but simpler and free of charge under Linux. For example, I want exclude any mention about indexes and create index for each field by default. There are and some other things for making this SQL variant as simple as possible but kept functionality not less MySQL. However, I have big doubts – is any sense in this? Will it attract new users or time and efforts will be waste. I would be very grateful for any comments or advices – work on this task or not?
Vladimir --
http://db.office-xxi.com is very interesting, especially http://db.office-xxi.com/lessonsen.html - very nice and thanks for the pointer.
One recent free / open source development you may want to explore is PIP (http://www.fis-pip.com / http://sourceforge.net/projects/pip\). If you try it, please remember to follow the instructions at http://sourceforge.net/forum/forum.php?thread_id=1993315&forum_id=63826 to prevent passwords from expiring. You can post questions, comments and requests for help at the PIP forums (http://sourceforge.net/forum/?group_id=20183).
Regards
-- Bhaskar