MySQL is an open-source, relational database management system.
1
vote
2answers
53 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 ...
2
votes
2answers
44 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
48 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 ...
-4
votes
0answers
21 views
an elearning platform in PHP,mySQL and a connected second databases in MongoDB & both having live updates capabilities [on hold]
I've been developing an elearning platform in PHP,mySQL.
Now, I'd like to create second databases in MongoDB & connect both with live updates
I've been searching for this answer quite eagerly ...
-3
votes
0answers
27 views
In netbeans when i run the servlet i get the following error.Why? [closed]
org.apache.jasper.JasperException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): ...
-1
votes
0answers
26 views
F# convert an XML into CSV or directly import XML into database [closed]
I am new to F# and the latest releases of MS stack. If I have a complex XML file which I want to import(Repeatedly when new files given) into a database to then query, analyse and represent them what ...
-4
votes
0answers
26 views
Sync Microsoft dynamics(nav) with remote mysql [closed]
I am very new to dynamics.I want to sync dynamics data with Mysql Databse in my server.So that when ever I enter new data into Nav it should also reflect in my website(which is build with PHP and ...
-1
votes
0answers
5 views
How to execute prepared statements inside stored procedures with user vars? [migrated]
I am trying to write a stored procedure to create a temporary table with variable columns created based on the linked data of 2 tables. I get the variable fields to be added to the temp table using a ...
0
votes
0answers
13 views
How to push data from one page to another [PHP] [migrated]
I'm using sockets.io, express and php and I was wondering if it is possible to push something of a page (that only a specific user can see at the time) to another page other can see. For example, if ...
1
vote
1answer
101 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
74 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
83 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
36 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
44 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
115 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
54 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 ...
0
votes
0answers
23 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
90 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
243 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
40 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
90 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
275 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
134 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
166 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 ...
1
vote
0answers
91 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
29 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
266 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 ...
3
votes
1answer
149 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
189 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
32 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
167 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
29 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
132 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
111 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 ...
0
votes
0answers
58 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
105 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 ...
3
votes
1answer
1k 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
112 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
163 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 ...
12
votes
8answers
406 views
500 databases or 1 database with 500 tables or just 1 table with all the records? [duplicate]
I currently have an application that is used by a single end customer. For ease of discussion assume the application only needs a single database table for all records. I now need to support ...
1
vote
1answer
124 views
Transferring information between a web server and a Python backend?
I have been Googling my problem but haven't been able to come up with anything; here's the situation:
I have a PHP / MySQL website hosted with 1and1.com.
I also have a Python program that runs on a ...
0
votes
0answers
123 views
How many functions called by other functions are too many?
I posted a question about a week ago about using PHPExcel with multiple cases of use and how to simplify it. Since then my process has simplified as we've agreed to work with a single lay out with ...
1
vote
2answers
105 views
How to minimize networking cost of distributed game database?
We've been working on a networked online game project which will run in near future and
looking for a satisfying solution for our distributed game database. We didn't take networking costs
into ...
0
votes
2answers
126 views
SaaS model, 1DB per client
The context
we're building a web-based system and one of the design decisions (database related) was whether to have 1 main DB manage all client data VS having 1 DB per client.
After reading a lot ...
0
votes
4answers
637 views
Notifications system with too many subscribers
In my application users can subscribe to other users, like in every social network out there. However I'm experiencing some trouble when a user has too many subscribers. Every time a user posts ...
0
votes
1answer
176 views
Act as MySQL server in Java/Android [closed]
Is it possible to act as a MySQL server in a Java or Android application, such that applications like HeidiSQL can connect to it?
What I want to do is to write an application for Android which ...
0
votes
1answer
85 views
How to implement a Daily Recap email of Database records modified the previous day sent to Subscribed Users like Basecamp does?
I am building a Project Management module for SugarCRM. It consists of a "Project" which has information on the project like Name, description, start and completion dates,
creator name, status ...
0
votes
1answer
91 views
Repurpose MySQL as a mutex
My application needs to perform an operation once every 10 minutes, but that operation is triggered many times more frequently. Occasionally it is triggered three or four times a second in different ...
0
votes
0answers
173 views
Best practice: dynamically handle variable data, multiple file uploads and encoding with jQuery, AJAX, PHP and MySQL
I'm currently writing an e-learing web-application. I'm sorry if this is information overkill but I think it's better to describe it in detail so you get the idea. I have made thought on every point ...
