So I'm using SQLite, and I created my test.db
For some reason, I can't open this database. Not with Microsoft Excel nor notepad. I tried googling it, but there were way too many results of more advanced matters.
-
Why not use the SQLLite API, so, use a program to open it.James Black– James Black2011-03-15 23:41:37 +00:00Commented Mar 15, 2011 at 23:41
-
6uhhh Notepad and Excel are not programs that open database files.The Muffin Man– The Muffin Man2011-03-15 23:43:29 +00:00Commented Mar 15, 2011 at 23:43
Add a comment
|
6 Answers
If you are using Firefox as your browser, you can attach to the sqlite file from the SQLite Manager Add On.
Otherwise, you can install a full bodied program (SQLiteManager) to attach to it.
1 Comment
James Oltmans
This is much better suggestion than Zebediah49's SQLiteBrowser. SQLiteBrowser is fine for simple tasks but as soon as you give it even the slightest incorrect SQL query it crashes HARD.
Your problem is that the sqlite datatype is not a user-readable format.
It is compressed and optimised for storing the database, and thus can only be opened by sqlite, or something that uses sqlite.
For editing, I'd suggest something like SQLite Browser: http://sourceforge.net/projects/sqlitebrowser/
Comments
You can open an Sqlite database in excel if you dump it to a text file first.
Just download the sqlite3 browser from sourceforge, and type in
echo '.dump' | sqlite3.exe yourdatabase.db > atextfile.csv
And open the .csv file in Excel.
Comments
SQLite has a different internal format than anything that excel or notepad can open.
If you want to look at the database, you need to use the sqlite command line or a sqlite browser, like at http://sqlitebrowser.sourceforge.net/
Best of luck!
Comments
Why do you think you can open it with Excel or notepad? It's neither a text file neither a MS Excel spreadsheet.
SQLite DBs in general are intended to be used directly by your application via the appropriate SQLite libraries, still there are several frontends available to let you edit them directly.
First of all, there's the usual sqlite3.exe, which provides a command-line interface to operate on the DB; still, if you're not expert in SQL you may find it difficult to use.
Then there's the nice Sqliteman application, that lets you access SQLite DBs with a nice GUI.
Another possibility is to use VS.NET integrated DB viewer ("Server Explorer", IIRC) after you install the .NET SQLite provider.
Comments
You'll need the SQLite engine running on your machine. AFAIK it is embedded (or optionally embedded) into scripting language parsers like PHP and Python. I'm not sure if there's a GUI similar to MySQL Workbench that you can use to open up the DB, but it may be worth a shot on Google to see if there is.
