MySQL is an open-source, relational database management system.
20
votes
3answers
4k 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 ...
2
votes
5answers
569 views
Good techniques to speed up database execution
I have an ASP.Net application that is using a MySQL database. My queries are not executing as fast as I would like them too. Are there some standard ways to increase the speed of a MySQL database ...
5
votes
3answers
746 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 ...
2
votes
1answer
642 views
Is “PHP and MySQL Web Development, 4th ed.” an outdated book to learn from?
I want to get into web stuff, and thought of going with PHP+MySQL. I have experience in C#, C++, desktop graphics, but no web stuff besides HTML, CSS which I started learning 2 months ago.
On SO ...
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 ...
100
votes
13answers
33k 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 ...
43
votes
12answers
16k 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 ...
18
votes
6answers
2k 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 ...
9
votes
5answers
856 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
vote
2answers
382 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 ...
6
votes
1answer
284 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 ...
5
votes
2answers
467 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
5answers
836 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
1answer
671 views
Is map-reduce the basic factor that makes NoSQL more scalable than SQL?
I'm studying the differences between NoSQL and SQL, and what makes the first more scalable. I think I got the point, so I'll try to explain:
Suppose an app has a list of billions of users, each with ...
1
vote
5answers
626 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 ...
