The tag has no wiki summary.

learn more… | top users | synonyms

5
votes
3answers
701 views

SQLite: Data entry interface?

I'd to like to use SQLite to start tracking a few things. I won't have any trouble setting up the database itself, but I'd struggle at programming an interface. Is there any kind of open source ...
3
votes
2answers
10k views

Open SQLite db in Microsoft Access?

Are there any tools to allow using sqlite databases from Microsoft Access? Of course full access is preferred, being able to edit records, add tables & fields, etc. but read-only browsing would ...
3
votes
4answers
4k views

Using SQLite3 with Cygwin

I'm trying to use sqlite3.exe command shell with a mintty terminal in cygwin. I tried the program from a windows command prompt and it works. When I try to use it from the cygwin mintty terminal it ...
2
votes
3answers
1k views

Restore sqlite3 on Mac OS X for Google Chrome

I was stupid enough to compile sqlite3 from source and install it to /usr, overriding default library. This being done, Google Chrome doesn't launch anymore, crashing with this output: Dyld Error ...
0
votes
1answer
917 views

PHP and SQLite V2 extension for Fedora 14

How can I add support for the PHP SQLite V2 extension on Fedora 14?
3
votes
2answers
3k views

Reading the *.sqlite files stored in the firefox profile

How would one go about reading the data in the *.sqlite files in one's profile? Trying to read them with sqlite3 was unsuccessful. $ sqlite3 SQLite version 3.7.4 Enter ".help" for instructions ...
0
votes
1answer
1k views

How can I import a CSV file into an SQLite table that doesn't allow null values?

I've been using the SQLite Manager extension for Firefox to edit my Chrome web data file in order to restore my keyword searches, and I think I have everything in place except that when I import a CSV ...
0
votes
0answers
102 views

SQLite DB borked when opened on a different machine

I'm using SQLite to store some data. The primary database is on a NAS (Debian Lenny, 2.6.15, armv4l) since the NAS runs a script which updates the data every day. A typical "select * from tableX" ...
0
votes
1answer
84 views

Arado Websearch - Lookup the URL-Bookmark Database within SQL, any tool available?

installed Arado Websearch ( http://arado.sf.net ) and entered some URLs and my Bookmarks into the Database, which is SQL, is there any tool available to look the Bookmarks up again in the Sql file?
0
votes
2answers
2k views

How to install sqlite from source on Mac?

I have seen this question on the source code of SQLite. However, I can not make sense on how to build SQLite on my Mac OS 10.6 from scratch, esp. an old version. What steps do I need?
1
vote
3answers
1k views

What is default admin for SQLite?

Workbench is MySQL default. Correct me if I'm wrong. I dont believe SQLite has it own default admin. Is there any recommendation for the admin?
0
votes
3answers
880 views

Delete old records from firefox sqlite databases

I have some big sqlite3 databases in ~/.mozilla/firefox/profilename Notably places.sqlite (12 MB) and urlclassifier3.sqlite (33 MB). Is it possible to truncate them and wipe out the oldest records ...
3
votes
1answer
1k views

how to enable command line autocomplete after sqlite

Once upon a time when I started sqlite from the command line I could using the tabbing autocomplete to enter the database name. This has not worked for a while now. Any suggestions on how to do this? ...
16
votes
5answers
12k views

Is it possible to open a sqlite database from within microsoft sql management studio?

Is there a way to open a .db file (sqlite database file) from within microsoft sql management studio? Right now we have a process that will grab the data from a microsoft sql server database and put ...
2
votes
2answers
611 views

Sqlite database on Mac

How can i download and install sqlite database on Mac? Also does Mac OS X come with sqlite database preinstalled? If yes then how can i find it?
1
vote
2answers
3k views

Problem with installing sqlite3 module for python 2.6 on an ubuntu system

I need to run the sqlite3 module on python 2.6 in an ubuntu system. How do I install this module for Python 2.6? Somehow I don't have this module, it raises the error: Python 2.6.5 (r265:79063, Mar ...
6
votes
3answers
5k views

How do I repair a corrupted Firefox places.sqlite database?

I had some problems with my RAM (bluescreen several times, Windows XP) and now are my Firefox databases damaged. Firefox is working, but my history is gone and it's reporting several inconsistencies ...
1
vote
1answer
188 views

Can't find .db or .log files on Vista

I have a cross platform program I wrote in Qt which creates log files (MyProg.log) and a sqlite3 database (myprog.db). I'm installing the program on Windows with Inno Setup. On Windows XP, the log ...
3
votes
1answer
944 views

Firefox “auto-complete” is very slow

Firefox version: 3.6 My places.sqlite is rather big (114MB, after being optimized by SpeedyFox.) If I turn on auto-complete, it may take 1 or 2 seconds for Firefox to accept a newly typed URL. To ...
7
votes
4answers
465 views

I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing ...
2
votes
1answer
1k views

Problem installing SQLite3 RubyGem on Ubuntu

I am having a problem trying to install the SQLite3 RubyGem. Here's what I'm doing: $ sudo gem install --remote sqlite3-ruby Here's the output: Building native extensions. This could take a ...
4
votes
2answers
1k views

SQLite with readline support on Ubuntu

I had the sqlite3 package installed on Ubuntu and there's no support for readline. That means there's no command history and those other nifty features readline gives you. Is this a configuration or ...