• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Database from AppleScript (was: EndNote Reference Manager + Skim PDF)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Database from AppleScript (was: EndNote Reference Manager + Skim PDF)


  • Subject: Re: Database from AppleScript (was: EndNote Reference Manager + Skim PDF)
  • From: has <email@hidden>
  • Date: Wed, 16 Jan 2008 14:57:27 +0000

On 16 Jan 2008, at 04:34, T&B wrote:

Forget the "Database Events" suite that Apple provides since it kind of tries to build a very limited database system by using and ignoring a sophisticated database engine (SQLite to drive it).

Database Events is a simple object database. It's not a relational database and not intended as a replacement for one. That it happens to be built on SQLite is merely an implementation detail.



It's best to use one of the SQL scripting additions or even via do shell script.

IIRC, the only SQL osax is SQLiteAddOns; there's also a couple of application-based options, e.g. Valentina. Not aware of any non- commercial solutions for AppleScript (other than mucking about with 'do shell script', which is crude and slow) although they're pretty common for other languages such as Python, Ruby, etc.


has
--
http://appscript.sourceforge.net
http://rb-appscript.rubyforge.org

_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden
  • Follow-Ups:
    • Re: Database from AppleScript
      • From: T&B <email@hidden>
References: 
 >EndNote Reference Manager + Skim PDF (From: "Gary (Lists)" <email@hidden>)
 >Database from AppleScript (was: EndNote Reference Manager + Skim PDF) (From: T&B <email@hidden>)

  • Prev by Date: Re: encrypting PDF
  • Next by Date: Simulating pressing of Enter key / Continue button
  • Previous by thread: Database from AppleScript (was: EndNote Reference Manager + Skim PDF)
  • Next by thread: Re: Database from AppleScript
  • Index(es):
    • Date
    • Thread