I'm looking for a quick and easy way to get a pgn database into tabular form to import into mySQL.
Does anyone know of software that will turn a pgn database into a comma delimited text file or some other such format?
thanks.
From pgn to MySQL?
Moderators: hgm, Rebel, chrisw
-
- Posts: 12542
- Joined: Wed Mar 08, 2006 8:57 pm
- Location: Redmond, WA USA
Re: From pgn to MySQL?
Jose stores PGN in MySQL.Fguy64 wrote:I'm looking for a quick and easy way to get a pgn database into tabular form to import into mySQL.
Does anyone know of software that will turn a pgn database into a comma delimited text file or some other such format?
thanks.
-
- Posts: 6073
- Joined: Sat Apr 01, 2006 9:34 pm
- Location: Scotland
Re: From pgn to MySQL?
Exactly and very good it is.Dann Corbit wrote:Jose stores PGN in MySQL.Fguy64 wrote:I'm looking for a quick and easy way to get a pgn database into tabular form to import into mySQL.
Does anyone know of software that will turn a pgn database into a comma delimited text file or some other such format?
thanks.
I wish Peter would carry on with it.
Let's be honest, PGN is a very outdated format don't you think?
With a SQL database you have searchable and scalable possibilities over very large amounts of data.
Christopher
-
- Posts: 12542
- Joined: Wed Mar 08, 2006 8:57 pm
- Location: Redmond, WA USA
Re: From pgn to MySQL?
Aquarium also stores PGN in SQL.Christopher Conkie wrote:Exactly and very good it is.Dann Corbit wrote:Jose stores PGN in MySQL.Fguy64 wrote:I'm looking for a quick and easy way to get a pgn database into tabular form to import into mySQL.
Does anyone know of software that will turn a pgn database into a comma delimited text file or some other such format?
thanks.
I wish Peter would carry on with it.
Let's be honest, PGN is a very outdated format don't you think?
With a SQL database you have searchable and scalable possibilities over very large amounts of data.
Christopher
You can use ODBC to connect to the database and perform all sorts of queries to your heart's content.
-
- Posts: 1243
- Joined: Sat Dec 13, 2008 7:00 pm
Re: From pgn to MySQL?
Is that why it's so slow and buggy?Dann Corbit wrote: Aquarium also stores PGN in SQL.
You can use ODBC to connect to the database and perform all sorts of queries to your heart's content.
-
- Posts: 12542
- Joined: Wed Mar 08, 2006 8:57 pm
- Location: Redmond, WA USA
Re: From pgn to MySQL?
The slow, quirky behavior is due to their choice of database (I think it is probably the worst imaginable ODBC database). However, you can retarget Aquarium to use SQL*Server very easily and that will speed it up four fold. I plan to build a MonetDB target that will speed it up 10x or more.Gian-Carlo Pascutto wrote:Is that why it's so slow and buggy?Dann Corbit wrote: Aquarium also stores PGN in SQL.
You can use ODBC to connect to the database and perform all sorts of queries to your heart's content.
-
- Posts: 814
- Joined: Sat May 09, 2009 4:51 pm
- Location: Toronto
Re: From pgn to MySQL?
Thanks gentlemen, I'll pass the info along. I'm enquiring on behalf of web programmer friend who is about to some write some php code to be used by his non-technical client to build up a database on a web server, and I told him I'd look into it.