Don't use databases

Discussion of chess software programming and technical issues.

Moderators: hgm, Harvey Williamson, bob

Forum rules
This textbox is used to restore diagrams posted with the [d] tag before the upgrade.
Post Reply
Henk
Posts: 5248
Joined: Mon May 27, 2013 8:31 am

Don't use databases

Post by Henk » Sat Oct 13, 2018 10:30 am

After training a network it saves network weights in a database. But once in a while it fails. So all tuning was for nothing for new weights weren't stored.

Message: Test method Skipper3.Tests.NetworkTest.TrainNetwork threw exception:
System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Cannot open database "Skipper3" requested by the login. The login failed.
Login failed for user 'hp\Henk'.

User avatar
lucasart
Posts: 2963
Joined: Mon May 31, 2010 11:29 am
Full name: lucasart
Contact:

Re: Don't use databases

Post by lucasart » Sat Oct 13, 2018 10:32 am

Henk wrote:
Sat Oct 13, 2018 10:30 am
After training a network it saves network weights in a database. But once in a while it fails. So all tuning was for nothing for new weights weren't stored.

Message: Test method Skipper3.Tests.NetworkTest.TrainNetwork threw exception:
System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Cannot open database "Skipper3" requested by the login. The login failed.
Login failed for user 'hp\Henk'.
Thank you for this insightful post.
Theory and practice sometimes clash. And when that happens, theory loses. Every single time.

odomobo
Posts: 18
Joined: Thu Jul 05, 2018 11:09 pm
Location: Chicago, IL
Full name: Josh Odom

Re: Don't use databases

Post by odomobo » Sat Oct 13, 2018 1:04 pm

Maybe it's better using sqlite, as long as you aren't using any advanced DB features. It doesn't have permissions, apart from standard file permissions.

Post Reply