Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?

rubyonrails-talk
1

Hi all ,

I have create new application in rails with sqlite3 .

Its totally confusing to me when i see my database.yml file.

Reason of confusing is what type of extension is given to database ?

I have knowledge that by executing following line will create database :-

      sqlite3 test.db

See the extension of database is .db

But when i see my database.yml , extension of database is .sqlite3

database.yml is copied below.

What is extension of database in sqlite3 ?

In my database.yml file

SQLite version 3.x

gem install sqlite3

development:

adapter: sqlite3

database: db/development.sqlite3

pool: 5

timeout: 5000

Warning: The database defined as “test” will be erased and

re-generated from your development database when you run “rake”.

Do not set this db to the same as development or production.

test:

adapter: sqlite3

database: db/test.sqlite3

pool: 5

timeout: 5000

production:

adapter: sqlite3

database: db/production.sqlite3

pool: 5

timeout: 5000

Thanks

Best Regards

Fahim Babar Patel

2

Hi all ,

I have create new application in rails with sqlite3 .

Its totally confusing to me when i see my database.yml file.

Reason of confusing is what type of extension is given to database ?

I have knowledge that by executing following line will create database :-

      sqlite3 test.db

See the extension of database is .db

But when i see my database.yml , extension of database is .sqlite3

database.yml is copied below.

What is extension of database in sqlite3 ?

In my database.yml file

SQLite version 3.x

gem install sqlite3

development:

adapter: sqlite3

database: db/development.sqlite3

pool: 5

timeout: 5000

Warning: The database defined as “test” will be erased and

re-generated from your development database when you run “rake”.

Do not set this db to the same as development or production.

test:

adapter: sqlite3

database: db/test.sqlite3

pool: 5

timeout: 5000

production:

adapter: sqlite3

database: db/production.sqlite3

pool: 5

timeout: 5000

One more question how to switch database in Sqlite3.

In mysql we fire

use database_name

In postgre we fire

\c database_name

But what to fire in sqlite3 ?

3

Hi all ,

I have create new application in rails with sqlite3 . Its totally confusing to me when i see my database.yml file. Reason of confusing is what type of extension is given to database ?

I have knowledge that by executing following line will create database :-           sqlite3 test.db See the extension of database is .db

But when i see my database.yml , extension of database is .sqlite3 database.yml is copied below. What is extension of database in sqlite3 ?

You can use any extension you like. It is just a file.

4

man sqlite3 should show you.

Colin

5

Hi all ,

I have create new application in rails with sqlite3 .

Its totally confusing to me when i see my database.yml file.

Reason of confusing is what type of extension is given to database ?

I have knowledge that by executing following line will create database :-

      sqlite3 test.db

See the extension of database is .db

But when i see my database.yml , extension of database is .sqlite3

database.yml is copied below.

What is extension of database in sqlite3 ?

In my database.yml file

SQLite version 3.x

gem install sqlite3

development:

adapter: sqlite3

database: db/development.sqlite3

pool: 5

timeout: 5000

Warning: The database defined as “test” will be erased and

re-generated from your development database when you run “rake”.

Do not set this db to the same as development or production.

test:

adapter: sqlite3

database: db/test.sqlite3

pool: 5

timeout: 5000

production:

adapter: sqlite3

database: db/production.sqlite3

pool: 5

timeout: 5000

One more question how to switch database in Sqlite3.

In mysql we fire

use database_name

In postgre we fire

\c database_name

But what to fire in sqlite3 ?

man sqlite3 should show you.

One more question how to switch database in Sqlite3.

In mysql we fire

use database_name

In postgre we fire

\c database_name

But what to fire in sqlite3 ?

I do lots of google but i get nothing.

6

One more question how to switch database in Sqlite3.

In mysql we fire

use database_name

In postgre we fire

\c database_name

But what to fire in sqlite3 ?

I do lots of google but i get nothing.

You only have a single database in SQLite3, there is no need to select one.

Type “.help” inside the SQLite3 shell to learn more.

7

> > >> >> >> >> Hi all , >> >> I have create new application in rails with sqlite3 . >> Its totally confusing to me when i see my database.yml file. >> Reason of confusing is what type of extension is given to database ? >> >> I have knowledge that by executing following line will create database >> :- >> sqlite3 test.db >> See the extension of database is .db >> >> But when i see my database.yml , extension of database is .sqlite3 >> database.yml is copied below. >> What is extension of database in sqlite3 ? >> >> In my database.yml file >> SQLite version 3.x >> # gem install sqlite3 >> development: >> adapter: sqlite3 >> database: db/development.sqlite3 >> pool: 5 >> timeout: 5000 >> >> # Warning: The database defined as "test" will be erased and >> # re-generated from your development database when you run "rake". >> # Do not set this db to the same as development or production. >> test: >> adapter: sqlite3 >> database: db/test.sqlite3 >> pool: 5 >> timeout: 5000 >> >> production: >> adapter: sqlite3 >> database: db/production.sqlite3 >> pool: 5 >> timeout: 5000 >> > > > One more question how to switch database in Sqlite3. > In mysql we fire > use database_name > In postgre we fire > \c database_name > But what to fire in sqlite3 ?

man sqlite3 should show you.

One more question how to switch database in Sqlite3. In mysql we fire     use database_name In postgre we fire     \c database_name But what to fire in sqlite3 ? I do lots of google but i get nothing.

It is probably easiest just to exit sqlite3 and start it again on the other db.

Colin

8

Hi Fabian,

Go to yourapp/db

then you will see development.sqlite3 and test.sqlite3

Run

– sqlite3 development.sqlite3

– .databases

– .help

—.tables

check .help command you will know more commands on sqlite3

Thanks,

Saikiran Mothe

9

$ cd yourapp/db

$ sqlite3 develoment.sqlite3

$ .help

$ .databases

$ .use databasename

$ .tables

10

Well, not necessarily; see the ATTACH command.

11

Fabian,

You can Sqlite3 for development purpose,Its a lightweight database.for production you need to switch to postgresql,mysql,mongo.

Thanks,

Saikiran Mothe

12

Fabian,

You can Sqlite3 for development purpose,Its a lightweight database.for production you need to switch to postgresql,mysql,mongo.

Thanks,

Saikiran Mothe

$ cd yourapp/db

$ sqlite3 develoment.sqlite3

$ .help

$ .databases

$ .use databasename

$ .tables

Hi Fabian,

Go to yourapp/db

then you will see development.sqlite3 and test.sqlite3

Run

– sqlite3 development.sqlite3

– .databases

– .help

—.tables

check .help command you will know more commands on sqlite3

Thanks,

Saikiran Mothe

One more question how to switch database in Sqlite3.

In mysql we fire

use database_name

In postgre we fire

\c database_name

But what to fire in sqlite3 ?

I do lots of google but i get nothing.

You only have a single database in SQLite3, there is no need to select one.

Type “.help” inside the SQLite3 shell to learn more.

So over all which i understood is that in Sqlite we can use only one database at a time.

Is above statement is correct.

Thanks

Best Regards to All

Fahim Babar Patel

13

$sqlite3 develoment.sqlite3

use .sqlite3

14

No. Again, see the ATTACH command: ATTACH DATABASE

15

So over all which i understood is that in Sqlite we can use only one

database at a time.

Is above statement is correct.

No. Again, see the ATTACH command: http://www.sqlite.org/lang_attach.html

Attach database is different concept which you are saying ?

My question was

In mysql we fire below command

use database_name

In postgre we fire below command

\c database_name

But what to fire in sqlite3 to switch database?

@colin has given the answer is that you have exit open another database.

Waiting for your reply

Hope you will understood.

16

If you *read* the page I referred to, you'll see that you don't "switch" databases, you refer to the attached one(s) explicitly by name.

17

It works …

I attach development database to test.

18

I would think attaching the same db under a different name wouldn't be a great idea :slight_smile:

In any case, "name" and "file" seem pretty obvious; don't really know any use for "seq" offhand.