PostgreSQL has supported arrays for a number of years, and although I personally find the syntax to be a bit difficult to deal with, there's no doubt that arrays can simplify some database designs. (I ...

So for SQLite, change the bookid line in the CREATE TABLE statement above to this: bookid integer PRIMARY KEY, And, SQLite3 will create a table with equivalent settings to MariaDB and PostgreSQL. The ...