in reply to Cross platform location for SQLite databases?

The best cross-platform store for SSO authentication is a Kerberos database. Mostly, you can rely on the particular kerberos ticket cache implemetation of the underlying OS. But alas, Kerberos authentication is not quite evolved at CPAN (last time I looked was some months ago.) So you would have to rely on OS dependent tools for each platform, possibly involving LDAP.

That's all I venture to say, since your task description bears many open questions...

  • Comment on Re: Cross platform location for SQLite databases?

Replies are listed 'Best First'.
Re^2: Cross platform location for SQLite databases?
by muzakfetch (Scribe) on May 26, 2009 at 17:26 UTC

    Thanks, shmem but using these technologies requires authentication on it's own. Most of what I need to store is just simple metadata that requires no security. Therefore, Kerberos and LDAP are a little overkill for my needs.

    What I am truly looking for is a module that identifies the OS, and then chooses an appropriate location for storing metadata. Depending on context and privileges, this can be in the user's profile directory, or if running as a privileged user, in "/var" or "C:\Windows\something" (sorry not a windows geek).

    Perhaps this doesn't exist, and I should just write my own :-)

      Therefore, Kerberos and LDAP are a little overkill for my needs.

      Why overkill? Bot are centralized stores with a well defined protocol. Querying the platform, selecting the storage location depending on the result and implementing the do-abouts for each looks more like overkill. And, "requires no security" ? That's almost always wrong ;-)

      ...module that identifies the OS...

      No need for a module: $^O

      see perldoc perlvar.