Re: [sqlite] Do people think of SQLite as a file or as a database

[Yan Bertrand]

Same here. For me the fact that it manages quick access to data through indexes 
- and uses SQL query language - makes it a database of its own right and merits.

-Message d'origine-
De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
De la part de Michal Seliga
Envoyé : jeudi 16 juillet 2009 09:18
À : General Discussion of SQLite Database
Objet : Re: [sqlite] Do people think of SQLite as a file or as a database

for me sqlite is database engine. and its files i call databases

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?
> 
> Thanks for your input in advance!
___
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

Re: [sqlite] Do people think of SQLite as a file or as a database

[Michal Seliga]

for me sqlite is database engine. and its files i call databases

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?
> 
> Thanks for your input in advance!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Do people think of SQLite as a file or as a database

[Nicolas Williams]

On Wed, Jul 15, 2009 at 07:11:51PM -0700, 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?

It's a database.  It happens to be stored in a file (or, if you use
ATTACH, several files).

Nico
-- 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Do people think of SQLite as a file or as a database

[Wes Freeman]

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 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
>      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

Re: [sqlite] Do people think of SQLite as a file or as a database

[Rich Shepard]

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.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 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