162 reputation
9
bio website database-architect.com
location Vancouver, Canada
age 31
visits member for 1 year, 10 months
seen Feb 27 at 5:28

Database architecture

We're offering database architecture and SQL performance optimization services. Technologies:

  • Oracle
  • MySQL

Feel free to request a quote if you are interested.

Best regards


Feb
10
comment mysql forbidden database names
Hi Paul, my app is a dynamic hosting system including databases, I have a job in the background doing all that kind of stuff. My users need their own database that's why I have to perform this check... Thanks!
Feb
10
accepted mysql forbidden database names
Feb
9
comment mysql forbidden database names
@ypercube well yes of course, at availability check time and at creation time the check is performed (in the latter case, within the same stored procedure so there's very little chance of mistake) Thank you
Feb
9
awarded  Commentator
Feb
9
comment mysql forbidden database names
yes, this is correct, but I have an engine that from the GUI checks whether the environment's name is available (So I can kindly inform my users 'on the fly'). At that moment I don't create anything, yet I need the information. Thank you so much for your help!
Feb
9
comment mysql forbidden database names
Hi Paul, thank you for your input. This is a good start since it would indeed prevent overriding existing databases. My reason is that I allow my users to pick a name for their environment, and it implicitely creates a database with the same name. This is why I have to ensure my exclusion list is reliable.
Feb
8
comment mysql forbidden database names
Professionalism is never too hard. I aknowledge that you can't provide me an answer, thank you for your input anyway.
Feb
8
comment mysql forbidden database names
Yes exactly, this is why I need a list of other forbidden database names.
Feb
8
comment mysql forbidden database names
Unfortunately this page does not provide an answer: reserved words for SQL queries or table columns are different than the one for databases' names. For instance there's no mysql reserved word but you can't create a db of your own with that name.
Feb
8
asked mysql forbidden database names
Feb
7
asked Can I disable an account in mysql after x failed login attempts?
Jul
13
accepted Can I force mysql server to resolve the external ip to localhost?
Jul
10
awarded  Student
Jul
10
answered Can I force mysql server to resolve the external ip to localhost?
Jul
10
asked Can I force mysql server to resolve the external ip to localhost?
Jul
9
awarded  Peer Pressure
May
20
awarded  Caucus
May
19
awarded  Scholar
May
19
accepted General error 1651 after a mysql migration
May
19
comment General error 1651 after a mysql migration
@ypercube that was it. Please add your comment as an answer and I'll accept it. Changing it to SET ... = 0 does not change anything, removing totally the setting does. I agree that it is overkill to double specify the parameter on server and client's sessions, but to me it should not behave like this anyway.