On Wed, 15 Jul 2009, CadMapper wrote: > This is not a technical question about SQLite. I want to you how people > in general think about SQLite. Is that a file or a database? When you > talk about it, do you refer to it as file or database?
Neither. It is a database management system used to create, maintain, and query multiple databases. Each database is physically stored on the hard drive as a single file that contains the DDL, tables, data, indices, and so on. A file is a storage unit. A database is a set of defined tables, attributes, rows, indices, relations, transactions, stored procedures, etc. all related to a common purpose. Your question suggests a lack of understanding of database systems, SQL, and the separation of logical organization from physical storage on a device. I suggest that you do a bit of research on the Web about database management systems (DBMSs). Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
