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

learn more… | top users | synonyms

0
votes
3answers
102 views

How should I approach storing single boolean results for a whole table?

I previously asked this question on stack overflow. But have not received any responses that might help me. So I thought I would try here. ...
7
votes
2answers
2k views

Data Synchronization in mobile apps - multiple devices, multiple users

I'm looking into building my first mobile app. One of the core features of the application is that multiple devices/users will have access to the same data -- and all of them will have CRUD rights. I ...
-2
votes
3answers
130 views

Trying to understand how MySQL license applies to code I wrote

I have an ERP, coded with Java and the database in MYSQL Community edition. When I was going to sell it to a client he asked me for the sources to my application (with the belief that it is GPLed). I ...
2
votes
3answers
287 views

Passing data between hundreds of objects in java

Currently, I'm working with a group on building a model. This model simulates interactions between many "agents" in a region. Agents can be any entity such as a city, a farmer, a business etc. Each ...
-1
votes
0answers
18 views

How to list sub-categories when a parent category is selected? ( PHP MySQL ) [on hold]

So here's my situation I am working on MVC Patern. It's not any framework. It's just a basic setup of MVC done by myself. I am building a classifieds Ads Website. There are some categories and some ...
-1
votes
1answer
51 views

Using XAMPP for intranet setup [on hold]

Hi I'm planning to run production code in an intranet of about 12 computers. Is it okay to use XAMPP to run this or are there better alternatives?
0
votes
1answer
52 views

How to implement the use of NoSQL and RDBMS together [on hold]

(I don't have hadoop experience so excuse me if this is irrelevant) I am building a search engine that would scrape a number of websites (not the whole internet) I am planning to write the website in ...
-3
votes
0answers
21 views

Mysql Connector J lisence

I need to use mysql connector to be distributed with my commercial java application.so that are there any solution to have a free licence for connector J, are there any solutions.
-1
votes
0answers
34 views

Hi, is posible to create a Python code for Face Recognition(OPENCV), using MySQL as database? [on hold]

i want to create a Face Recognition code, using Python(OPENCV) and store their values on MYSQL database, then with other code, compare both. I don't want in my database, images, only values and ...
0
votes
0answers
15 views

MYSQL selecting multiple rows of same type [migrated]

From this MYSQL table which has several hundred cities divided into different sets, I need a page to display a clickable link pertaining to each set (i.e. set 1, set 2 etc.) in a list and when one is ...
0
votes
0answers
26 views

Check for expiration by calculating the number of days between given dates MYSQL [migrated]

In my project I need the user subscribed plans which are not expired. When a user subscribe to a plan, it will be entered in a table usersubscription with structure as shown below: id user_id ...
0
votes
0answers
13 views

Should I use session or cache to keep the time it last polled when polling to server at intervals?

I'm building a web chat app using session to keep the time the app last polled so that the server can determine whether messages exist between the current polling time and last polling time. It works ...
0
votes
0answers
9 views

Add arguments to mysql in Django's “dbshell”

I'd like to add a couple of command-line arguments to my Django's ./manage.py dbshell command, and I can't figure out how. In specific I'd like to add -A to prevent MySQL from scanning every table ...
-1
votes
0answers
15 views

How to import mysql modules in Python? [migrated]

As you are aware, I am a complete noob on this. I am trying to use this reusable class to connect to mysql Python Connection with MySQL But whenever i try to run the python I am getting Traceback ...
2
votes
1answer
153 views

PHP Cache Strategy - Genius or Sheer Stupidity?

I have a shared hosting with limited capabilities. Memcache and mod_cache are not available to me. I would like to implement my own PHP caching method to cache the results of load-intensive SQL query. ...
-1
votes
1answer
27 views

Load partial data and data sorting [on hold]

I have one database table that I query on load and display items in a list sorted out by dates (latest first). However, as the table may become quite big, I only fetch the n first rows. To see more ...
1
vote
4answers
143 views

MySQL Database design - Opinions

Im working on a web Application for our bussiness with my brother. Our application its pretty simple, will be develop with php and mysql. Clients and providers ABMs Articles Inventory (we do not ...
0
votes
1answer
72 views

How can I cancel all running mysql queries in a web application?

I am running a web application which has to scan (mysql query on a particular column) a huge MySQL table, which has over 100,000 records. The problem I find that when a user requests another page ...
0
votes
2answers
98 views

Should all foreign table references use foreign key constraints

Closely related to: Foreign key restrictions -> yes or no? I asked a question on SO and it led me to ask this here. If I'm faced with a choice of having a circular reference or just not enforcing ...
0
votes
1answer
47 views

Should I persist notification before or after publishing it through Redis pub/sub?

I'm implementing a mechanism to notify a group of users about newly inserted blog comments. The architecture uses the Redis Pub/Sub mechanism. By definition, the pub/sub mechanism aims to propagate ...
0
votes
0answers
15 views

Best approach for storing banking information [migrated]

I am currently developing an auction desktop application. At the moment I am storing the buyer and vendor information in 2 separate tables within a MySQL Database. Currently the data for these tables ...
0
votes
1answer
22 views

Store Arbitrary values related to mysql record

I have created an app that manages a Data cleansing workflow. Each row imported needs to store an arbitrary number of key value pairs in addition to our standard mysql schema. The key values need to ...
-1
votes
1answer
82 views

Cloud Newbie … what should I know while creating my App [closed]

I never developed for the Cloud, and to tell you the truth I am not fully 100% sure of what Cloud is when coming down to servers and services. I am starting to develop an App where I will need to be ...
0
votes
2answers
152 views

Examples of designing a database that handles point tracking?

I'm attempting to expand my knowledge of how database designs and concepts work. I'm working on a hobby web/mobile app for practice that will challenge me. However, I am running into an issue. What ...
15
votes
1answer
9k 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 ...
0
votes
1answer
196 views

Face Recognition(OpenCV) with MySQL and PHP

First of all I have asked this question on stackoverflow and got down vote for question being not belonging to the site. I am trying my luck se now(more suitable to se I guess) and I hope I will not ...
0
votes
0answers
25 views

What are the memory-management capabilities of MySQL + JDBC (in light of autonomic computing)?

I'm interested in implementing some kind of autonomic-computing functionality using MySQL. By autonomic-computing I mean roughly some failsafe abilities, whereby the application appears to be at least ...
0
votes
0answers
78 views

Penny auction concept and how the timer works

I am creating a penny auction site using PHP yii framework. The main consideration of the system is to update the database records of all active auctions (max 15 auctions) with the current ticker ...
0
votes
1answer
153 views

Inserting data to database from Android

I have to build an application where the requirement is that my clients will send data from their Android device and I have to save that data to a database. I have done the part of coding that ...
0
votes
1answer
941 views

Practical mysql schema advice for eCommerce store - Products & Attributes

I am currently planning my first eCommerce application (mySQL & Laravel Framework). I have various products, which all have different attributes. Describing products very simply, Some will have a ...
27
votes
4answers
4k views

Is backing up a MySQL database in Git a good idea?

I am trying to improve the backup situation for my application. I have a Django application and MySQL database. I read an article suggesting backing up the database in Git. On the one hand I like ...
7
votes
6answers
6k views

Should I encrypt data in database?

I have a client, for which I'm going to do an Web application about patient care, managing patients, consults, history, calendars, everything about that basically. The problem is that this is ...
0
votes
4answers
1k views

How to insert/update a large amount of data into mysql using php

I have an excel sheet which has a large amount of data. I am using php to insert the data into mysql server. I have two problems 1) I have to update a row if the id already exists, else insert the ...
0
votes
2answers
234 views

Large MySQL Batch Inserts From PHP: Run insert from script, or save as SQL file?

We have a large dataset that's current residing in many, many spreadsheets. I've been tasked with getting part of that data into our MySQL DB. When all is said and done, I will probably be inserting ...
-3
votes
3answers
487 views

How to not let anyone inspect elements of a webpage?

I was thinking to make some jQuery functions that will use ajax to control mysql. The whole idea is to make separate files of PHP (e.g query.php, addRow.php, update.php and delete.php) provide data to ...
0
votes
0answers
34 views

Track time spent on site

We are going to track user engagement (i.e. time spent on site, most viewed part/page of the system, etc). I don't see Google Analytics / MixPanel being able to do this, since we have to analyze ...
-2
votes
1answer
1k views

How to check for null in most sql's - “column is null” or “column = null” [closed]

I'm not sure of the right syntax to use. Is it select * from tlb where flag is NULL or select * from tlb where flag = NULL Is the answer the same for oracle, sqlserver and Postgres? Note: I ...
0
votes
1answer
112 views

Commercial use for embedded system

I am developing a embedded system (computer + os + programs) to sell it to a company. I am confused about the licensing and the softwares I wanted to use to develop the system.So I want to know if I ...
10
votes
7answers
402 views

When to start thinking about scalability? [closed]

I'm having a funny but also terrible problem. I'm about to launch a new (iPhone) app. It's a turn-based multiplayer game running on my own custom backend. But I'm afraid to launch. For some reason, I ...
2
votes
1answer
128 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 ...
0
votes
2answers
127 views

When do you use subquery in SQL? [closed]

When do you use subquery in SQL, and what type of request is subquery useful for? I am practicing SQL and need to know how to spot a subquery problem immediately
68
votes
15answers
15k views

Why should passwords be encrypted if they are being stored in a secure database?

I have a web service. Right now, I have passwords stored in plain text in a MySQL table on my server. I know this isn't the best practice, and that is why I am working on it. Why should passwords be ...
1
vote
1answer
78 views

Loosely compare user input with database record [closed]

I have a database table with 3 columns; id, question and answer. On the front-end, I have a PHP application that shows questions to the user. The application would then compare the user input with the ...
3
votes
1answer
128 views

Should a stored proc try to do more, in the attempt to avoid php mysql back and forth overhead

I have a REST architecture, running PHP on the server side which store and query a Mysql database. I am re-evaluating one architecture design decision: DECISION to re-evaluate: In an attempt to ...
82
votes
10answers
10k views

Why is “Select * from table” considered bad practice

Yesterday I was discussing with a "hobby" programmer (I myself am a professional programmer). We came across some of his work, and he said he always queries all columns in his database (even on/in ...
0
votes
1answer
202 views

Why doesn't MySQL have an explicit “No Limit” option for queries?

I use SQLyog Community edition and like many other SQL applications out there it puts a 1000 result limit on queries that do not have a limit provided. I am wondering why MySQL doesn't have an ...
2
votes
3answers
581 views

Is it safe to just use MySQLi?

I have developed an open source PHP application and currently it uses both the MySQLi or MySQL extension for backwards compatibility. I'm wondering about switching it over to only be compatible with ...
0
votes
1answer
66 views

DB Design: How to link a single column to a collection of entities

I have a db design question that I am sure has been quite extensively covered but I cannot find a good answer already. The problem is how to efficiently link a single school course to a collection ...
2
votes
5answers
286 views

Create Database To Fit Data vs Make Data Fit The Database

I'm newish to programming and would like to know what people have found to be the most supportable option or rather what people find more understandable. I'm the only one writing code at my firm, but ...
0
votes
2answers
194 views

mysql, store a single piece of data per row

I am preparing to write a database system using PHP and MYSQL which will store every piece of info sent to it as an individual row. Each row will store several piece of meta data (time stamp, who ...