I like the idea of keeping SQLite strictly SQL Standard compliant. With strict compliance one has a very strong and highly transportable development platform to migrate a finished application to any SQL Standard compliant database. If all those vendor specific SQL Standard "extensions" are really required on arrival at the target, perhaps one has hit the wrong "target" :-)
I would like "Flame retardant suit on!" to see development continue toward things like stored procedures, extended SQL Standard compliance, enhanced Triggers, and anything that enhances support of user implemented multi seat access. But, if SQLite opens the multi user door too wide that will invite in a heard of those that want even "more!" (Bloat) IMHO. Perhaps it is time to consider, as some databases have, a "Local" and a "Server" implementation of SQLite. Easy for someone like me to ask for, as a non code contributor "user." :-) Fred > -----Original Message----- > From: P Kishor [mailto:[EMAIL PROTECTED] > Sent: Friday, January 11, 2008 1:19 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite --> PostGres > > > I have been writing an app using SQLite (great to develop with, and to > serve with to an extent), always with the intent of one day upsizing > it to PostGres (pain in the tush to develop with, but great to serve > with to any extent). Much to my delight, I am finding that y'all (the > SQLite developers) have made many things (for example, datatypes) > similar to PostGres (yes, I know most all about how SQLite datatypes). > My question -- why not take it all the way, and make SQLite almost a > mini-PostGres... wait, before you chide me -- I don't mean in the "add > more features" way, but in the "make syntax and datatypes as similar > as possible" way. > > For example, why have the "INTEGER PRIMARY KEY" when it could just as > easily be called "SERIAL"? > > One way might be to allow for aliases -- so, SERIAL would mean the > same as INTEGER PRIMARY KEY, or CHAR(3) would mean the same as TEXT > with a CHECK CONSTRAINT, and so on. > > Wouldn't that increase the already wildly popular appeal of SQLite > even more so without subtracting or weighing anything down? > > By the way, I didn't find a BLOB kind in PostGres -- is that the same > as BYTEA? If yes, that would be another candidate for such an alias. > > > -- > Puneet Kishor > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
