Skip to main content

Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
6 votes
3 answers
7k 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 back-...
RPK's user avatar
  • 4,378
1 vote
2 answers
583 views

Is it more efficient to query once for all settings, or query whenever a setting is needed?

For my blog script I have a usergroup and permission system set up. Each user is assigned to a usergroup and I have a long list of permission settings. Both are stored in a MySQL database. At the ...
Jared's user avatar
  • 111
1 vote
2 answers
977 views

what is storing data in constant space?

"bloom filter allows us to store data in constant space" Can someone explain what exactly does that sentence means?
Timothy's user avatar
  • 21
3 votes
5 answers
2k 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 ...
jaytufch's user avatar
2 votes
1 answer
2k 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 ...
Brennan McEachran's user avatar
7 votes
4 answers
660 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', etc....
Matthew's user avatar
  • 172
4 votes
2 answers
2k 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 ...
Sergi Juanola's user avatar
1 vote
3 answers
397 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 ...
Ein Doofus's user avatar
2 votes
4 answers
2k 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 ...
user avatar
2 votes
1 answer
6k 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?
rodi's user avatar
  • 95
12 votes
9 answers
28k 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 ...
YumYumYum's user avatar
  • 377
3 votes
2 answers
2k 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 ...
Robert Oschler's user avatar
18 votes
7 answers
30k 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 ...
Click Upvote's user avatar
  • 2,727
2 votes
3 answers
205 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 ...
Imran Omar Bukhsh's user avatar
173 votes
21 answers
162k views

Stored Procedures a bad practice at one of worlds largest IT software consulting firms?

I'm working at a project in one of the world's top 3 IT consulting firms, and was told by a DBA that company best practice's state stored procedures are not a "best practice". This is so contrary to ...
1 vote
5 answers
2k 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 ...
WebDev's user avatar
  • 839
6 votes
8 answers
638 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 ...
Michael J.V.'s user avatar
38 votes
11 answers
3k 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 ...
Lightness Races in Orbit's user avatar
0 votes
2 answers
99 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: ...
user avatar
21 votes
6 answers
6k 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 ...
user avatar
9 votes
2 answers
11k 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 ...
Thomas Hunter's user avatar
0 votes
2 answers
703 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 ...
Aeo's user avatar
  • 885
1 vote
3 answers
124 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 ...
therobyouknow's user avatar
9 votes
5 answers
1k 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 ...
John Berryman's user avatar
-1 votes
1 answer
176 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 ...
SonOfTheEARTh's user avatar
1 vote
5 answers
1k 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 ...
user avatar
12 votes
5 answers
603 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 code,...
GeminiDomino's user avatar
5 votes
2 answers
501 views

Server and MySQL safety for Java / JDBC applications?

I have an external java application which use JDBC as to reach a 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 ...
Skarion's user avatar
  • 83
13 votes
4 answers
1k 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 ...
JD Isaacks's user avatar
  • 8,936

1
7 8 9 10
11