Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
87 views

Understanding Mac IdentityServices

I'm trying to understand the information included in the Identity Services folder on my Mac. Is there a way to differentiate between sent and received within idstatuscache.plist and ids-pub-id.db? ...
user avatar
0 votes
0 answers
25 views

MacBook StatusKit explanation? (~/Library/StatusKit/database)

When browsing the Library folder on Mac (~/Library/StatusKit/database), I'm trying to figure out what information is included in statuskit-cloud.db. Specifically the following tables: ZINVITEDUSER ...
user avatar
0 votes
0 answers
47 views

Trying to restore deleted iMessage messages to the application

So I’ve spoken with apple support and it seems that the MacBooks get forwarded copies of the iMessages to the device. As such it stores them locally in the library messages and archive folder. All the ...
user avatar
3 votes
1 answer
314 views

Is there a way to merge Safari history databases?

Recently Safari had a glitch and wiped out my browsing history. I only discovered this after a couple weeks but had a backup that ran up to almost the day of the loss. I've restored the history from ...
user avatar
  • 10.6k
2 votes
1 answer
40 views

Without realizing the time it would take to complete, I issued the command sudo /usr/libexec/locate.updatedb . What happens if I kill the process?

Will killing the process cause problems if I shutdown and reboot immediately after doing it? I am running OS 11.2.3 (Big Sur) on Mac Mini.
user avatar
0 votes
1 answer
42 views

Database Migration from legacy app on old iPad

I recently replaced my old iPad 2 (2011 - iOS 9) with a new iPad 10,2" (iOS 14). I personally made the migration between the two iPad and everything worked quite well. Everything but ONE APP. ...
user avatar
1 vote
1 answer
109 views

Help in understanding a command line search of all sqlite files on os x device

I was listening to a Talk Python To Me podcast that had Simon Willison as the guest. Willison discussed two projects he is developing, Datasette and DogSheep Beta, both of which allow you pull in data ...
user avatar
  • 193
0 votes
0 answers
156 views

Is there a working alternative for mysql on Sierra (10.12.6) that can be used with php?

Does mariadb function properly on Sierra? I can't get mysql to work and since Sierra isn't supported by mysql I'm giving up on trying to get it to function. does anyone have Sierra working as a ...
user avatar
3 votes
1 answer
548 views

sysctl setting net.inet.tcp.keepidle removed in 10.15. Is there a replacement setting?

My work requires long-running connections to databases that required this sysctl setting in earlier OSX versions. Since it no longer exists, these connections appear to remain open, but they ...
user avatar
  • 31
0 votes
2 answers
437 views

Replacement for Supercard in Catalina?

I have been a long time Hypercard fan. When Apple mysteriously dropped it, I kept my Hypercard stacks going using Supercard. Unfortunately, Supercard is not 64 bit compatible (and no sign that that is ...
user avatar
  • 200
2 votes
0 answers
277 views

Missing Messages from chat.db

Hi so I can't currently create a minimum reproducible example but I am missing texts that I know I sent and appear in the search on the iMessage app but aren't in chat.db My python code below import ...
user avatar
  • 131
6 votes
2 answers
4k views

Is there a MariaDB server package for Macos?

My team is switching from MySQL (which has downloadable packages for MacOS) to MariaDB and I'd like to switch on my Mac as well. When going to MariaDB's download page, I only see packages for Windows ...
user avatar
2 votes
0 answers
48 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 ...
user avatar
16 votes
1 answer
9k views

What and how does macOS Mojave implement to restrict applications access to personal data?

As well as many of the other features talked about during macOS Mojave's release like dark mode and the addition of new apps like Home, another key feature of macOS Mojave seems to be it's heightened ...
user avatar
  • 635
1 vote
0 answers
728 views

Trouble Connecting to SQL Anywhere through ODBC

I'm trying to connect to a SQL Anywhere database through an an ODBC connection on my Mac (running High Sierra). I downloaded and installed the SQL Anywhere 17 Developer edition. Installed it ...
user avatar
  • 11
2 votes
1 answer
179 views

Upgrade path for CouchDB 1.x to 2.x on macOS?

I recently downloaded Apache CouchDB 2.1 installer for macOS from the official website. I already had CouchDB 1.7 installed via Homebrew Cask. After installing CouchDB 2.1, I started observing some ...
user avatar
2 votes
1 answer
259 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 ...
user avatar
  • 121
0 votes
2 answers
402 views

How to Backup Apple Mail Gmail database to External Hard drive?

from quite some time I am using Apple Mail signed in with my Gmail Account. I have almost 20K emails and I need to clean up my Gmail account, make separate folders and categorize them. But before that,...
user avatar
4 votes
1 answer
703 views

Why are my Photos library database/metadata files being modified even when I'm not using the Photos app?

OS: MacOS 10.12.3 (16D32) Hardware: MacBook Pro (13-inch, Mid 2012) I currently use Dropbox to sync, among other things, my Photos library on my laptop*. The Dropbox widget notifies me when ...
user avatar
  • 151
0 votes
1 answer
44 views

Application refused to start because of local storage

I am using application TopTracker on my MBP My Mac have frozen and i have forced it to restart. Unfortunatelly, when i'm trying to restart the App, i have this error : Failed to read from local ...
user avatar
0 votes
0 answers
121 views

"Database" report writer for Numbers?

I serve on the Board of a Baroque Orchestra and have begun helping them get organized. The management of the orchestra does not have extensive technical skills so I've endeavored to help provide them ...
user avatar
  • 952
3 votes
1 answer
371 views

How can I open a System 9 FileMaker document in OS X 10.9?

I need to print some FileMaker pages that I created in System 9 (MacOS 9). Is there any free OS X 10.9 software that will open those files?
user avatar
1 vote
1 answer
23k views

mysql: command not found [duplicate]

How do I use MySQL from the CLI? When I use the terminal, I get: Darrens-MacBook-Pro:~ thufir$ Darrens-MacBook-Pro:~ thufir$ mysql -bash: mysql: command not found Darrens-MacBook-Pro:~ thufir$ As ...
user avatar
  • 233
1 vote
2 answers
906 views

How do I install and run MySQL?

I installed MySQL: but MySQL certainly isn't on the path when I open a terminal, nor do I see it in applications, as I seem to recall Windows handles MySQL.
user avatar
  • 233
0 votes
0 answers
755 views

Create a local MS SQL Database on OSX Yosemite

I need to do some tests on a MS SQL (not MySQL) database. But without the burden of having to open a hosting account, create a remote database, connect to it, and remotely insert a million records. I ...
user avatar
  • 261
1 vote
1 answer
2k views

Using modified SMS database with iOS

I've been trying to remove a specific text from my iPhone's SMS database. The text is too long (tens of thousands of characters long, if not more) and is causing iOS to crash whenever I view the ...
user avatar
  • 13
0 votes
1 answer
248 views

Outlook MEGA database

I am the administrator of 10-15 computers, most of them Macs. One iMac Intel Dual Core, 3 GB of RAM (more than 3 y old) is running Outlook 2011 as an email client. The problem is the Mac becomes ...
user avatar
  • 291
1 vote
1 answer
2k views

Create a Database Environment Mac OS/SQL Developer

Hi I am very new to all of this. I am trying to prototype an function on my local machine. I am using SQLDeveloper and trying to understand what I would need to do to create a database locally. I'm ...
user avatar
6 votes
4 answers
10k views

Dates format in Message's chat.db

I'm working on improving my iMessages backup-script. /Users/Kyro/Library/Messages/chat.db has a table message with all the messages an some dates. Any idea what's the date format ? I first thought ...
user avatar
1 vote
0 answers
1k views

Working on a MS Access file with ODBC connection on OSX

I need to open an accdb file on my MacBook Pro (OSX 10.8.5). This file uses an ODBC data source connection. So I guess my questions are: How do I setup a new ODBC data source connection on a Mac? ...
user avatar
  • 225
0 votes
1 answer
1k views

Database app, accessible from Mac, iPad and Web

I feel very out of my depth with this query, but not being able to do it isn't really an option so I am going to have to learn how one way or another. I have been tasked with building an application /...
user avatar
2 votes
3 answers
2k views

Rebuild SystemUIServer's database

I'm not completely sure what happened, but in Console I get the following errors repeating endlessly every few minutes: 28/07/2013 12:32:10.009 SystemUIServer[304]: Unknown error finalizing or ...
user avatar
  • 1,197
0 votes
1 answer
162 views

Index of files to backup

I'm looking for something similar to http://www.indexyourfiles.com/ for the mac. What I want to do is create a backup of my file index which is portable and can be searched through even if you don't ...
user avatar
  • 71
0 votes
1 answer
131 views

Work database with visual interface

I need a app that can help me work on a database with visual aid, I don't need it to be in a specific language, is only that I can see the workflow to better understand all the links between tables
user avatar
0 votes
0 answers
2k views

Outlook for Mac "Your database could not be rebuilt [-47]"

Recently, whenever I open Outlook, it tells me that my the database needs to be rebuilt. I attempted to and received an error the first time. I deleted the database file located in Documents/...
user avatar
  • 527
19 votes
11 answers
106k views

Is there a good SQL Diagram Editor/Drawing Mac App Tool?

Does anyone know a comprehensive Mac app to create SQL Diagramms? I think http://ondras.zarovi.cz/sql/demo/ is quite good, but it's a little bit too basic. I would like to create the database schema, ...
user avatar
  • 709
2 votes
1 answer
688 views

Is there a GUI viewer of databases created by Database Events?

I wrote a simple AppleScript that saves data to a Database Events database. I see the database (DBEV file) in my ~/Documents/Databases folder, and I am wondering if there is a simple graphical utility ...
user avatar
1 vote
1 answer
450 views

Where is "Contact" information stored within iOS4

I have a problem in iOS4.0.1 on my 3GS where not all contacts I have saved show up in the "Contacts" app or tab within "Phone". However, when I enter names in a new text message contact field, they ...
user avatar
  • 11
3 votes
3 answers
11k views

How to stop xampp mysql server?

I just installed xampp on my mac os x. When I tried start mysql it displays a message that mysql is already running on this computer. In order to start mysql stop first mysql. I tried following ways ...
user avatar
  • 151
4 votes
1 answer
219 views

Applescripting ODBC

Is it possible to interact with an ODBC connection within AppleScript? Or must one break out into another process (e.g. Python, Perl, etc)?
user avatar
  • 458
4 votes
3 answers
5k views

What Database programs/tools are included with OS X?

Many years ago I believe Apple included a copy of Hypercard with it's OS. That's before my time, and I have never used it. But, I do have occasional requirements for very simple databases. I am not ...
user avatar
  • 25.4k
2 votes
5 answers
2k views

iPad app for collecting door-to-door survey information?

I need to be able to develop a custom form so I can have workers go door to door and collect survey information. Think census workers, but geared towards the upcoming election. While I could develop ...
user avatar
  • 8,743
5 votes
4 answers
7k views

What Mac apps are capable of managing SQL Server databases?

I'm looking for a Mac app that has capabilities similar to Microsoft SQL Server Enterprise Manager. The app should be capable of the following: Create and administer SQL Server databases, objects, ...
user avatar
  • 1,347
14 votes
0 answers
36k views

Is there a relational database with GUI for Mac similar to Microsoft Access or the like? [duplicate]

I need a desktop database that will have a need for extensive 1-many, many-1, and many to many relationships. I've built this kind of app with Microsoft Access, which I don't love, but does combine ...
user avatar
  • 453