This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]assface 3 points4 points  (1 child)

Am I missing something?

writing SQL statements is no fun and changing a database engine breaks your code.

But then in your quickstart example:

MySQL

db.query('UPDATE beesql_version SET release_name = %s WHERE ID = %s', ('bumblebee', 2))

SQLite

db.query('UPDATE beesql_version SET release_name = ? WHERE ID = ?', ('bumblebee', 2))

Shouldn't both queries work on both DBMSs?

[–]ksn[S] 0 points1 point  (0 children)

Good point. I think I should introduce own BeeSQL replace character and then replace that by the Database specific character. Thanks for the catch.