Guides on managing and optimizing SQLite

November 17, 2019

How to Add Unsigned Integer Column in SQLite

If you came from a MySQL background, you might be puzzle to find out that SQLite and many others like PostgreSQL actually do not have a unsigned integer data type. The reason is because...


July 30, 2019

How to Workaround Unsigned Integer for SQLite in Laravel Migration

Here's my setup: I use MySQL for dev + production and SQLite for testing. If you use a similar setup and your codes depend on MySQL's unsigned property to store only positive numbers,...


Sign up for our newsletter