The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
45 views

Mac OS X Mavericks Contacts Database is a SQLite db, how can i open it with a SQLite App?

i have an Sqlite Browser App. I would like to view and extract all Contacts of the Contacts App for further use in a FileMaker Pro file ... How can i connect to this database and export its content ? ...
0
votes
1answer
42 views

Show today’s anniversaries (if any) from contacts

I would like to be able to run a script which would look through my Contacts list and output the name (and, preferably, phone number) of anyone whose ‘Anniversary’ date matches today. (The script ...
1
vote
1answer
1k 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
3k 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 ...
1
vote
0answers
142 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
368 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
599 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
239 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
208 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
653 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
102 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
3k 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 ...
10
votes
8answers
10k 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.