Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
macOS AppleScript for SQLite Databases
- Thread starter VFRulez
- Start date
- Sort by reaction score
Hi,
Assuming you already understand SQLite, then there's some good stuff here:
http://macscripter.net/viewtopic.php?pid=190866
The recommended technique suggested there seems to be to go via "do shell script" and use sqlite3. Of course, depending on what you want to achieve, you might be able to ditch AppleScript and work in a shell script.
That said, personally I wouldn't work with SQLite using AppleScript or shell script if I could help it. I'd probably go via FMDB in Objective-C:
https://github.com/ccgus/fmdb
If you must use AppleScript then maybe try to get FMDB working with AppleScriptObjC - I've not tried that myself so I can't comment on how easy/nasty it might be.
Good luck!
My current problem is that I do work with a financial controlling software that stores the application data in a SQLite db, so in the respective SQLite files.
As well I do use for the in-processing into my storage a barcode-scanner & mysql db.
What I want to do is to enrich the information in the financial software by the storage information from the mysql db. Thats a functionality the financial software does not have, but would help me to control purchases and stock value.
So my idea was to get an applescript to do exactly this.
Maybe thats a stupid idea that will never work, maybe there is an easier way I do just not know.
As well I do use for the in-processing into my storage a barcode-scanner & mysql db.
What I want to do is to enrich the information in the financial software by the storage information from the mysql db. Thats a functionality the financial software does not have, but would help me to control purchases and stock value.
So my idea was to get an applescript to do exactly this.
Maybe thats a stupid idea that will never work, maybe there is an easier way I do just not know.
SQLite, as I plan to change the storage db to SQLite.
So the application have the SQLite then in common.
Whilst I'm no Pythonista, I would agree that AppleScript is probably one of the least-good choices for working with SQLite.
Can this be useful ?
https://iworkautomation.com/numbers/sqlite.html and
https://iworkautomation.com/numbers/sqlite-read.html
It is using apple numbers and sqlite.
https://iworkautomation.com/numbers/sqlite.html and
https://iworkautomation.com/numbers/sqlite-read.html
It is using apple numbers and sqlite.
Can this be useful ?
https://iworkautomation.com/numbers/sqlite.html and
https://iworkautomation.com/numbers/sqlite-read.html
It is using apple numbers and sqlite.
Wow! I never knew about that! Every day's a schoolday...
Last edited: