Hi all, Im new in this list and with sqlite. Im not sure if this topic have been discussed before.
Anyway, I have this problem regarding sqlite. I created a c program that would create a new sqlite database from some sql file then update it every five minutes using sql statement stored in a postgresql database. Im using a version 3.3.2 sqlite database and sqlite3 library in c. The sqlite database and c program was executed in a linux OS. When I tried to open my created database in a SQLite database browser in windows It shows nothing but in linux it shows the correct tables and data. Also, I create a sqlite database in windows then open it in linux it works fine. Also, I created a simple sqlite database manually but it still cant be read in windows. Is there a compatibility problem with database created in linux and windows? I remember this problem on occurs on sqlite version 2.6.2 or earlier.. Or is there a problem in the way I create the database? The sqlite browser im using can read sqlite database version 3.x. Thanks