MySQL is an open-source, relational database management system.

learn more… | top users | synonyms

2
votes
6answers
1k views

what is the benefit of using key/value stores with respect to database sharding?

What has key/value stores got to do with making database sharding easier? Because if I do not use a key/value store, I can easily shard my database too right? (Like say, I can easily say users with ...
2
votes
1answer
826 views

Is there a scalable multi-site strategy with codeigniter?

I've been looking for a efficient and secure way of enabling multi-site capabilities to codeigniter for a while. These two(one & two) articles I found pretty interesting, but they don't seem to ...
7
votes
4answers
406 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', ...
1
vote
1answer
2k views

PHP/MySQL Database application development tool [closed]

I am an amateur PHP coder, and have built a couple of dozen projects from scratch (including fairly simple e-commerce systems with user authentication, PayPal integration etc - all coded by hand from ...
0
votes
1answer
123 views

Which EXPLAIN SELECT is better — the one in PostgreSQL or the one in MySQL? [closed]

Or are the two basically the same when it comes to figuring out how to build the right indexes?
0
votes
1answer
652 views

How To Build An iPhone App With A Web Server?

I have an iPhone app out that stores data on the device. I want to create an app with user accounts like Instagram, Path, Foursquare, Gowalla, etc. What would you recommend for the quickest and ...
3
votes
2answers
240 views

Is there a good way to team develop using different MySQL Instances?

This may be a noob question but a colleague and I are working on a project. Some background about our situation is: We control versions using a centralized git server inside our office. We code in ...
1
vote
3answers
314 views

What happens to get database information on the server-side with AJAX?

I'm slightly confused about how AJAX works. I mostly understand the PHP/MySQL model of retrieving database information for the user, but how does AJAX do it? From what I understand the AJAX engine ...
2
votes
4answers
712 views

Advice on making sure e-commerce site is secure using PHP and MySQL

Like the title says, I would like some advice from knowledgable web developers on figuring out security issues for my e-commerce site. I am designing the database as well as the code that ...
2
votes
1answer
1k views

How does Facebook calculate mutual friends?

How does Facebook calculate mutual friends? Does it cache all mutual friends for each user? Does it use MySQL to calculate mutual friends with a query?
5
votes
9answers
6k 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 ...
1
vote
2answers
700 views

PHP and SQL, together or individually? [closed]

I am done with HTML and CSS. Now I want to know whether I should study PHP and SQL together or individually. Basically, I have this book, O'Reily Head First PHP and MySQL. Should I take this book or ...
3
votes
2answers
689 views

Speed of MySQL type index access vs. binary jump search on a huge file?

I am dead set on moving over to a MySQL database for some huge data sets I'm working with but right now I don't have the time. In the meantime I am curious about a technical performance issue ...
5
votes
7answers
6k views

Best practices to follow with database indexes [closed]

What are some DOs and DONTs for improving database performance using index? A DO would be a case in which an index should be created, or another indexes related tip that will improve performance. A ...
0
votes
2answers
10k views

What are the limitations that MySQL community Edition? [closed]

First of all, my question is related to MySQL Community Edition regarding web development. I have no idea about the features it provdies. However, I would like to look at its limitations in web ...
1
vote
4answers
187 views

Escaping strings in database layer

Can escaping functions (e.g. mysql_real_esacpe_string ) be moved down to the database layer where we would loop through all parameters passed for all queries and escape all strings. Would that be a ...
2
votes
3answers
289 views

Free/low-cost online resources to study for certifications [closed]

So I am interested in working towards are few specific certs. Namely Oracle 11g, MySQL, and Java. I know there are tons of books out there, and I do plan to hit up my local library on these subjects ...
3
votes
5answers
1k views

For a large website developed in PHP, is it necessary to have a framework?

I am wondering if it is necessary to have a framework or if it is a must-have if I plan to make a large website. Large website could mean a lot of things: in other words, multiple dynamic web pages ...
1
vote
5answers
960 views

What is better making a separate temporary table or inserting directly to big table?

I have a big table with 1,400,000 rows, and I need to insert 3000 rows daily in it. When I insert 3000 rows daily should I first insert to a temporary table than dump that temporary table to the ...
6
votes
8answers
382 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 ...
37
votes
11answers
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 ...
0
votes
2answers
93 views

Machine-Generated Data Sources for Infobright Coding Competition

I'm looking at entering the Infobright Coding Competition. They ask for public machine-generated data. I don't want to create my own. Anyone know where some exists? Here's what I'm looking at: ...
3
votes
1answer
8k views

study materials for Mysql certification? [closed]

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 ...
19
votes
6answers
3k views

Pitfalls of using MySQL as your database choice? [closed]

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 ...
1
vote
3answers
1k views

MySQL proficient?

I've been looking to apply to various web development intern jobs, and I feel comfortable with the PHP/CSS/HTML that they are asking for, but what does MySQL proficient mean? I've designed my own ...
6
votes
2answers
3k 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 ...
0
votes
2answers
479 views

Encoding issues from MySQL database to PHP page

So I've been working on a small, small side project to learn a bit more about PHP database interactions. I bought a small, cheap database of "Inspirational Stories" and set to work on turning it into ...
8
votes
9answers
3k 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 ...
5
votes
8answers
1k 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 ...
1
vote
3answers
89 views

Do you store mysql exports in your version control tool for reverting to in event of error?

We run an internal web server with in-house software to run a manufacturing line. When new product features are to be added, either or both of the following occur: changes to the in-house server ...
4
votes
6answers
3k views

How could there still not be a mysqldb module for Python 3? [closed]

This SO question is now more than two years old. MySQL is an incredibly popular database engine, Python is an incredibly popular programming language, and Python 3 has been officially released two ...
9
votes
5answers
911 views

Advice for good web server development setup [closed]

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 ...
-1
votes
1answer
163 views

Launching web-app with database without static ip [closed]

I have created a small web-app and want to deploy it. I have used struts2 and mysql for the database. The problem is that I do not have a static ip to run the app on my machine. Can anyone suggest me ...
12
votes
2answers
1k 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 ...
1
vote
5answers
685 views

Php: Whats my next step? [closed]

So in college I started learning Php, mostly starting with the Larry Ullman books. I got a job at a company after, where I was able to learn some stuff from the higher up guys. Since then, I've done ...
10
votes
5answers
393 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 ...
3
votes
2answers
236 views

Server and MySQL safety for Java / JDBC applications?

I have an external java application which use JDBC as to reach an MySQL database. This will be used by many people and is going to store all the people's data on the same server / MySQL. As I bet ...
13
votes
4answers
878 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 ...
6
votes
4answers
1k 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 ...