On 20 Oct 2010, at 12:11pm, Frank Millman wrote: > I am writing a generalised business/accounting application, which is > multi-company. I have got it working using MS SQL Server and PostgreSQL as > databases, and now I want to add sqlite3 as a third option, for small > single-user systems and for demo purposes. In the first two DBMS's, I use > the concept of a 'schema' to represent the different companies. They are all > in the same database, but I can refer to individual tables using > 'schema.tablename' notation. > > sqlite3 does not seem to have the equivalent of a schema in the same sense > as the other two, but I have got close by using the concept of separate > databases. So far this is the first time I have bumped my head. If this is > the only restriction, I can live with it.
Although you can find your familiar 'dot' notation in SQLite, the specialist use of it that SQLite makes (integrating data from two different files on disk) makes foreign key implementation impossible. I suggest you use underlines instead of dots in your code, and keep your data in the same database file. Or if the data comes from two different disk files, you would have to read it temporarily into one big file before doing your heavy processing. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
