[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