The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
177 views

Can I run an SQLite operation from Terminal?

When I download transactions in Quicken Essentials for Mac, my bank adds "DEBIT PURCHASE" and other junk to the Payee info. Quicken has no ability to find and replace globally. But I dug into the ...
1
vote
2answers
2k views

How to enable Sqlite on a Mac OS X Mavericks

I upgraded my Mac with OS X Mavericks last week. It appears to have taken away support for Sqlite -- not Sqlite3, but sqlite. I need that for a website I work on. I went to Sqlite's website, but ...
0
votes
0answers
65 views

Making iTunes restore edited iTunes backups

When you enter names in the To field when sending SMS from iPhone, numbers and names you deleted a year ago come up as auto-complete. This is a design blunder and a huge annoyance. I found these ...
1
vote
0answers
77 views

Navicat lite connection failed

I am trying to connect to SQL server using navicat lite. However, it kept throwing this error: Connection Failed [FreeTDS][SQL Server]???? 'sa' ?????????????? [FreeTDS][SQL Server]Unable to connect ...
0
votes
1answer
266 views

SQLite Manager 4 : unable to open database file

I have recently purchased and installed the software SQLite Manager 4, now I am creating new SQLite3 database and whenever I try to create new table with 'xyz' name with any number of column, it gives ...
1
vote
1answer
434 views

Can the SQLite databases that store iOS mail be exploited to back up messages?

Being the technical dude of the family I'm confronted with the following problem: An iPhone 3GS with iOS 3.1.2, the owner has a lot of old email messages stored on the device but has lost access to ...
1
vote
1answer
189 views

Error while Compressing the Mail DB: file is encrypted or is not a database

I am trying to compress the Mail database by running the sqlite3 vacuum command. But I get the following error: SQL Error: file is encrypted or is not a database I was running Mac OS 10.6 and I ...
0
votes
3answers
201 views

Mountain Lion - Does it allow different users to share database files using iCloud?

If a small business wanted to share a common database between all of its employees, is it possible to create a single iCloud account for a specific App rather than for all the iCloud related software ...
1
vote
2answers
518 views

editing a sqllite database from the command line within an iPad

I'm running a technical demo - it requires altering a SQLite database on an jailbroken iPad. At the moment I'm pulling the database off via SCP and altering it with a GUI I have lying around, (very ...
0
votes
1answer
101 views

Apache module run under MacPorts gives SQLite error

I have an Apache module, compiled from source, which works just fine with the stock Apache 2.2 on Mac OS X 10.5 through 10.7. However, under the Apache 2.2.22 installed by MacPorts, running ...
1
vote
2answers
2k views

How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on Mac OS X 10.7?

I'm running Mac OS X 10.7. How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on the system?
1
vote
0answers
1k views

iOS 5 now encrypts my text message backup?

I've always used MesaSQLite to open the SQLite database that stores my iPhone's text messages. I've also used python's sqlite3 module to programmatically do some things with my text messages. After I ...
8
votes
8answers
7k views

SQLite frontend for OS X?

I am looking for a preferably free SQLite frontend to use under OS X. Something similar to MySQL Workbench will do. Put separate suggestions in separate answers.