It's possible that the question was referring to this statement in the About page on sqlite.org: "SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. Think of SQLite not as a replacement for Oracle but as a replacement for fopen()"
I usually refer to the sqlite database files as databases. Wes On Wed, Jul 15, 2009 at 10:38 PM, Rich Shepard<rshep...@appl-ecosys.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
