search

nguyenpham / ocgdb

Open Chess Game Database Standard (OCGDB)
MIT License
31 stars 8 forks source link

Latest searchwithontheflycalc db won't open #11

Open kenpchess opened 2 years ago

kenpchess commented 2 years ago

Hello again, Pham! Progress looks good, but I cannot open and read (using SQLPro for SQLlite latest macos version) the created database after running the new ocgdb tool. The SQL utilities just freeze. It kind of looks as though the last batch of records were not written properly or the database was not closed properly. I had that same problem on one of the early forks (not sure which one). Perhaps you reused some early code and a bug was re-introduced (just guessing)?

Anyway, thanks for all of the hard work. Progress looks good!

Oh, and can you publish a beta of your database viewer with one of your fork attempts? Thanks!

nguyenpham commented 2 years ago

I have tried to rebuild the database then open it by SQLPro, SQLiteStudio, DB Browser for SQLite. All are good on my computer.

Can you try using other SQL GUIs, create databases by other branches, say the old ones that worked for you? All branches are still there, untouched so far.

nguyenpham commented 2 years ago

I have planed to create but don't have the database viewer at the moment. You may use Banksia GUI as the temporary solution. At the moment, when showing a PGN file (just drag and drop that file into Banksia GUI), it auto-converts it into an internal SQLite database.

kenpchess commented 2 years ago

Hello Pham! Thanks for the help. I must have something non-standard about my sqlite on Big Sur. Some db utilities work (like DB Browser for Sqlite) but SQLPro For SQLite and SQLPro Studio do not! So I will have to debug this a bit. I will have to google to see if i can re-install sqlite3 on Big Sur.

Sorry for the false alarm. Thanks for tip on using Banskia! But I hope you can write a minimal seperate viewer soon! I am glad you keep on plugging away. You seem to be a very talented software designer/programmer!

nguyenpham commented 2 years ago

It is strange since I have tried with SQL Pro Studio (trial version) on my computer iMac Big Sur (Monterey 12.0.1). All is smooth.

kenpchess commented 2 years ago

Thanks, Pham. I install and test (and make things work that are NOT supposed to work on a mac) so MUCH software that I probably have something installed that is interfering with certain SQL utilities. BUT DB Browser and TablePlus both work fine (perhaps they work at a lower level than some other SQL browsers) so I will use them and leave it at that. BTW, I really liked the last fork, SearchWithOntheflyCalc! Thanks again for your help! - kenpchess