-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 stephen liu wrote: > I want to save multipile sqlite database in one file.
Generally that is a bad approach and instead you use more tables and normalize your data more. However you know your situation better. > The backup api is not fix for this requirement. True. If your container file is a zip archive or something similar then you could use the backup api and temporary files. > I want to save sqlite database as a entry of the dbm. If you really have to store the sqlite databases as blobs, why not store them in yet another sqlite database as a blob instead of inside dbm? SQLite has the drawback of not letting you resize a blob (you have to create a new value with the new length) but it doesn't look like the dbm api lets you either. Unless your dbm implementation has proper transactions you could also lose data. > For example, the user's addressbook save in a sqlite database, > and the buffer of the database may be store in a dbm. That example would definitely be done better using more tables and normalization (users don't like addressbooks to be unreliable). I assume there is more to it that you have told us. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkn39c4ACgkQmOOfHg372QQR/ACfYbodduOWRUbMhzdEkCo+SuRg X0UAnAv6HrU+znaEUpDaifHj6JPOFphz =HUJa -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users