[Ur] SQL error using sqlite
Marc Weber
marco-oweber at gmx.de
Wed Dec 15 22:16:14 EST 2010
Excerpts from Chris Double's message of Thu Dec 16 03:08:18 +0100 2010:
> sqlite3 example.db <example.sql
> Error: near line 1: near "-": syntax error
Do yourself a favour and use postgresql.
Why? All the databases have a slightly different understanding of what
SQL is - and urweb was optimized for postgresql.
This statement is not based on urweb + sqlite experience - but on
experience I got working with all those databases.
Eg sqlite doesn't let you drop columns without recreating the database.
So there are even more reasons. Of course it depends on your priorities.
Yours
Marc Weber
More information about the Ur
mailing list