Very good progress!

[kenpchess]

Hello again, Pham! I really like the progress you have made on this chess database project. The performance speed is very good, especially for an alpha or beta level project!
I compiled the code on a mac-mini 2020 quad 3.6 ghz with Mac OS "Big Sur" (hardware stats really very similar to yours) and it inserted all 3.45 million games in 50 seconds!
Very respectable!

I am really looking forward to you adding in some level of GUI. I have already used SQLPro for SQLLite to query the created millionbase file and it is quite useful!

I hope you "stick to your guns" and stay with SQL and such as compatibility is really the most important feature. Your Banksia GUI is also very nice so as far as I am
concerned you have already proven you have the GUI "chops" to design a nice GUI for the database project.

I am not a professional programmer (long retired general computer consultant) but I guess I am a software "power user" so I will try to make an occassional suggestion
as you progress with the project. I am sure there are better ideas, but I suppose my first idea would be a database option of storing a FEN string every X moves (user Option).
That would allow some positional queries but give the user some control on the creation speed and size of the database.

At any rate you are doing a great job so far and I am looking forward to seeing your progress on the project!

I very much hope your family's health is improving! Thanks for all of your hard work so far!

• ken (kenpchess on various forums)

[nguyenpham]

Thanks for the stats and the suggestion. I will consider/try it in the next step when fighting with position searching!

I have posted on the Talkchess that I may discard my own binary databases soon to adopt, support SQL ones only. IMHO, it has much more potential than binary ones. However, it still needs a lot of work, especially on position searching.