• Ciwan
  • Passenger
  • Offline
  • From: The Milky Way
  • Registered: 2011-02-24
  • Posts: 25

Topic: Working with SQLite 3

Hi Guys

I'm building a web app using RoR 3 and SQLite 3. I have done my database migrations.

My question is > How can I now query the database directly ? I know on mysql you can type something like:

mysql -u user -p database_name

But what does one do for SQLite 3 ?

I would greatly appreciate any help.

Thank You.

"Facts do not cease to exist because they are ignored." .... Writer Aldous Huxley (1894 - 1963)
  • From: Belgium
  • Registered: 2008-11-25
  • Posts: 1,357

Re: Working with SQLite 3

you can use Rails console, I think it's much easier to :

rails c
#use Activerecord ORM here to operate your models, etc.

Or if you really prefer to use pure SQL queries (I really don't see why sad) you can read more details here: http://www.sqlite.org/sqlite.html

Last edited by Javix (2011-03-27 16:26:19)

  • Registered: 2013-03-08
  • Posts: 1

Re: Working with SQLite 3

Ciwan

Here is an ORM that works with Sqlite
https://www.kellermansoftware.com/p-47- … layer.aspx

  • Registered: 2013-03-12
  • Posts: 15

Re: Working with SQLite 3

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

Semaphore Software Joomla Development Blog
  • Registered: 2013-03-18
  • Posts: 20

Re: Working with SQLite 3

That's another question I have - i know sqlite3 is limited - is the limitation (i believe) that you can't have multiple separate databases on sqllite or is their a record limitation?  (I'm going to be running databases, multiple ones, that have 100s of thousands of rows added on a yearly basis)