external database

Add your suggestions for improving Poker Mavens

external database

Postby torba » Sat Jun 29, 2013 9:36 pm

This is a really critical feature, inclusion of say an option to have a sql database at a different site would allow multiple servers to run on the same information, adding scalability. An external db would be more secure and faster, as the current pmaven's textfile-based system is only as secure as the folder its in and limited by read/write speed of the server it's on. Which do you think is faster and more secure? A windows dedicated server or amazon's specialized RDS? Also why torture developers and yourself with having to deal with a txt-based system? There's a library for sql in practically every language.
torba
 
Posts: 3
Joined: Sat Jun 29, 2013 9:22 pm

Re: external database

Postby Kent Briggs » Sat Jun 29, 2013 9:53 pm

torba wrote:This is a really critical feature, inclusion of say an option to have a sql database at a different site would allow multiple servers to run on the same information, adding scalability. An external db would be more secure and faster, as the current pmaven's textfile-based system is only as secure as the folder its in and limited by read/write speed of the server it's on. Which do you think is faster and more secure? A windows dedicated server or amazon's specialized RDS? Also why torture developers and yourself with having to deal with a txt-based system? There's a library for sql in practically every language.


I do have plans to go with SQL, but it will be more for reporting purposes, not for performance. Multi-server scaling is complicated, though. The current single-server system is doing everything in memory and thus is already about as fast as it can be. The data files are only read once at startup and only written to as live data changes, after the fact.
Kent Briggs - [email protected]
Briggs Softworks - http://www.briggsoft.com
Kent Briggs
Site Admin
 
Posts: 3805
Joined: Wed Mar 19, 2008 8:47 pm


Return to Wish List

Who is online

Users browsing this forum: No registered users and 2 guests

cron