[p4] Accessing the Perforce database from *nix
Stephen Vance
steve at vance.com
Wed Dec 12 13:36:57 PST 2007
They started with BerkeleyDB, but have modified it heavily since.
Accessing it that way is entirely unsupported and can adversely affect
your server performance depending on locking interactions. The official
line is that for all practical purposes, it is proprietary.
I believe there are ODBC client software versions for those platforms.
You can use those against the Windows ODBC server for Perforce to access
the data. You should also be aware that heavy use of this mechanism can
also adversely affect your server performance. Data mining has different
access patterns than the running server and ad hoc queries won't be
optimized for server performance like server data access.
Steve
Looney, James B wrote:
> I recently discovered that we could access Perforce's database from
> Windows with ODBC, and wanted to similarly access the database (for some
> datamining to improve our scripts' performance) on a *nix platform.
> However, I'm a little confused on how to do so in *nix-land.
>
> Our scripts are written in Python, and are run on SunSolaris, SGI's IRIX
> and HP-UX. So, from those systems, how would I setup the connection?
> Or, what areas/topics are recommended to read up on to figure it out?
>
> As a side question, I was wondering what kind of database it is, whether
> they use SQL, MySQL, etc?
>
> -JB
> _______________________________________________
> perforce-user mailing list - perforce-user at perforce.com
> http://maillist.perforce.com/mailman/listinfo/perforce-user
>
>
--
Stephen Vance
www.vance.com
More information about the perforce-user
mailing list