Page History
- 2007-Dec-30 10:13 anonymous
- 2007-Dec-03 15:17 anonymous
- 2007-Nov-13 09:23 anonymous
- 2007-Aug-23 20:32 anonymous
- 2007-Aug-07 23:18 anonymous
- 2007-Jul-24 05:05 anonymous
- 2007-Jun-22 15:27 anonymous
- 2007-Jun-22 15:01 anonymous
- 2007-Jun-22 14:43 anonymous
- 2007-Jan-10 14:36 anonymous
- 2006-Dec-20 03:19 anonymous
- 2006-Oct-28 18:13 anonymous
- 2006-Oct-07 17:30 anonymous
- 2006-Oct-07 17:27 anonymous
- 2006-Sep-15 13:51 anonymous
- 2006-Aug-29 08:58 anonymous
- 2006-Jul-24 01:25 anonymous
- 2006-Jul-24 01:22 anonymous
- 2006-Jul-24 01:18 anonymous
- 2006-May-19 09:19 anonymous
- 2006-May-01 16:16 anonymous
- 2006-Apr-28 17:57 anonymous
- 2006-Apr-27 22:08 anonymous
- 2006-Apr-18 12:36 anonymous
- 2006-Apr-12 17:41 anonymous
- 2006-Apr-12 09:50 anonymous
- 2006-Apr-07 16:56 anonymous
- 2006-Apr-04 16:30 anonymous
- 2006-Apr-04 10:28 anonymous
- 2006-Apr-02 10:57 anonymous
- 2006-Apr-01 07:45 anonymous
- 2006-Apr-01 07:41 anonymous
- 2006-Mar-28 16:46 anonymous
- 2006-Mar-28 16:32 anonymous
- 2006-Mar-27 17:50 anonymous
- 2006-Mar-20 18:05 anonymous
- 2006-Mar-20 17:57 anonymous
- 2006-Mar-20 17:53 anonymous
- 2006-Mar-20 14:24 anonymous
- 2006-Mar-20 12:12 anonymous
- 2006-Mar-19 21:48 anonymous
- 2006-Mar-19 21:27 anonymous
- 2006-Mar-19 21:20 anonymous
- 2006-Mar-19 21:13 anonymous
- 2006-Mar-19 21:12 anonymous
- 2006-Mar-19 21:08 anonymous
- 2006-Mar-19 21:06 anonymous
- 2006-Mar-19 21:04 anonymous
- 2006-Mar-19 20:58 anonymous
- 2006-Mar-19 20:54 anonymous
- 2006-Mar-19 20:53 anonymous
- 2006-Mar-19 20:49 anonymous
- 2006-Mar-19 20:41 anonymous
- 2006-Mar-19 20:33 anonymous
- 2006-Mar-19 20:31 anonymous
- 2006-Mar-19 20:12 anonymous
- 2006-Mar-06 16:12 anonymous
- 2006-Mar-06 16:11 anonymous
- 2006-Mar-06 01:27 anonymous
- 2006-Feb-21 05:24 anonymous
- 2006-Feb-20 17:35 anonymous
- 2006-Feb-19 10:33 anonymous
- 2006-Feb-17 23:11 anonymous
- 2006-Feb-16 22:49 anonymous
- 2006-Feb-15 16:05 anonymous
- 2006-Feb-15 10:38 anonymous
- 2006-Feb-15 01:13 anonymous
- 2006-Feb-04 15:18 anonymous
- 2006-Jan-24 21:52 anonymous
- 2006-Jan-20 13:02 anonymous
- 2006-Jan-20 12:38 anonymous
- 2006-Jan-20 12:32 anonymous
- 2006-Jan-19 22:20 anonymous
- 2006-Jan-19 22:19 anonymous
- 2006-Jan-19 04:05 anonymous
- 2006-Jan-14 21:56 anonymous
- 2006-Jan-02 13:38 anonymous
- 2005-Dec-27 16:15 anonymous
- 2005-Dec-17 23:29 anonymous
- 2005-Nov-21 11:17 anonymous
- 2005-Oct-19 05:14 anonymous
- 2005-Oct-06 20:49 anonymous
- 2005-Oct-06 20:19 anonymous
- 2005-Oct-04 07:06 anonymous
- 2005-Oct-02 02:51 anonymous
- 2005-Sep-30 16:56 anonymous
- 2005-Sep-25 07:17 anonymous
- 2005-Sep-21 18:28 anonymous
- 2005-Sep-21 18:24 anonymous
- 2005-Sep-21 14:58 anonymous
- 2005-Sep-21 00:29 anonymous
- 2005-Sep-06 16:36 drh
- 2005-Sep-06 13:52 anonymous
- 2005-Aug-29 17:22 drh
- 2005-Aug-29 16:30 anonymous
- 2005-Aug-25 03:31 anonymous
- 2005-Aug-18 09:09 anonymous
- 2005-Aug-13 01:43 anonymous
- 2005-Aug-12 11:41 anonymous
- 2005-Aug-09 12:41 anonymous
- 2005-Aug-09 12:18 anonymous
- 2005-Aug-03 21:43 anonymous
- 2005-Jun-01 02:32 anonymous
- 2005-May-26 02:08 anonymous
- 2005-Apr-27 19:04 anonymous
- 2005-Apr-19 22:02 anonymous
- 2005-Apr-11 17:41 anonymous
- 2005-Apr-11 13:24 anonymous
- 2005-Apr-08 20:43 anonymous
- 2005-Apr-08 19:29 anonymous
- 2005-Mar-06 12:01 anonymous
- 2005-Feb-28 21:36 anonymous
- 2005-Feb-27 11:37 anonymous
- 2005-Feb-04 03:28 anonymous
- 2005-Jan-22 22:09 anonymous
- 2005-Jan-22 11:53 anonymous
- 2005-Jan-16 10:39 anonymous
- 2005-Jan-16 08:04 anonymous
- 2004-Nov-23 04:51 anonymous
- 2004-Nov-17 19:51 anonymous
- 2004-Oct-27 16:00 anonymous
- 2004-Oct-26 18:39 anonymous
- 2004-Oct-21 16:53 anonymous
- 2004-Oct-03 22:24 anonymous
- 2004-Oct-03 12:57 anonymous
- 2004-Sep-02 18:06 anonymous
- 2004-Aug-29 14:26 anonymous
- 2004-Jul-29 15:22 anonymous
- 2004-Jul-20 14:59 anonymous
- 2004-Jun-26 14:46 anonymous
- 2004-Jun-09 18:43 anonymous
- 2004-May-11 13:31 anonymous
- 2004-May-06 09:32 anonymous
- 2004-May-06 01:37 anonymous
- 2004-May-05 22:17 anonymous
- 2004-Apr-25 16:34 anonymous
- 2004-Apr-25 15:26 anonymous
- 2004-Apr-16 09:19 anonymous
- 2004-Apr-10 19:03 dougcurrie
- 2004-Apr-10 12:33 anonymous
- 2004-Apr-08 00:22 anonymous
- 2004-Apr-07 19:56 anonymous
- 2004-Apr-07 19:53 anonymous
- 2004-Apr-03 16:28 anonymous
- 2004-Mar-26 07:00 anonymous
- 2004-Mar-18 03:55 anonymous
- 2004-Mar-18 01:10 anonymous
- 2004-Mar-17 21:33 anonymous
- 2004-Mar-09 14:45 anonymous
- 2004-Mar-07 00:44 anonymous
- 2004-Feb-28 14:40 drh
- 2004-Feb-25 19:44 anonymous
- 2004-Feb-18 11:13 anonymous
- 2004-Feb-16 14:00 anonymous
- 2004-Jan-29 23:40 anonymous
- 2004-Jan-22 23:40 drh
- 2004-Jan-22 21:39 anonymous
- 2004-Jan-08 22:10 anonymous
- 2004-Jan-01 00:41 anonymous
- 2003-Dec-18 06:01 anonymous
- 2003-Nov-19 05:11 anonymous
- 2003-Nov-19 05:09 anonymous
- 2003-Oct-30 15:09 anonymous
- 2003-Sep-04 17:18 anonymous
- 2003-Aug-29 15:45 anonymous
- 2003-Aug-06 00:18 anonymous
- 2003-Aug-06 00:13 anonymous
- 2003-Aug-05 21:39 anonymous
- 2003-Jul-28 03:20 anonymous
- 2003-Jul-28 03:18 anonymous
- 2003-Jul-02 10:09 anonymous
- 2003-Jul-02 07:34 anonymous
- 2003-Jun-30 10:33 drh
- SQL92 Character sets, collations, coercibility.
- Inserting blob using X'AABBCCDD' syntax.
- Stored Procedures
- Rollup and Cube - Who can tell me what this means?
-
I don't know much about it myself, but a quick google on the subject gives me... http://
www.winnetmag.com/SQLServer/Article/ArticleID/5104/5104.html and http://databases.about.com/
library/weekly/aa070101a.htm
both of these imply that the CUBE operator causes new rows to be generated to give a wildcard
value to non-numeric columns and summing the numeric columns which match those wildcards. The
potential for generating a huge amount of data with cube is implicit, I think - hence its name. ROLLUP
appears to be related but removes some of the wildcards; I couldn't determine what from the limited
information in the articles. I could not find, on brief examination any more definitive reference. Anyone
got something more definitive than those articles ? It seems to me that you can do with sum()
everything you can do with CUBE.
- INSERT INTO with multiple rows (ie. INSERT INTO table VALUES (...), (...). etc)
- CREATE DATABASE, DROP DATABASE - Does not seem meaningful for an embedded database engine like SQLite. To create a new database, just do sqlite_open(). To drop a database, delete the file.
- ALTER VIEW, ALTER TRIGGER, ALTER TABLE
- Schemas - Who can tell me what this means?
-
The idea is that multiple users using the same database can cleanly
separate their tables, views (stored procs, etc) by prefixing them with
their login, so jack's jack.importantTable is distinct from jill's jill.importantTable. There are
administrative benefits ('Jack left and
we don't like his work; can we kill everything he did?' Ans: 'Yes, let me just
drop his schema..', with aliases, jill.importantTable can be made available to everybody as
'importantTable', permissions can be hung off schemas). The common notation (jill.importantTable)
would map to databasename.tablename in the current sqlite arrangement.
- TRUNCATE (MySQL, Postgresql and Oracle have it... but I dont know if this is a standard command) - SQLite does this automatically when you do a DELETE without a WHERE clause.
- ORDER BY myfield ASC NULLS LAST (Oracle)
- CREATE TRIGGER [BEFORE | AFTER | INSTEAD OF] (Oracle)
- UPDATE with a FROM clause (not sure if this is standard, Sybase and Microsoft have it).
- Multi-column IN clause (ie. SELECT * FROM tab WHERE (key1, key2) IN (SELECT...)
- CURRENT-Functions like CURRENT_DATE, CURRENT_TIME are missing
- INSERTing less values than columns does not fill the missing columns with the default values; if less values than columns in the table are supplied, all columns filled have to be named before the keyword values
- rename table command (mysql has)
- ESCAPE clause for LIKE
- DISTINCT ON (expr,...) - this is from Postgres, where expr,... must be the leftmost expressions from the ORDER BY clause
- MEDIAN and standard deviation... are they standard? Useful for sqlite standalone (for shell script users)
- enum column type (mysql does)
- join syntax (+) (-) like oracle has - SQLite used to have this but it was removed because it is not standard SQL.
- name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)
- FLOOR and CEILING functions, e.g. "SELECT FLOOR(salary) FROM personnel;"