Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sqlite]

The tag has no usage guidance.

2
votes
1answer
119 views

Macos Kernel Extension whitelisting issues

Trying to whitelist a kernel extension for an agent I'm trying to install. I'm using Mojave as the client machine and Profile Manger on a Mac server I've set up. I can enroll the client machine fine ...
1
vote
1answer
72 views

How do I extract and combine messages from Time Machine backups of ~/Library/Messages?

I have many backups that contain versions of ~/Library/Messages. Each one contains 3 files and a directory similar to this: XYZ:Messages user$ tree -a -L 1 . ├── Attachments ├── chat....
0
votes
1answer
144 views

Is there a way to view/edit Outlook for Mac's SQLite database to edit the signature file?

I am looking to edit the file or reference that is used in the SQLite database that Outlook uses on the Mac. Instead of having to copy and paste an HTML signature in the Outlook program, I would like ...
0
votes
3answers
192 views

Give local PHP Full Disk Access in Mojave

I have a PHP webpage running on the local apache installation. The page uses shell_exec to access the messages/chat.db via sqlite3. shell_exec("sudo -u ben sqlite3 ~/Library/messages/chat.db \"...
0
votes
0answers
34 views

Converting .accdb to sqlite on a mac - open to using terminal or homebrew

How would you convert a Microsoft Access database .accdb to SQLite on a Mac? (High Sierra)
0
votes
0answers
113 views

AppleScript Database Events, SQL query

I'm discovering Database Events and I created a script to store data daily: tell application "Database Events" tell database "Stats" set theRecord to make new record with properties {name:...
2
votes
0answers
21 views

Any solution for a DBMS App on iPhone?

I have been trying to find an application to create a database (preferably sqlite) And I would like to create relational databases and query, however, I haven’t found any on the App Store to enable me ...
0
votes
0answers
30 views

iCloud contains many hidden sensitive notes that I can't delete

When I delete notes from Notes.app, I expect them to be deleted. However, it's clear that iCloud is storing lots of old, deleted, confidential information, and I don't know how to get rid of it. I ...
3
votes
0answers
72 views

Extracting data out of an old app on iOS

I have an app from which I'd like to extract some data, it's no longer being updated and will stop working as soon as I upgrade to iOS 11 due to sun setting of 32 bit support. The app contains two ...
1
vote
1answer
332 views

Corrupted iOS backup - notes.sqlite is encrypted!

Well, one of my clients made an iTunes backup of her old iPhone right before she wipe and sell it. She never expected that the backup is corrupted till she got a new iPhone and tried to restore that ...
1
vote
0answers
28 views

Aperture AppleScript to flatten keyword heirarchy?

Aoerture allows you to have a keyword hierarchy. Unfortunately if you choose ("write keywords to masters" it doesn't apply the upper elements of the hierarchy, but only the leaf node. To get around ...
2
votes
1answer
118 views

Console log is telling me that database is locked for many apps. How do I unlock?

I'm trying to diagnose a MacMini that is painfully slow to start up. I already check the filesystem (fsck) and the disk (Disk Warrior). I am running High Sierra. My Mac is fine once it's up and ...
1
vote
1answer
433 views

How can I merge Notes from two Macbooks without using iCloud?

I have two laptops and both have different Notes that are useful to me. Not wanting to share any such data with Apple, they are also not synced to iCloud. So far, I found the path where they are ...
0
votes
1answer
104 views

How to access iMessage library using Sequel Pro on macOS

I'd like to access my iMessages using Sequel Pro. I have been told that they are in a sqllite file.
1
vote
1answer
1k views

What format does the apple notes sqlite db date use?

I want to extract the note texts and modification dates from an sqlite notes database extracted from an iOS device backup. But I can't figure out how to convert the date format to a readable date ...
1
vote
1answer
1k views

“Segmentation fault: 11” when trying to vacuum Apple Mail index

Reading up on how to improve my suddenly-very-slow Mail app, I found the tip to rebuild the sqlite index: sqlite3 ~/Library/Mail/V4/MailData/Envelope\ Index vacuum; But I get an immediate "...
4
votes
1answer
262 views

Is there some way to automatically find and remove all the “broken referenced” in Apple's Photo App?

I like apple's Photo app but I am not willing to let it manage my photos library for many reasons (eg I want to manage and edit the same files from different applications such as Bridge but I also ...
2
votes
0answers
256 views

Applescript - Reminders - Unbearably Slow

I wanted to write a script to "push" reminders back by an hour. I came up with this: tell application "Reminders" launch set c to current date set newtime to c + 3600 set the remind ...
0
votes
2answers
372 views

Force open a file with the UTF-8 encoding

I have a file that contains text. The file is not a text file, it is a SQL file. I want to open this file with the UTF-8 encoding in order to copy and paste the texts. So far, I'm trying to do it ...
0
votes
1answer
306 views

Contacts.app crashes on launch

My Contacts.app crashed on launch. In the crash report I found, among others, the following excerpt: Application Specific Information: *** Terminating app due to uncaught exception '...
2
votes
0answers
817 views

Using sqlite browser to extract OSX contacts [closed]

This is following up on this previous useful answer; I'd have left a comment there if i had the rep(: In case you have the same questions i did: First, i had to rename AddressBook-v22.abcddb to end ...
1
vote
1answer
3k views

Resolving “There is a problem with your mailboxes.” in El Capitan

I'm running into an identical problem with Mail on two separate systems, both starting immediately after upgrading from a long-working Yosemite to the new El Capitan and persisting through the latest ...
0
votes
1answer
337 views

MacPorts not working after power outage during build (sqlite disk I/O error)

I was building packages in MacPorts on a Mac Mini when the power went out. Now anything I try to do in MacPorts (install, clean, selfupdate) results in the following error: sqlite error: disk I/O ...
0
votes
1answer
2k 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
107 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 ...
3
votes
1answer
15k 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 ...
2
votes
2answers
7k 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
304 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
1k 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 ...
2
votes
2answers
2k 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
424 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
4answers
238 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
1k 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
115 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 /opt/local/...
1
vote
2answers
12k 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
2k 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 ...
19
votes
9answers
20k 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.