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

learn more… | top users | synonyms

4
votes
3answers
256 views

Do common relational database systems work 'out of the box'?

I'm quite new to software development and whenever I come across small projects which involve storing (relational) data I always ask myself if something like a micro-blog (or any other project with ...
-3
votes
0answers
18 views

Good code resource to learning database interaction [on hold]

I am currently working on project with MySQL database and I am looking for good practices to working with database in Python. The next problem I have is that I want to start with unit testing ...
-3
votes
0answers
24 views

PHP Company Web App - updating database classes [closed]

I've recently joined a small company as a junior web developer that specialises in managing customer orders for small businesses in the catering industry. The company has developed an app in PHP that ...
3
votes
1answer
52 views

Do I need a web-service for this case? Data-synchronization over multiple clients

I'm new in this area and a little bit confused about my current thoughts on a web-service implementation for my application. I want to synchronize all connected clients with the current data on a ...
0
votes
0answers
9 views

Unable to insert datetime value into a MySQL table using PHP [migrated]

I'm trying to run the following code in PHP: <?php require_once 'Admin/Connector.php'; $name = 'A Schandillia'; $number = '12345678910'; $latitude = '73.897687'; $longitude = '11.958271'; $sql = ...
2
votes
2answers
60 views

Design interface for WebService to access several MySQL databases

I am currently trying to design an interface for a WebService that can access several MySQL databases. There will be 4 operations available, Add(), Read(), Update() and Delete(). The WebService just ...
-3
votes
1answer
25 views

Connecting to MySQL with JDBC through Network

I have a desktop application that access the mysql database through Local Area Network. Do i need to install xampp mysql on client computer in order to access mysql database on another computer?
4
votes
1answer
103 views

Social network notification system

Background I am working on an app for a client that includes some social networking features. I was originally developing the mobile front-end, but circumstances have left me in charge of developing ...
1
vote
0answers
180 views

Android, PHP session and JSON object retrieval

I am working on an app in android studio.. it currently has a login and registration system that are linked to a database and both work perfectly. I am now trying to carry over the user id value ...
0
votes
0answers
12 views

Edit files on multiple domains on Mambo CMS

I have multiple domains on same web server, all running on Mambo CMS. Each site uses same template and has roughly same site structure. I need to edit the same page on each website - is there a ...
-3
votes
1answer
142 views

using node.js server with mysql-module and PHP for a penny-auction website? [closed]

I'm building a penny-auction platform like DealDash and just read into the WebSocket and node.js topic. I used PHP, MySQL and Ajax to build the website. I'm nearly finished and just have to implement ...
1
vote
1answer
112 views

Am I planning my database/backend correctly?

I'm an iOS developer and to be honest I'm not really looking to become a database expert right at this moment, but I do need to know how to properly plan out what I believe to be a pretty cookie ...
0
votes
1answer
102 views

How to structure programs that interact with databases? [closed]

I've just finished a book on MySQL and I'm in the infantile stages of learning to couple that with Java. I know that the technology I need to learn is called JDBC and that it essentially allows you to ...
3
votes
2answers
100 views

How to infer the result of a query?

To understand what a query does, I have always thought the following is the procedure on evaluating a query: Form the table as specified in the FROM clause. Pick the rows from that table as ...
-2
votes
3answers
124 views

How to store integer array in mysql database [closed]

I am making a college attendence system so i need to store attendence of thousands of students. if I go for 1 column for each day then it will take 12*30 almost 360 column for a year. So I want to ...
1
vote
2answers
321 views

Is this a race condition?

I have a friend arguing this is a race condition, but I'm struggling to understand how. This is for a web application using PHP and MySQL where users can login and create tickets, these tickets have ...
1
vote
2answers
74 views

What is better for scalability for this specific dataset, MongoDB or MySQL?

I have a web app which has users, forms, and volunteers signed up on those forms. Currently I am using MongoDB and have it setup with a collection for admins, and a collection for forms with ...
3
votes
4answers
137 views

How to save many changes to database data?

I'm working on a feature which will pull many (say, 1000-5000) rows from a database, display them to the user and allow the user to edit them. This editing may involve changing text; adding rows at ...
0
votes
1answer
119 views

php Database operations in separate files?

I have a single page application. Select boxes need to be filled with select queries from the database. How do I structure the application? Currently I have a file add_details.php. It contains a ...
1
vote
1answer
314 views

Need to store Multiple Images (path) into MySQL after upload [duplicate]

I am trying to build my own little eCommerce CMS, and i want the expert opinion on how to handle multiple uploaded files (images). For Example: A user adds a new item, fills the necessary form data ...
2
votes
1answer
92 views

How to deal with server-side and client-side naming conventions that clash? [closed]

I have a project that uses the underscore naming convention for the MySQL database and PHP scripts but uses camelCase for the javascript application (a common scenario I'm sure). However, once JSON ...
0
votes
3answers
136 views

When to use a nosql database such as mongodb over mysql?

I'm new to the concept of nosql databases and have never used it. Based on what I've read and the little that I've understood I still don't see how they can be particularly useful if you can't make ...
0
votes
2answers
58 views

DB Schema for a questionnaire - Different output from different combinations of responses

A user is required to complete a questionnaire - answering the questions in various categories. Depending on the responses from the user, the user will be presented with a number of recommendations. ...
0
votes
2answers
76 views

Best Way To Store Images For Mobile Synchronization

The scenario is, I have a Web Dashboard (Developed using PHP + MySQL) and have Android and iOS Apps synchronizing data from the Web Dashboard (only one way i.e. Dashboard to Mobile Apps) Now the ...
1
vote
1answer
281 views

mySQL / PHP design pattern - one function multiple queries

So here's the gist of it. I'm looking for a design pattern where I can have one function, say queryHandler that gets the query and the parameters from a number of different functions and returns the ...
0
votes
1answer
157 views

Like structure table with Laravel and showing the most popular content at top

I am using Laravel to creating a website, my users can post questions and other users can write their comments under the post, each comment have Up vote and Down vote, and users can voting for ...
1
vote
0answers
33 views

Database integration of Rails and Laravel apps

I have some very small apps on a VPS running ruby on rails and a co-worker also have some of his own apps running on laravel at another VPS. So far we dont needed to share any data among the apps, but ...
49
votes
6answers
5k views

Should Latin-1 be used over UTF-8 when it comes to database configuration?

We are using MySQL at the company I work for, and we build both client-facing and internal applications using Ruby on Rails. When I started working here, I ran into a problem what I had never ...
2
votes
1answer
107 views

How to design database tables for a Factory class?

How can I design database table structure for a class that varies in its core parameters, when it is created by a factory method? I have a Factory like this: class ProductFactory { public ...
3
votes
3answers
247 views

Do I need use really INNER JOIN?

Imagine a coiffeur, with his services: +----+-----------------+--------+ | id | name | amount | +----+-----------------+--------+ | 1 | hair cut | 40 | | 2 | shampoo | ...
0
votes
0answers
70 views

What could possibly be a Mysql database structure for an web app say like Flurry?

Simply say, I'm working on a web App say like Flurry (http://www.flurry.com/), that would communicate with a Smartphone App trough API. Right now I'm designing the database structure, and I guess ...
2
votes
1answer
94 views

What should be the structure of a person to person store database?

I am going to create a person to person store with Laravel, a website where its users can share and sell their product or their mobile, TV, Computer, Shoes, Shirts, Books, Cars, Bags, Animal, etc. I ...
2
votes
2answers
528 views

Database performance comparison

I have been tasked with moving from a MSSQL backed database, entity framework code-first, wcf service based MVC application to a MySQL backed database. I have had being trying to find a performance ...
2
votes
1answer
137 views

What is the purpose of stopwords?

I've just started learning about fulltext indexing and searching in MySQL and I've stumbled upon this list containing all of the "stop words" used in MySQL. I cannot understand what is tue purpose of ...
2
votes
1answer
304 views

Should I use foreign keys in my database if I use laravel?

I'm creating a website with Laravel for the first time. I checked relationships documentation today and it seems that Laravel just uses simple SQL queries. class User extends Eloquent { public ...
2
votes
0answers
112 views

PHP MySql - Statistical Reporting - Best Approach to query appointment system time utilization

I have built an appointments system for various medical practices. Practice schedule appointments - I am looking to provide analysis on the amount of time that has been utilised by the practice. I ...
0
votes
0answers
30 views

Querying all data vs required data [duplicate]

If I have a MySQL database that has a table that contains user data, would it be better to load all of the data from the table when loading a page that requires a users data (only one users data is ...
0
votes
1answer
713 views

Designing a scalable schema for college database [closed]

I am trying to build back end for college ERP system. The system will be based on LAMP. These is the scenario: Colleges have 5 branches There are 4-6 classes in each branch. There are 80 students ...
4
votes
1answer
334 views

What is the best way to format complex SQL queries in Node?

I am using node-mysql to query a MySQL database via Express and Node. My queries are getting fairly complex and I want to format them across multiple lines. However, the only way I could accomplish ...
2
votes
2answers
282 views

Creating a separate table for images or adding “image fields” to many tables?

I need to create a database in which several tables have images. For example, users have profile pictures and uploaded ones and products have many pictures, as well. Is it better to have one MySql ...
1
vote
1answer
43 views

Should I do a different SQL table for user privacy settings or just keep it at the users table?

So I am developing a Web Application and I have some concerns about the database. I use a lot of boolean settings at the user table with the form privacy_allow_1, privacy_allow_that, ...
1
vote
2answers
209 views

Improve the speed of a Tomcat Server with MySQL

I'm developing an application with 3 sides, desktop (JavaFX), server (Tomcat) and Android. And a MySQL Database Server. The app receive mails and convert them into tasks. The tasks are sent to the ...
0
votes
0answers
31 views

I have two applications… use NoSQL or RDBMS? [duplicate]

I have two applications in the making: one is a budget management tool; the other is a article based places/restaurant guide. The budget management tool works where users create accounts (e.g. bank ...
0
votes
1answer
196 views

Notify about starting event

I am having quite a hard time figuring out how to solve this problem. Basically I have a mini social network with notifications and events. I want to add such functionality where 1 day before an event ...
0
votes
1answer
136 views

DAL / Model / Application-Design Question for a MVC Application

I have a device that stores raw binary log data as a BLOB in a MySQL DB. That process is a blackbox to me (closed source) which I cannot change. I know, however, how to decode that BLOB and transform ...
1
vote
0answers
66 views

Automatically verifying INSERTs when building a PHP(5.3.3) application

I am building a form in PHP. I would like to automatically verify that INSERT queries are successful, and populate data correctly, as opposed to running queries in Workbench or MySQL with every code ...
-1
votes
1answer
110 views

Best way to track 200 boxes [closed]

I have a php/mysql application that needs to track a simple on or off setting for 200 boxes. I use it for a fundraising application. Basically there are 200 buttons. A user selects a button numbered ...
4
votes
1answer
2k views

Architecture for a mobile (Android) chat application

I want to develop a chat application that reminds a bit whatsapp, I am doing it as a learning project. I am currently doing it on Android just because I am doing an Android course. The requirements ...
0
votes
1answer
127 views

Improve processing of data (and structure) from flat file to CMS Database

I have a flat file (CSV) that brings me the data I want, but it needs to be cleaned and processed before it can be used, so I built an intermediate Database (MySQL) in order to get the structure from ...
0
votes
1answer
210 views

RDBMS (MySQL) logic question. How to join multiple “FRIENDS”

so this is a logic question as to creating the proper relationships in a MySQL database. What logic would you choose for the following scenario? This is a back-end for an app where people can have ...