MySQL is an open-source, relational database management system.
89
votes
12answers
29k views
Why use a database instead of just saving your data to disk?
Instead of a database I just serialize my data to JSON, saving and loading it to disk when necessary. All the data management is made on the program itself, which is faster AND easier than using SQL ...
38
votes
12answers
9k views
Is it a bad practice to store large files (10 MB) in a database? [closed]
I am currently creating a web application that allows users to store and share files, 1 MB - 10 MB in size.
It seems to me that storing the files in a database will significantly slow down ...
32
votes
9answers
2k views
Why isn't protection against SQL injection a high priority?
On Stack Overflow, I see a lot of PHP code in questions and answers that have MySQL queries that are highly vulnerable to SQL injection attacks, despite basic workarounds being widely available for ...
19
votes
10answers
2k views
Struggling as a programmer. Need some advice [closed]
I've been a developer now for a number of years. I'm pretty good at what I do and can "get the job done".
But, there is a difference between "getting the job done" and "doing the job properly". Let's ...
19
votes
6answers
2k views
Pitfalls of using MySQL as your database choice?
I've read online on multiple occassions that MySQL is a bad database. The places I've read this include some threads on Reddit, but they never seem to delve in on why it's a poor product.
Is there ...
18
votes
3answers
3k views
How to build completely modular web applications [closed]
In the coming months we're going to begin a project where we take a system we've built for a client (v1) and rebuild it from scratch. Our goal with v2 is to make it modular, so that this specific ...
15
votes
3answers
615 views
How to design website workflow?
I have been thinking about this for really long time without reaching an optimum answer.
First of all, I'm a medical doctor who loves programming but never really studied it, except for home learning ...
13
votes
4answers
779 views
How to really master MySQL?
I have been using mysql for the same amount of time I have been using PHP. However I feel about 10x more confident in PHP; or any other programming language. But I just can't seem to really really ...
13
votes
3answers
3k views
How to design highly scalable web services in Java?
I am creating some Web Services that would have 2000 concurrent users. The services are offered for free and are hence expected to get a large user base. In the future it may be required to scale up ...
12
votes
2answers
888 views
Best way to organize SQL queries stored in your code ? (or should you?)
I am sure I am not the only one who gets frustrated when they see a page of code littered with SQL queries. The ActiveRecord and other ORM patterns help mitigate a good amount of SQL used in a ...
12
votes
2answers
300 views
How to temporarily save the result of the query, to use in another?
I have this problem I think you may help me with.
P.S. I'm not sure how to call this, so if anyone finds a more appropriate title, please do edit.
Background
I'm making this application for ...
10
votes
5answers
370 views
When is it better to offload work to the RDBMS rather than to do it in code?
Okay, I'll cop to it: I'm a better coder than I am at databases, and I'm wondering where thoughts on "best practices" lie on the subject of doing "simple" calculations in the SQL query vs. in the ...
10
votes
1answer
4k views
What is the difference between btree and rtree indexing?
I've noticed on MySQLWorkbench that you can choose how to store your indexes before forward engineering your design. The storage types are:
BTREE
RTREE
HASH
Researching this, I found some ...
9
votes
4answers
732 views
Are there any conceptual drawbacks to building a web app with C++ and MySQL?
I've inherited a pretty interesting project where there is a good opportunity to take an existing piece of software and turn it into a SaaS web app. As the project is inherited, the code base/ ...
9
votes
1answer
669 views
What is the difference between collation and character set?
I have a general question about databases. We usually use the term collation with databases. I would like to know how its different from character set. I guess collation is a subset of character set. ...
8
votes
5answers
803 views
Advice for good web server development setup
A month or so ago I created my first LAMP stack and implemented a simple web site that exercised each letter in that acronym. However my development setup was much less than ideal.
I don't really ...
7
votes
5answers
456 views
Most common website scalability pitfalls
We are designing a website/web application where we hope to to achieve high user counts and, in general, lots of use. More specifically, we intend to be using PHP as the programming/scripting language ...
7
votes
5answers
3k 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 ...
7
votes
4answers
730 views
what is a good way to show mysql experience?
As always, if this is a duplicate question that I have yet to uncover, please feel free to close or delete it.
I'm attempting to get into the programming industry. I've focused mainly on PHP due to ...
7
votes
5answers
737 views
Is MySQL viable for small-medium business applications
After having worked with a Microsoft stack - VB.Net, ASP.Net, SQL Server - for the past 10 years, we are now faced with having to develop an application for both Windows and Mac environments.
It has ...
7
votes
4answers
309 views
OOP design question
I'm working on an application written in PHP using OOP principles. The classes in my application usually represent a table in the database; for instance, 'student', 'teacher', 'class', 'schedule', ...
7
votes
1answer
6k views
study materials for Mysql certification?
I'm preparing for MySQL certification, nowadays officially titled:
Oracle Certified Professional, MySQL 5.0 Developer certification
After looking through MySQL forum it looks like most people ...
7
votes
1answer
306 views
Need help - brainstorming php scheduler class
I've never written a php class before from scratch. But I guess you have to start somewhere right? I've got an idea, but need help with logic. Please tell me what you think. Below is shorthand ...
6
votes
9answers
2k views
Foreign key restrictions -> yes or no?
I would like to hear some”real life experience” suggestions if foreign key restrictions are good or bad thing to enforce in DB.
I would kindly ask students/beginners to refrain from jumping and ...
6
votes
5answers
4k views
Can we develop ASP.NET MVC application with MySQL as the database?
I have mostly seen ASP.NET websites using MSSQL as database. Even I developed one some time ago. Why only MSSQL, when MySQL, a free alternative is available. So, the question is, IS it possible to ...
6
votes
6answers
991 views
Best way to use source control for a project (1-3 people)
So my partner and I are working on a practice management system and at first we didn't use any version control, then I persuaded him to use git. At the moment our system is that we have three ...
6
votes
1answer
259 views
General approach to re-factoring an large, very badly written legacy system [duplicate]
Possible Duplicate:
Techniques to re-factor garbage and maintain sanity?
What is a good way to refactor a large, terribly written code base by myself?
Really open question here. I'm not ...
6
votes
8answers
307 views
How to (professionally) back up reasons for choosing open source technologies in a large project
I know the title is a bit vague so I'll try to be more precise in explaining what's my actual question (I apologize in advance if this is a duplicate).
I work for a small company (8 people) that ...
6
votes
3answers
181 views
What's the difference between the insert methods and why one is faster
I have insert 14.485 lines on MySQL like this:
INSERT INTO `bairros` (`id`,`cidade_id`,`descricao`) VALUES (1,8891,'VILA PELICIARI');
INSERT INTO `bairros` (`id`,`cidade_id`,`descricao`) VALUES ...
6
votes
3answers
480 views
My Cassandra consultant left me and now I'm thinking about reverting to mysql [closed]
I run a middle size community and some time ago I started to develop social capabilities such as follow, status update, wall etc.
For some reason i thought that Cassandra was the right tool for the ...
6
votes
2answers
708 views
Making the switch from MySQL to PostgreSQL?
I've spent the last year becoming really comfortable with MySQL, but due to its increasing trendiness and my desire to homogenize my web-apps with Heroku, I'd like to start using PostgreSQL for my web ...
6
votes
1answer
255 views
Is there a way you'd implement a fast tree traversal method that would support dated versioning?
I've got a catalog at work and I want to juke it up a bit because I'm tired of it being extremely slow. I'd like to support the modified preorder tree traversal storage method for the category tree of ...
6
votes
2answers
301 views
How should I organize the words of a sentence for better outputs/maintenance and performance?
Having this sentence (consider many sentences in the future)
David Henderson Houston patented the first roll film for cameras in
1881.
I can make questions like
1. Who patented the roll film?
...
5
votes
2answers
155 views
Storing stop/start points in a database
Let's say I am storing start and stop points per user into a database table.
For example... let's say in a chat system, a user only needs to see lines 24-293, and 500-512. (Let's say he logged off ...
5
votes
3answers
607 views
what are the best tips for storing images in a database?
Is it appropriate to store the image files in the database? Or it would be better to store only the path of the file in the database, while keeping the file itself on the server?
Are there any other ...
5
votes
8answers
821 views
Top bad practices in MySQL [closed]
There was another post allowing people to post their top bad practices in PHP, I had a gripe about MySQL practices and thought it'd be an interesting topic to hear the top bad practices in MySQL.
Up ...
5
votes
2answers
346 views
What to learn after standard C++? [closed]
I switched to C++ a few months ago, learning its syntax, the main features
of the STL and what you can usually find in a "learn C++" manual.
Now I would like to go further. What would be your ...
5
votes
4answers
284 views
QR Codes as Booking Confirmations for Conference?
A client of mine is holding a conference and we have the task of creating a booking system for them. However they have requested that we use QR codes so that on the door, a person can simply present ...
5
votes
2answers
1k views
What's the difference between MariaDB and MySQL?
What's the difference between MariaDB and MySQL? I'm not very familiar with both. I'm primarily a front end developer for the most part.
Are they syntactically similar? Where do these two query ...
5
votes
6answers
2k views
Is there any reason to use varchar over text columns in a database?
Is varchar just a remnant from before text came around, or are there use cases where you would want to use a varchar? (Or char for that matter..)
(I use Postgres and MySQL (MyISAM) daily, so those ...
5
votes
3answers
1k views
Are there any special advantages of SQL Server with Visual Studio?
I have seen the forum dba.StackExchange, but this question involves Visual Studio as well, therefore I wanted to post this question here.
One of my old application was built on VS-2008 and MySQL ...
5
votes
2answers
2k views
What is the best way to handle different TimeZones?
I'm working on a web application where there will be many different users from all over the world making updates. I'm wondering what the best way to handle timezones would be? Ideally, as an event ...
5
votes
4answers
948 views
Is it time to use MariaDB instead of MySQL on application development? Why?
If you know MariaDB, what's your opinion about migrate applications to use MariaDB instead of MySQL?
What we gain and what we lost with this change?
Is it really unnecessary to change the ...
5
votes
2answers
375 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, ...
5
votes
1answer
600 views
Search multiple tables
I have developed a web application that is used mainly for archiving all sorts of textual material (documents, references to articles, books, magazines etc.). There can be any given number of archive ...
5
votes
5answers
394 views
Should I use a relational datamodel or Cassandra with ColumnFamily based indexes?
Currently we are working on some storage problems for log data from various servers and communication message logs (HTTP(S), XMPP). There will be many write operations and for read operations we will ...
4
votes
9answers
4k views
Is there a large bank using Mysql or PostgreSQL? [closed]
I always thought the largest scale of banks use Oracle. However, there is no proof they really use Oracle instead of Mysql or PostgreSQL, nobody knows the secret.
Any idea what they really use? Can ...
4
votes
3answers
307 views
Rule of thumb for field sizes
What VARCHAR sizes should be used for first and last names, phone numbers (preferably international), email adresses, urls, dictionary words and file names?
Edit: Zapped the introductory phrase to ...
4
votes
2answers
1k 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 ...
4
votes
2answers
346 views
Is mysql_* deprecated after PDO was introduced?
I have been noticing for a long time on Stack Overflow that most users recommend to use PDO instead of mysql_*, because PDO is more secure than mysql_*. But my question is if websites which are ...
