Reply to thread

Message

<blockquote data-quote="scythelt" data-source="post: 159909" data-attributes="member: 27879">SQLServer Express 2005 could be bundled into the TVServer install program without any additional installation steps required by the end-user. It'd end up functioning much like SQlite - ie, the end-user wouldn't even notice they were using it rather than SQlite.I prefer MySQL, but that could be retained as an alternative for users wishing to use it instead of SQLServer Express. I use MySQL because I already use it for development purposes and it doesn't make sense to have two full-blown databases installed on the one server if I can just have one.SQLServer Express 2005 is free and intended to be a lite version of SQLServer 2005 Standard/Enterprise and can even be bundled into an executable if desired - much like SQlite. The big benefit you get from going from SQlite to SQLServer is you get proper multi-user access; it's a proper transactional db and it's not file based like SQlite is.In reality, if you used SQlite for the TVServer in a multi-seat environment you'd run into all sorts of problems with concurrent access that would make SQlite crap its pants in record timeThere's no reason why mysql couldn't be bundled into a tvserver install either - I have a suspicion that integrating MSSQL Express into an all-in-one installer would be a much simpler process for the devs because that sort of usage is what Microsoft intended of the Express edition in the first place.</blockquote>

[QUOTE="scythelt, post: 159909, member: 27879"] SQLServer Express 2005 could be bundled into the TVServer install program without any additional installation steps required by the end-user. It'd end up functioning much like SQlite - ie, the end-user wouldn't even notice they were using it rather than SQlite. I prefer MySQL, but that could be retained as an alternative for users wishing to use it instead of SQLServer Express. I use MySQL because I already use it for development purposes and it doesn't make sense to have two full-blown databases installed on the one server if I can just have one. SQLServer Express 2005 is free and intended to be a lite version of SQLServer 2005 Standard/Enterprise and can even be bundled into an executable if desired - much like SQlite. The big benefit you get from going from SQlite to SQLServer is you get proper multi-user access; it's a proper transactional db and it's not file based like SQlite is. In reality, if you used SQlite for the TVServer in a multi-seat environment you'd run into all sorts of problems with concurrent access that would make SQlite crap its pants in record time There's no reason why mysql couldn't be bundled into a tvserver install either - I have a suspicion that integrating MSSQL Express into an all-in-one installer would be a much simpler process for the devs because that sort of usage is what Microsoft intended of the Express edition in the first place. [/QUOTE]

Verification