MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ ("My S-Q-L"), but is often pronounced /maɪˈsiːkwəl/ ("My Sequel"). It is named for original developer Michael Widenius's ...
3
votes
4answers
225 views
Should I perform encryption in the front end or within the database?
I want to store an encrypted string (specifically, email addresses) in a database. I'm currently using Python and MySQL. I was initially going to use MySQL's AES_ENCRYPT/DECRYPT to handle it, but then ...
1
vote
3answers
266 views
How do I approach this PHP/MYSQL query?
I have a reservation system that I have coded and my final task is to allow the user to enter a set of dates and then show them all available options.
The reservation table is set up with unit_id, ...
5
votes
2answers
155 views
How to separate sensitive data in database(MySql)
I need to design a database that will contains information about personal disease of users.
What can be the approach in order to implement the columns of the DB's tables: encrypt the information, ...
-2
votes
1answer
70 views
Adding a forum to an existing site
I've got a site with ~500 registered members, 300 of which are what you'd call "active". Site data is kept in a MySQL dbase.
I'd like to add a myBB forum to the site, but this question applies to any ...
2
votes
5answers
352 views
Is database based chat room bad idea?
Most of simple "group chat" systems are based on local file storage logs (e.g. log.txt ).
I'm developing a simple group chat (under 20 users simultaneity ) with jQuery/AJAX.
So basically, ...
1
vote
1answer
66 views
choosing Database and Its Design for Rails
I am having a difficulty in deciding the database & its structure.
Let us say the problem is like this.
For my product I have various customers( each is an educational institute)
Each customer ...
1
vote
2answers
108 views
Store HighRes photos in Database or as File?
I run a site which has a couple of million photos and gets over 1000 photos uploaded each day. Up to now, we haven't kept the original file that was uploaded to conserve on space. However, we are ...
1
vote
4answers
145 views
What are some good tips for a developer trying to design a scalable MySQL database?
As the question states, I am a developer, not a DBA. I have experience with designing good ER schemas and am fairly knowledgeable about normalization and good schema design. I have also worked with ...
1
vote
1answer
101 views
Data base structure of a subscriber list
I am building a application that allow different user to store the subscriber information
To store the subscriber information , the user first create a list
For each list, there is a ListID.
...
1
vote
2answers
94 views
MySQL with mutiple threads and processes
I'm developing a telecom messaging platform in C, and I'm going to need multiple processes to be working with MySQL DB.
How can I make two processes read/write to/from a Mysql DB and, if/when one of ...
2
votes
7answers
250 views
What is the best approach for database design with lots of columns?
I am writing a query based financial application. It lets the user to write complicated equations (much like WHERE part of an SQL query) and find companies matching those criteria.
For the above, I ...
3
votes
1answer
74 views
Any good resources on InnoDB and not on MySQL?
Are there any good resources on InnoDB internals? I've been looking around for a while but most of them focuses on the whole MySQL rather than InnoDB. Anything from books, webpages, pdfs to blogs ...
6
votes
5answers
822 views
Is MongoDB the right choice in my case?
I'm going to build my first real project in Rails that consist in a web app made of 3 main parts:
The static part where no database is used
The User registration part which will require a database ...
4
votes
2answers
136 views
Patterns for Versioning Relational Data in a MySQL database?
I am trying to find an approach for a project, where A user can edit records, and be able to see past versions of those records. Here is a simlified example schema, using a list:
TABLE list (
id ...
2
votes
1answer
62 views
How to swap out a DB from MySQL to SQL Server in a multiple large projects?
Is there a sane way / best practices way to swap out a DB from MySQL to SQL Server in a multiple large projects? Some of the projects are ASP projects, some of them are windows services, some are ...
