username & password in sqlite3

sqlite database-connection username
Raja picture Raja · Nov 27, 2009 · Viewed 47.9k times · Source

I am using sqlite3 in a linux machine and I am getting the database without username and password. Can I set a username and password for the same?

Answer

miku picture miku · Nov 27, 2009

No, sqlite3 databases are very lightweight systems. They need no server and all data is stored in one file. A username/password is not supported by the sqlite/sqlite3 package.

In order to achieve simplicity, SQLite has had to sacrifice other characteristics that some people find useful, such as high concurrency, fine-grained access control, a rich set of built-in functions, stored procedures, esoteric SQL language features, XML and/or Java extensions, tera- or peta-byte scalability, and so forth.

(sqlite, when to use)

However, since it's only a file you can encrypt the file with a password to protect your data.

Related questions

What if I don't close the database connection in Python SQLite

I am doing something like this... conn = sqlite3.connect(db_filename) with conn: cur = conn.cursor() cur.execute( ... ) with automatically commits the changes. But the docs say nothing about closing the connection. Actually I can use conn in later statements (…

Read More
Rails - Postgres - could not connect to server: Connection refused (PG::ConnectionBad)

Yesterday I've install Postgres and pgAdminIII, all worked correctly, but after reload it stopped working. After rails server I've got error message: => Booting Thin => Rails 3.2.13 application starting in development on http://0.0.0.0:3000 => Call with -d to detach => …

Read More
How to Close Sqlite Connection without explicitly calling Close Method using .NET

I am creating desktop application in winform that will use Sqlite Database. So I created Sqlite Helper class that uses System.Data.SQLite and each method of that Helper class opens and closes connection. But now I also added ability …

Read More