Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

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

0
votes
0answers
19 views

Design for Handling Spatial Data using EF Core and MySql

So EF Core support for spatial data is practically nonexistent at the moment. The majority of work that has been done is about to drop in the 2.2 Preview 3 which is fantastic news. However, it's ...
2
votes
5answers
516 views

Is it safe to put SQL statements in my C# application?

I'm making a medium sized application to be distributed privately to several Churches. It connects to an Azure database but it does not have any server managing the information (apart from the SQL ...
-1
votes
3answers
100 views

DB architecture for managing items of different categories

I'm making a rental app which has many categories with unique properties Example: Category 1 Car which has Fuel, model, color, speed Category 2 Apartment which has Rooms, lift, ...
0
votes
0answers
21 views

Using Redis with Multiple servers and databases

I am working on a project where I have two web servers both running a replicated version of MySQL. Without going into the technical details of the project, the basic idea is, the app will receive HTTP ...
-1
votes
1answer
34 views

How to find the best match (set of options) among several sets of options?

Imagine a couple dozen services (sets of options), each of which contains a subset of all available options. I want to create a web form listing all possible options so that users can check the boxes ...
0
votes
0answers
122 views

Codeigniter Notification System URL Structure

First I apologize for my english. I am trying to develop a facebook-like notification system with Codeigniter. I know it's much better technology, but it's not about using them right now. The ...
0
votes
2answers
127 views

How to build reports for an ecommerce webapp without slowing it down

We have a medium sized ecommerce website which is entirely custom built in using Java and MySQL database on AWS infrastructure. Over a period of past several years, our orders volume has grown ...
0
votes
1answer
47 views

Partitioning table by aggregate id for efficient eventsourcing in RDBMS

My events are stored in MySQL and I'm reaching a point where I have tens of millions of rows and things are starting to get sluggish when pulling an aggregate I have read about "table partitioning" ...
1
vote
4answers
219 views

Strategy to improve performance on key-value pairs table

The situation Our system has a MySQL database with a product table whose parameters can't be modified. In order to add optional extra parameters, a developer designed a key-value pair table which ...
1
vote
0answers
251 views

Database design for a subscription service transactions

I need to create a table or a set of tables that needs to house transactional data of a subscription-based service, so that certain metrics can be queried efficiently paired with necessary post-...
0
votes
2answers
142 views

Do i need 2 tables to book entity?

I am developing a website to store books info such (title, book_no, author, edition, container...). I have two types of insert insert series of books (Eg: harry porter series: chapter 1, 2,3...) ...
0
votes
1answer
42 views

Dealing with server errors/database data when processing client requests

Suppose my server PHP end point follows something along the lines of the following: Client sends request to server. Server updates a record Server might do some PHP processing... Server updates ...
1
vote
1answer
244 views

Strategies for managing legacy data for a medium sized enterprise

I work for a mid market manufacturing company with around 1700 internal employees and about 7000 external users (employees of our customers). We grew through acquisition which means we have many ...
-1
votes
1answer
58 views

How to implement unique usernames from a list of phrases

I am looking to create a random username based on a set of existing phrases plus an integer since there can be multiple users with the same phrase. For now lets assume there's 12 phrases such as ...
-1
votes
1answer
66 views

Single Stored Procedure Per Table Update or Per Column Update

Let's say i have a table (in a large enterprise application) that has about 10 columns. I am limiting any consumer access to the table to only be possible by calling stored procedures. When it comes ...
1
vote
2answers
239 views

Optimal use of hibernate with mysql's stored procedures

I am working on a project (to use as a reference). The project uses mysql, hibernate and spring (REST) and is supposed to be a single microservice. I have come to find out that limiting user/consumer ...
2
votes
1answer
116 views

What is the best way to maintain synchronicity between a table that has a list of another table?

I used to do Java development and with JPA, I don't really have to worry about the synchronicity between a table and the lists it owns. For those who don't understand what I mean, here's an example. ...
-3
votes
1answer
88 views

What is the best way to deal with an existing Table with around 900 columns in mysql? [closed]

I am currently get a job and faced to a Table with around 900 columns in their database. I am not sure what should I do instead of re-design the database, Please advice me for this situation that I ...
1
vote
0answers
58 views

Optimistic locking vs separate lock store for background workers

I need to compute the value of a row R on a table based on rows queried on another table B. I need to do it in a queue worker because the computation of the value can be slow. A message is queued ...
0
votes
0answers
219 views

Storing template like data partially as JSON in MySQL or as flat JSON file

I am working on creating a import/export template solution for a web application. The web application has "Departments" (stored as a MySQL table departments) and each "Department" has a set of "...
-2
votes
1answer
58 views

How to calculate user activity

I am working on a Xamarin.Forms PCL social media app project. People can like posts and comment on them which is saved in MySQL. I would like to add an activity page. What is the best way to ...
-2
votes
3answers
131 views

Keeping Different users data in same database

I am a fresh frontend web programmer. and I recently programmed few types of web based mobile applications(means originally developed on web using angularJS and I have used a tool to create .apk file)...
0
votes
0answers
265 views

Best options to get centralized PHP/MySQL app working in a distributed (offline) manner?

I have a situation where we have an old PHP/mySql application (10 years old, no framework, about 10 tables) that is used on a few facilities (less than 10) in different parts of the world. The main ...
0
votes
1answer
60 views

Using mysql's\mariadb's root user for development on a docker development environent running multiple application instances

I have setup a docker-based development environment having the following images as you can see in docker-compose.yml: version: '2' services: phpBB_dev: build: context: . dockerfile: ...
0
votes
0answers
32 views

Sync approach from mobile to server and vice versa

We are working on a enterprise application which will be used on web as well as mobile. As per clients requirement the mobile application needs to work offline and sync the data with the server when ...
-1
votes
2answers
232 views

How do i create a logic for dynamic product list page like below using php and bootstrap?

The big image is catalog or ad blocks that comes from catalog table. And small images are the actual products block that comes from product table. There may be more products and more catalog. ...
0
votes
1answer
74 views

Server load/capacity based on data structure

Using PHP, I created a chatbox, and I used an unorthodox way of storing chat messages in MySQL. The tbl_chat_messages has the following columns: id | sender_id | receiver_id | message | date The ...
2
votes
0answers
795 views

How to store unique sessions for logged in user(s) with different devices?

I want to do something like Facebook does. We can see any time where we're logged in. e.g.: Windows PC · New Delhi, India Edge · Active now Windows PC · New Delhi, India Chrome · 8 minutes ago ...
0
votes
0answers
31 views

Looking for a way to modernized/simplify the validation core of a system

i'm working within a manufacturing company and i've been trying to work out a revision to the core validation of an old (Transaction and Tracking) system i have been incubating for almost 2 years now. ...
0
votes
0answers
47 views

How to implement a session mechanism for an always-open SaaS platform

The SaaS platform I'm working on should have a rather desktop-app-esque feel to it. Meaning it would be the main management software for my client's businesses and will be always open on their ...
1
vote
2answers
70 views

Sql: Pre inserting relational entities vs the “lazy creation” of the entities

I have the following entities in my database (it's simplified): Student (id) StudentCourse (id, student_id, course_id) Course (id) Lesson (id) LessonCourse (id, lesson_id, course_id) ...
0
votes
0answers
45 views

Best way to implement a unified database of several shared database

i'm implementing a sync service that store the database of a device into another. Right now, the source system use a very simple table schema: The PK is a varchar(40) always. To do the sync, I ...
1
vote
2answers
840 views

Build a realtime chat app which stores messages in a MySQL database

I'm thinking of making a realtime chat app that would allow me to store user messages into a MySQL database. So far these are the two ideas I have. 1) Create and API which the message is sent to and ...
0
votes
2answers
558 views

Design - JSON Strings storing large amounts of data for large amount of users

I have a website that allows users to be "tracked" and track their time/work. This involves the users being able to update their account with my site at most every minute, but typically users do it ...
4
votes
1answer
205 views

Checking for duplicate with encrypted values

I was hoping to get some advice on a particular task I'm trying to implement. I have a table that stores secure data and returns an ID as a representation of that data. No problems there. So, for ...
2
votes
2answers
288 views

creating nodejs apps in php/mysql framework with later on full step by step migration to nodejs in mind

I'm looking for the most efficient path to convert over time my own made php framework for nodejs and I believe that nodejs experts and specific developers who had their years working with apache/php/...
1
vote
1answer
180 views

Storing logs on mysql database

I was looking for more information on logging user actions on the application (web based project). I did found this question, but it's a more conceptual answer, wich helped me getting started with ...
7
votes
5answers
733 views

Database vs Flat files for rarely accessed data

We are receiving realtime data from over a 1000 sensors, each of which sends a data point every 10 seconds in average, which is amounting to about 1 million rows of data every day. Our system gives ...
0
votes
1answer
175 views

MySQL linter: Letting an installed python package Integrate with a user-written python module

I'm working on a new style of database migration system that is coming along nicely. There is one last aspect of it that I want to finish, which is to enable MySQL linting. For background, this is a ...
-1
votes
1answer
85 views

Saving sets into database fields [duplicate]

I'm working in a project (with Python, SQL, Javascript) where the devlopers before me have started saving sets into database fields. Example Here the field "audience" can have sets as content. Is ...
3
votes
2answers
94 views

How to Define Service Area – with Zip Codes?

I'm working on a site for at-home services. What is the best practice to define a service provider's service area? My initial thought was to define each provider’s service area as a set of zip codes. ...
0
votes
1answer
488 views

Best way to query immutable MySQL Data

I have been increasingly using immutable data storing for my web-app, due to some advantages it has (simpler writes, ability to view history / activity). I am doing it using MySQL dabatases, simply ...
0
votes
0answers
355 views

Database schema change tracking

We are currently using MySQL for our Back-end and what we do to track database changes on development that will eventually be applied to our production environment is done manually. By manual I mean ...
0
votes
1answer
240 views

Normalisation Vs Join , trade-off

In RDBMS, goals of Normalization: Free the database of modification anomalies Minimize re-design when extending Avoid bias toward any particular access pattern First step involves avoiding ...
-3
votes
2answers
133 views

How to deal with small frequent transactions

I have been given the task to create a system in which users can buy intellectual property (broadly categorized, hard to explain what they are really buying) from the system and can transfer funds ...
0
votes
1answer
165 views

Develop for MySQL and SQLite3 Concurrently

I am developing a javascript (Node.js) desktop program that works with an existing MySQL database. I would like to (eventually) distribute to others with based on SQLite, or MySQL if they need (or ...
0
votes
1answer
85 views

C# use same mysql databse with my website

The title pretty much says it all. I have a website hosted with ubuntu with mysql on it. Now I'm trying to figure out how can I use that same mysql with c# app. I have understood that mysql blocks ...
1
vote
1answer
328 views

Data modeling for NoSQL document database

Below are the common phases applied, for a real world requirement(data) map to DBMS specific schema. Conceptual models ER/EER/CODASYL/Hierarchical bridge the gap, in mapping the real world data(...
-1
votes
2answers
796 views

MySQL 5.7 json type or MongoDB document?

I'am working on a project that use MySQL as RDBMS. Recently, we have to manipulate a big json data. So, the first solution that comes in mind, and for many reasons, is to cooperate mongoDB with Mysql ...
2
votes
1answer
232 views

MySQL UUID storage/presentation

I'm looking at the way UUIDs are stored in MySQL. MySQL 8 still doesn't have a UUID data type, and it still doesn't have custom types, so there are two options - store it as a string or as a binary. ...