Tag Info

New answers tagged

0

I answered a similar question in Aug 2011 : Which DBMS is good for super-fast reads and a simple data structure? Since you are asking about MySQL and which storage engine. To be honest, it is hard to say because there are rare occasions when MyISAM can outperform InnoDB when it comes to SELECTs. Here are some of my past posts on this controversy Sep 20, ...


-1

If you need foreign key support, then you kind of have no other choice than InnoDB. However, if performance is the concern, MEMORY is the fastest. You have to make sure you have a permanent copy of the tables on disk, and load them into memory after each server restart. If you use other engine, and you enable query caching, you would gain performance with ...


0

I think you're on the right track. I presume questions.type (NB type might be a reserved word and cause problems) will have the check constraint check type in ('multiple_choice','free_text') or something similar. Then all you would need to do is rename your proposed UserAnswers to UserMultipleChoiceAnswers and drop the column answer, and create another ...


1

Short answer: It depends on a lot of different things. Longer answer w/ questions: If you haven't used any database management systems before, then any of the main options (SQL Server, Oracle, PostgreSQL) will suit your needs. However, do you already have a DBMS installed on a server, or is this a personal project starting from scratch? Do you require a ...


1

I don't understand why you're asking this question. If you're buying in a service, then backups should be part of the SLA and not your responsibility. If it's not part of the service, then why are you using SaaS? On the other hand, if you need to be backing up something, why are you backing up every hour? Technically, if your application is running on a ...


0

Here are a couple of options that help with security. A simple step is to not use the default 3306 port. Also, use very hardened passwords and if possible, change passwords often. A trick that I have done is instead of having your application communicate directly to your mysql server, have it communicate via PHP to an Apache server running on the same server ...


0

It looks like you might need to use a DDNS service from a service such as www.no-ip.com, then filter on DDNS name. The client will have to update their IP on the dynamic dns system though. Have you considered running the db engine on a non standard port with very strong passwords and all the security best practices presented, then letting the clients ...


0

What are the clients? PHP? Java? (etc, etc) There are potentially serious hacks that can do things like "SQL Injection" through them. That is perhaps more common than IP restrictions. Do you have root only from some secure place? Does it have a hardened password? Are all the application 'users' granted access only to the desired database, and with ...


0

You could do this in phpMyAdmin, but you shouldn't. If you insist, you could use an input transformation to do so. You'd have to write one, but doing so shouldn't be too difficult if you have a basic knowledge of PHP. However, this is a bad idea for many reasons, the biggest of which is that you shouldn't be giving your users access through phpMyAdmin. ...



Top 50 recent answers are included