MySQL is an open-source, relational database management system.
3
votes
1answer
214 views
Technique for multiple users on same datasets
This is more a learning question than coding, but I'm certain it's a common issue for anyone developing administration systems or applications in php/mysql/js etc.
I've developed quite a complex ...
0
votes
2answers
396 views
How to store personal information properly?
It's not about security or something. There is a table to record user information, like username, password, postcode and so on, one record per person. There is also a table called post to record the ...
6
votes
1answer
263 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 ...
0
votes
1answer
227 views
Is it common to have stored procedures disabled on MySQL managed hosting plans?
I'm building an app that I think would benefit from the use of MySQL stored procedures. I know stored procedures have a bad reputation, but I think they suit my application well. Using stored ...
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 ...
0
votes
1answer
87 views
How To Handle Previously Uploaded Files
I'm new to PHP and MySQL and I've only seen posts related to this on Zend and ASP so I'm looking for some advice to point me in the right direction for a LAMP project.
I'm putting together a webform ...
4
votes
2answers
9k views
Datetime vs Timestamp in MySQL and PHP in practice?
I am not sure how to specify my datatype as datetime or timestamp, I think I will need both of them but on the different events. My website sells products and services worldwide and also have an ...
2
votes
1answer
310 views
What programming languages and skills are required in addition when building freelance platform with python?
I have a question about compatibility and co-integration of programming languages, databases, frameworks, libraries, different API and more (together referred as “items”). I have added a list of ...
2
votes
2answers
110 views
Protecting an Application with Logins
I am a beginner Java programmer, and have tried searching for a way to set up a login system with my Java application. The application is a game and I do not want people to just upload it to a ...
1
vote
3answers
166 views
Request Information from iPhone/Php developers
recently I hired a freelancer to develop an iPhone application for my website, this application will get information from the DB of the website, normally I should give to him the access to the DB to ...
1
vote
2answers
300 views
Database design
I'm on the way developing an application which requires a kind of dynamic database,
So this is what I want,
This is the for reading the details of a class, the number of variables and methods ...
6
votes
3answers
481 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 ...
19
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 ...
2
votes
1answer
92 views
Doubt regarding search engine/plugin(One present on the website itself)
I am new to web development and trying to study various types of websites as case study. Right now my focus is on how search engines works for an eCommerce website.
I know basic functioning for a ...
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 ...
1
vote
3answers
319 views
Is a book about MySQL 5.1 still relevant, with the release of MySQL 5.5?
I am considering purchasing High Performance MySQL (2008). This book discusses MySQL 5.0 and 5.1. Is this book still relevant today, or is it too old?
2
votes
1answer
489 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 ...
2
votes
5answers
511 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 ...
7
votes
4answers
747 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
1answer
315 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 ...
5
votes
5answers
398 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 ...
6
votes
2answers
314 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?
...
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 ...
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 ...
3
votes
3answers
601 views
Why put SQL statement in a variable before using mysql_query()?
I'm been working with PHP on and off for a bit now, and I've seen plenty of code both ways:
$sql = "SELECT …";
mysql_query($sql);
vs
mysql_query("SELECT…");
Is there a reason for separating the ...
2
votes
2answers
395 views
Learn PHP and MySQL Together [closed]
I'm starting a new project next week and my only real world experience is in Objective-C (with very basic classroom knowledge of other languages.)
I want to spend my free time this week learning ...
0
votes
1answer
188 views
What Is A Good Benchmark Tool For Use With MAMP? [closed]
I'm wondering if you can suggest a Benchmarking Tool, compatible for use with MAMP?
4
votes
3answers
347 views
How should I implement Transaction database EJB 3.0
In the CustomerTransactions entity, I have the following field to record what the customer bought:
@ManyToMany
private List<Item> listOfItemsBought;
When I think more about this field, ...
1
vote
1answer
2k views
What is the Best Collation for Use in MySQL Tables?
I'm curious what is considered the standard today for use as the Collation of MySQL Tables?
I was told that Latin-1 was the best choice when I was beginning with MySQL, but came across this post from ...
5
votes
1answer
605 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 ...
3
votes
7answers
2k views
What is the best way to INSERT a large dataset into a MySQL database (or any database in general)
As part of a PHP project, I have to insert a row into a MySQL database. I'm obviously used to doing this, but this required inserting into 90 columns in one query. The resulting query looks horrible ...
7
votes
6answers
1k 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 ...
4
votes
2answers
448 views
DRY with Dynamic SQL vs. prepared statements
When dealing with data, one finds that, essentially, the same code is repeated in various incarnations:
-- MySQL:
CREATE TABLE users (
id int NOT NULL auto_increment PRIMARY KEY,
name ...
5
votes
3answers
632 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 ...
1
vote
3answers
416 views
Rails data model - best practices question
I'm writing a Rails cookbook app as a learning exercise. I've created a table for Recipes which holds info for the recipe (name, author, etc...). I also have a table for Ingredients which will be a ...
0
votes
2answers
707 views
Is score from Oracle MySQL 5 Certified Associate Exam given on the certificate?
I will be passing Oracle MySQL 5 Certified Associate Exam and I want to know, if my percentage score will be given on the certificate? And will it be given to me at all? Or I will just know if I ...
2
votes
5answers
564 views
How to automate a tasks system in a CMS software
I'm currently developing v2.0 of my personal cms. However, I'm stuck. I strongly feel that my old solution for "tasks" is not very dynamic and must be revisited. Currently I'm looking the whole ...
3
votes
2answers
532 views
Need to make a stock inventory application
I need to make an application for my dad to keep track of stock trading inventory. He trades shares for himself and for his clients and would like to keep the records, things like buy/sell price of ...
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 ...
4
votes
1answer
161 views
What's the standard for entity design/database connectivity for a mySQL database?
I'm hosting a solution that serves as a web tier on a Ubuntu machine running Apache and Mono. I'm currently developing the project on OSX, using Mono. I understand there is no native support for ...
1
vote
2answers
217 views
best practice when working with a MySQL database datadir directory
At the place I currently work they do some thing I consider strange in the way they work with the MySQL datadir. The directory in which the files that actually store the data are kept.
$ grep ...
2
votes
2answers
101 views
Creating experimental database
This question is about databases but I prefer to post it here and not in dba.stackexchange. The reason is that I have concerns with the application as well as database design. Programmers can better ...
9
votes
1answer
712 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. ...
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 ...
1
vote
2answers
276 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 ...
1
vote
2answers
337 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?
2
votes
6answers
950 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
491 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
312 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
2answers
1k 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 ...
