Menu

#4 Remove heavy usage of mySQL features

open
5
2012-09-14
2009-09-25
No

When fSQL started, I picked mySQL which was very popular at the time to base fSQL syntax and functions on and it stuck. There's some mySQL-specific queries (SHOW, DESCRIBE, USE) and functions that, unless you're program actually needs, are taking up a lot of space. With the split of schemas and databases in v1.4, fSQL should start to phase out using only the mySQL feature set and move towards a more SQL standard feature set with additions. Some compatibility additions for postgreSQL, SQLite and others would help the situation as well.

Perhaps it would be best to move mySQL specific features into separate classes that be included and enabled from the fSQLEnvironment and add support other compatibility modes like postgresql.

fSQL should at the bare minimum include all SQL Standard types and functions that it can support.

Discussion


Log in to post a comment.