3 ms·
Yeah well, if you read the doc, you know that SQLite doesn't support the boolean type. "SQLite does not have a separate Boolean storage class. Instead, Boolean
by lenkite 3y ago
Yeah well, if you read the doc, you know that SQLite doesn't support the boolean type.
"SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true)."
If you choose the right SQL and right data-types, you can definitely have database independence. Our integration product (>10 years old) supports 4 diff databases for customers with a single, common code base. As long as you have the test-suites, its definitely doable. But you need to use a language which has a standard for interacting with databases.