Re: sqlite question

Subject: Re: sqlite question
From: Jim Weisbin <email@hidden>
Date: Sun, 19 Apr 2015 13:20:17 -0400

Axel Luttgens <email@hidden> wrote:

For example, what is the value of path_to_db (I guess it is a string beginning with « /Volumes/… »)?

Yes, a string “/Volumes/<name of the share where that db file resides>"

What are the permissions on the file path_to_db and on the enclosing folder, as seen with a « ls -al path_to_db »?

permissions on the share, when mounted on my computer remotely, are:

drwx------@ 1 jim staff

permissions on the file (again, when mounted remotely are:

-rw-r--r-- 1 jim staff

I’m the sysadmin so I can set the share however I need, as long as it is not open to “everyone"

What is the sharing protocol (AFP, SMB…)?

AFP

Could you provide rough timings for the SELECT performed on the remote database file and on a local copy of it?

local:

real 0m0.044s

user 0m0.013s

sys 0m0.015s

remote:

real 0m29.478s

user 0m0.051s

sys 0m0.123s

Is the database file the only remotely accessed item?

yes

What values are stored in column PLAYER_VIEW.FILE_NAME (file names, or file paths)?

just file names as strings

Do you only need to read data from the database (no INSERTs, UPDATEs…)?

correct. I just need a list of file names, so I can prevent users from submitting the same file again to a different folder.

Click here to view our online reel

 _______________________________________________
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: sqlite question
  - From: Axel Luttgens <email@hidden>

Prev by Date: Re: Scriplting the Photos application
Next by Date: Re: Scripting Terminal ?
Previous by thread: Re: sqlite question
Next by thread: Re: sqlite question
Index(es):
- Date
- Thread