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 focus on both privacy and security. As quoted under the "Camera and Microphone Now Require Your Permission" section of this article: > Apple also announced that other categories of data, such as your Messages history and Mail database, will be protected in a similar manner to macOS Mojave's new camera and microphone permissions. I understand that after the update, when an app requests to use your camera or microphone, you will receive an alert like the one below: However, I am more intrigued by the following: > ...other categories of data, such as your Messages history and Mail database, will be protected in a similar manner... I have been unable to find much information about this online and I do not currently have the pre-release version of macOS Mojave installed and am therefore unable to test this new feature but I am curious to know what exactly this feature will mean. Has Apple publicly documented how this will work?

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 that backup, and would like to append the recent history since the loss. Is there a way to do that? Specifically is there a process I can used to take one set of backup files (History.db-shm, History.db-wal, and History.db) and merge them into another set?

Within Photos, how to **move** a set of photos from one album to another one to change my library organization, **without duplicating** their names? Like you can move a file within the filesystem from one folder to another without creating a new name for it ( which can be achieved with symbolic links ). My photo library is pretty well organized as a tree of folders and within, each terminal folder a set of albums each with a meaningful name. Whenever a folder or album gets too large I create new sub-folders or albums and I would like to **move** albums and photos within this modified organization but without ever creating duplicate names. I don't want for any reason any duplicate name, and moreover I don't want any pair of names which are different and pointing in fact to the same photo: a **hidden duplicate name** ( folder_1/name_A → img4928.jpg and folder_2/name_B → img4928.jpg ). Such **hidden dupplicate names** would make a labyrinth, a mess of my photo library. I already tried many key combinations while dragging: ⇧+drag, ^+drag, ⌥+drag, ⌘+drag with no success. Why does this basic function seem to be hidden or… missing? The function of moving is much more useful in real life than the one of copying, when you want to maintain a huge data collection well organized. What I am looking for here is not an explanation of the internal functioning of Photos. I know it pretty well. For example when we **copy** a photo from album *A* to album *B*, internally there is no duplication of data, but just a duplication of name, both names pointing toward the same original photo.

I'm trying to export a Whatsapp chat from an iPhone Xr with iOS 15.6 including replies to messages. I tried to explore the ChatStorage.sqlite db trying to understand how does it works but it's very "messy"! After a while, I succeded in understanding how do it works but I really can't understand how does Whatsapp store replies to messages. The only thing I noticed its that whenever a message is a reply to another message (also when a media is attached to a message, so, more generally, whenever the "graphic thing" is on top of a message), in the ZWAMESSAGE table under ZMEDIAITEM column, a value appear, which is the Z_PK value of an entry on the ZWAMEDIAITEM table. Unfortunately this last table seems to only show informations about messages with media, as every message that should be a reply, in this table has nearly every value set to null. Also tried googling a bit, but I couldn't find anything. Could you help me to understand replies in Whatsapp database please?

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 successfully. I can launch it connect to my databases. Yay! Next, I downloaded and installed the ODBC Administrator I read about in multiple posts. Installed it... seems to run as intended. Next I added the SQL Anywhere 17 drivers to the ODBC Administrator (by following these steps . Then I tried adding a DSN (tested both User and System). The documentation on this is a little lacking from SYBASE (specifically which parameters are "required"). Depending on what version of help you're looking at, the examples use different parameters. In the end, I created parameters for the all the variables passed in the connection string (UserID, Password, Database File). Sadly, there's no testing function in the ODBC Administrator to test a DSN. So I return to SQL Anywhere and attempt to connect to a database via "Connect with an ODBC Data Source". Here, I can "Test Connection". And I consistently get the error: "[SAP][ODBC Driver Manager] Unable to load driver libodbc.dylib" One thing I noticed is that when I added the SQL Anywhere 17 driver, I point (per the instructions) to: /Applications/SQLAnywhere17/System/lib64/dbodbc17.bundle. Now I have no idea what a bundle file is. Does it contain a 'bundle' of drivers? No idea. But unless this bundle file is supposed to contain libodbc.dylib (the file/driver reported as missing) then it's worth mentioning that file doesn't even exist on my Mac; I've searched for it. I'm relatively new to Mac OS (I've done this a million times in Windows). Please, if anyone can help me with what I assume should be a fairly simple task, I would be eternally grateful.

I have recently updated to Ventura, and the photos app changed a bit. Before the update the photos app used mostly sqlite to store all the data, but now it changed to files with `.kgdb extension. I can see there are .wal` - write ahead logs files as well, but i cant figure out what is that database.. Does anyone have any further information what standard it is?

How to entirely delete MySQL from mac Monterey 12.5.1? I read articles about this. In all articles it's written that you should go to "System Preferences" -> "MySql" and you will get this window However, when I click on "MySql" in "System Preferences" window, it pops out like this There is no "uninstall" button and I do not have MySql application in the "Application" folder. P.S. in my case, the MySql icon looks like a gear, not a dolphin.

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.

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. This app, called Anamnesis, reported "*the app is not compatible with this iOS version*". I wrote to the app developer (www.fuze.cc) which is not answering. I wrote to each member of the Fuze team and only one answered me (Icaro) who is no more working on Fuze, unfortunately. I'm quite desperated because I strongly need this app to work: I use Anamnesis to register each patient I see everyday. I have about 1000 records in that Anamnesis database, which is stored locally in the old iPad. There's no option in Anamnesis to export the database into a new one. There's no option to migrate it with a cloud service. I don't know what to do to make use of that database into the new iPad or to transfer that data into a new database which I can use into an app compatible with the new iPad. I'm writing an webapp with Zoho Creator, so one day that I will have the database I can slightly control the migration. But actually, I don't know what to do. This is a screenshot of Anamnesis taken in the old iPad:

I was listening to a [Talk Python To Me](https://talkpython.fm/episodes/show/299/personal-search-engine-with-datasette-and-dogsheep) 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 as an SQLite database (Datasette) and then index and query it (DogSheep Beta). All your data include Apple Watch data, texts, photo data including lat/long and even the scoring Apple uses to rank your photos. The two links here are really interesting and I recommend them. The problem I'm having finding .sqlite files. The directions and the YouTube say to install Datasette and point it against a database on your laptop. I know I can use the Finder for files but I'd like to follow along with youtube. At around 5:31 in his [PyCon AU talk](https://www.youtube.com/watch?v=CPQCD3Qxxik) , he types out:

"kMDItemDisplayName ==*.sqlite" -0 | xargs -0 stat "-f%z %N" | sort -nr | head -n 20

I managed to read the incantation but while I get the gist, there are a number of details that Apple's CLI help pages don't cover. So, here are my questions: * What is the -0 flag, specifically? (as opposed to the overly brief example Apple gives) * What does xargs -0 stat "-f%z %N" mean? * -nr what are the n and r flags for sort? * finally (and you probably guessed it with order) what is -n flag for head?

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 functional web development server because I am just trying to test an ecommerce website. I don't need it to do much. what database just works I don't care if its free or not

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 going to happen any time soon), and so will not run under MacOS Catalina. Many of my Hypercard stacks are really just fancy Address books, and I could export them to Apple's Contacts app. However, I have a more sophisticated complicated stack that is really like a little customer database ... My Question is: Are there are any free or simple (but good) apps that you would recommend for that purpose: one card per person, usual entries for email and contact information, and then which version of the software they are using and similar. Simple database or even simpler than that might suffice. All suggestions appreciated.

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, the relations between the tables (including labels for e.g. n:m relations), add comments, export to SQL, and so on to run from my Mac.

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 / database for a Chauffeur company. I have done similar things before in Microsoft Access for other customers, hence getting this request, but this customer wants to be able to run the app on their Mac, and not install Windows. My only real experience of coding is HTML/CSS and some VBA when using Microsoft Access. For these Access DBs I have created separate front and back end files to allow multi user access and also remote access (the back end file being kept on the company server). So onto my query (apologies for dragging it out)... I need to be able to build something that the single user can open and run on his Mac, so he can view, add, change jobs and their details. He also needs to have the same access on his iPad, although purely viewing would suffice. As regards the web access, basically he wants to be able to go onto his "Booking System" application, go to "New Job" and send a link to his client, where they would click the link in a browser, fill in the details (Name, Contact Number, collection and drop off addresses, collection date and time etc...) and when they submit this form the details be updated on his booking system. My issue is I do not really know where to start. What kind of database development environments are available on OS X (like MS Access is for Windows) which I could use as a starting point?

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 sqlite3
import pandas as pd

db = 'chatCopy.db'
conn = sqlite3.connect(db)
c = conn.cursor()

cmd1 = 'SELECT * \
            FROM message \
            '

c.execute(cmd1)
messages = pd.DataFrame(c.fetchall(), columns = list(map(lambda x: x, c.description)))

messages[messages['text'].apply(lambda x : 'Maybe like Sherlock' in x if x else False)].shape
>>>(0, 68)

Then when searching in iMessage Finally when going to ~/Library/Messages/Archive/ the messages do exist. (This is what I assume the messages app is actually searching.) I have somewhat noticed that this is only happening with older messages although I cannot confirm that this only happens to older messages.

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](https://mariadb.com/downloads) , I only see packages for Windows and a few flavors of Linux. My first assumption was "okay, MariaDB doesn't offer packages for MacOS" but when searching, I was able to find this page which says that .pkg files are available: https://mariadb.com/kb/en/library/installing-mariadb-server-pkg-packages-on-macos/ But I wasn't able to actually locate a downloadable package, either in .pkg form or in .tar.gz form. I see that it is available via *Homebrew* (which I'm using), but I was hoping to get an "official" package.

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 to do so. Does anyone know any way that I could manage a database on my phone?

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 running but something has to be going wrong during boot up. Looking at the console log, I'm seeing a ton of "database is locked" messages for numerous apps including CalendarAgent, AddressBookSourceSync, soaagent, routined and so forth. Where are these databases and how can I unlock them? The items I've found online regarding sqlite databases have been for Windows and Linux, not finding anything anywhere on this specific issue. How may I analyse this problem and unlock these databases?

I recently downloaded Apache CouchDB 2.1 installer for macOS from the official [website](http://couchdb.apache.org#download) . I already had CouchDB 1.7 installed via Homebrew Cask. After installing CouchDB 2.1, I started observing some problems, like [Local CouchDB on Mac Opens New Browser Tab Every 5 Seconds](https://dba.stackexchange.com/questions/162090/local-couchdb-on-mac-opens-new-browser-tab-every-5-seconds) . Other issues include inconsistent environment variables and ports in use. It appears that the macOS is unsure about the version of CouchDB installed and both the versions are running concurrently. I figured, that a probable reason could be that CouchDB 1.7 was installed via Homebrew Cask, while Apache CouchDB was installed from the downloaded installer as it is not yet available via Homebrew Cask. They have your database migration covered, but not an 1.x-to-2.x upgrade path for the application itself on macOS. I uninstalled Apache CouchDB 2.1 and killed the daemon that it left running. CouchDB 1.7 works fine after that. How do I perform an upgrade in this scenario?

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 probably using the wrong language so I will try to be more specific. I don't have access to a server where I can build this database and I would need to do it locally - how would I set up my SQLDeveloper to use part of my hard drive space a server where I can build the database?