Skip to main content

Questions tagged [mysql]

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

39 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
0 answers
263 views

How to let users specify their own logical conditions (PHP / Laravel)

I am currently trying to create a web application, that saves inbound emails. I have figured out how to save the incoming emails into my database, and I have all the email information available (...
oliverbj's user avatar
3 votes
0 answers
421 views

Dynamic API Data Validation

I am in the process of building an heavily data-driven web application written in Node.js / Typescript with Mariadb for the database engine. I am trying to put an emphasis on extensibility and DRY ...
Antonyjim's user avatar
3 votes
0 answers
2k 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 ...
Vikas's user avatar
  • 163
3 votes
0 answers
664 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 ...
Gravy's user avatar
  • 1,057
2 votes
0 answers
58 views

Scaling Order Management System for ecommerce

Tech Stack: I am using MySQL 8 with InnoDB engine. Application is built using Java with Spring & Hibernate. Database is hosted in AWS RDS and web apps in EC2. I have two primary tables for ...
Abhinav's user avatar
  • 259
1 vote
0 answers
116 views

Backend Design: System requires both ElasticSearch and MySQL. In which scenario we fetch data from MySQL or ElasticSearch?

So, one of the backend system, having 5 resource types (tables) and some foreign keys as well, requires full text support for two of the tables. Also, for some use-cases, we require inner-joins for ...
Bugs Buggy's user avatar
1 vote
0 answers
430 views

Design MySQL database to store user workout data for Workout App

I am building a fitness app and I'm trying to figure out the optimal way to store the data is a MySQL database. I would like to have specific programs (for example, 'get jacked'), I would like a users ...
adherb's user avatar
  • 121
1 vote
0 answers
53 views

Best way to integrate google signin in existing user registration system with PHP/MYSQL [Logic]

I want to integrate google signin, in our existing user registration system. But not sure which approach will be good in terms of data security + user experience (UX) + speed. Even if its a good idea ...
mimi's user avatar
  • 111
1 vote
0 answers
203 views

Should I decouple MySQL database?

I have two sites, one is a subdomain of the other. They both do different things entirely with one unifying goal. My intent is to have the main site do a majority of the heavy lifting, and the ...
shiafisher's user avatar
1 vote
0 answers
62 views

PHP MySQL Secure Connection - Same Server

I have some php scripts that use mysqli() to connect to MySQL which is located on the same server. I currently have the connection stored outside of my sites root and I am using include() to make the ...
FamousAv8er's user avatar
1 vote
0 answers
63 views

Efficient structure for storing/handling lots of datasets

I am looking to develop a piece of software which will probably store hundred of thousands or even millions of datasets with 3 to 5 datasets to look up per ID. Is there any way to build something ...
flomei's user avatar
  • 119
1 vote
0 answers
39 views

Cascade reference date through full query

I have created a complex query that references a specific date (year and month to report on) on numerous parts of the script. What would be the best artifact to have to only change 1 line of code and ...
nbayly's user avatar
  • 123
1 vote
0 answers
34 views

How to handle the set of objects that represents a context?

How can I handle the situation when exists the context that represents a collection of arbitrary objects? This context can be created by code like this: $context = new Context(); $context->add(...
Eugene's user avatar
  • 11
1 vote
0 answers
300 views

Compiling data from multiple API sources, multiple languages, into a single database (MySQL or Mongo)

I'm thinking about a database schema, and would really appreciate if some of you could look at where I'm up to and offer some advice.. The mission - We have to write a program that will fetch data ...
Martyn's user avatar
  • 795
1 vote
0 answers
5k 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 ...
kang's user avatar
  • 61
1 vote
0 answers
40 views

how to reduce or stop duplication of relation's entry in treeview

I want to create tree-view for display or show family member's relation. For this I created 3 tables i.e following. familyDetails->[f_id,fname,lname] relations -> [r_id,relation] .....//e.g ...
Kreya's user avatar
  • 111
0 votes
0 answers
141 views

Fill Docker Container from existing remote database

I do have n nodes managed by Kubernetes, all of them running several containers. A container may contain a database alongside with an application. As containers should be stateless, all data within ...
Bin4ry's user avatar
  • 101
0 votes
0 answers
54 views

What is best approach to designing a local-to-cloud cloud-to-local Infrastructure?

I plan to have a cloud web application(CWA) and several local web application(LWA), let's assume 3 LWAs and 1 CWA. CWA === LWA. This web application would consist of a database server, file storage ...
Olamide226's user avatar
0 votes
0 answers
122 views

DataBase Design for frequent delete operations

We have a use case wherein we want to store incoming data and invalidate all the previously existing data pertaining to one parent entity. ie Parent p1 --> has List< child> old_data ( already ...
vipulk10's user avatar
0 votes
0 answers
50 views

Drag and drop and handling huge amount of documents to update position

I'm having a series of data as documents in a document db (CouchDB) Sample of a document looks like below { _id: xxx _rev: xxx data: xxx position: 1 } These documents displays in a web front-end ...
inckka's user avatar
  • 129
0 votes
0 answers
48 views

Architecture to check for user properties in bulk?

We run an infrastructure in our organization, where a list of configs are provided and we check which config a given user satisfies. For eg: config_1 = {"a": 1, "b": 2, "c": 3} config_2 = {"a": 1, "b"...
user2077935's user avatar
0 votes
0 answers
513 views

BCMath vs MySQL: performance

Scenario I am working on a web application that handles financial transactions, and my code will need to be reusable for everything from consumer carts to manufacturer/distributor shipments. The ...
Jonathan Voss's user avatar
0 votes
0 answers
121 views

Advice on paging tree structured data

I'm in the process of building web based a commenting system, for which the comments are rendered in a reddit / disqus style tree structure. The MySQL schema uses a string of ancestor id's, and the ...
gbro3n's user avatar
  • 491
0 votes
0 answers
816 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 ...
Broco's user avatar
  • 81
0 votes
0 answers
56 views

MySQL left join + performance

SELECT * #Case 1 cp.* #Case 2 FROM crawl_page AS cp LEFT JOIN artist AS a ON cp.cpURL LIKE CONCAT('%',a.artistPageID,'/',a.artistPageURL,'%') ...
George G's user avatar
  • 133
0 votes
1 answer
274 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 ...
Gerardo Charles Rojas Vega's user avatar
-1 votes
1 answer
147 views

Best practices for creating structured data from "flat" SQL query results

Recently I've been working on a project to teach myself PHP and SQL, and as the project has gotten more complex I've been wondering what the idiomatic approaches are for creating the backend models ...
Jumhyn's user avatar
  • 162
-1 votes
3 answers
82 views

Architecture to show the number of results within the filter

I am building a web application connected to MySQL database that is supposed to work like an e-shop. User should be able to filter products, but I want to display the number of results that would be ...
P. Paul's user avatar
  • 101
-1 votes
1 answer
211 views

Database abstraction layer

I'm currently developing an SaaS application in PHP, with Laravel, using its own DB class. Let's pretend we've got 2 classes under 2 namespaces, plus Laravel's own DB - so Illuminate\Support\Facades\...
XLR's user avatar
  • 111
-1 votes
3 answers
623 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, ...
T Jagadish Gupta's user avatar
-1 votes
1 answer
51 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 ...
QuantiumTech's user avatar
-1 votes
1 answer
1k views

Migrating MYSQL functions and stored procedures to SQL Server

The company i'm working for is selling HRIS management software. It was built using ASP and mysql. But one of our client's demand is for it to be based on MS SQL Server. our team is made up mostly of ...
Larry Solis's user avatar
-1 votes
2 answers
186 views

How to fit requirements into MVC

Let's say we have a website requirement to allow User functionality. Simple! We create the UserModel, UserController and UserView. Works perfectly. However, let's assume that User has a many-to-one ...
user avatar
-1 votes
1 answer
134 views

Is it ok to fire database queries again and again?

I am preparing a Java project and working on MySQL database. Currently I am stuck at a point where I want size of the resultset before I can actually fetch entries from it. The fetching of size is ...
shashank's user avatar
-2 votes
2 answers
647 views

What's better, using DB or Storage services to save videos?

I am creating a website that allows to teachers to uploading courses, what's better, to just use the DB or should I use storage services, and how could I know the size of the videos? I am using AWS if ...
Elzubair Mohammed's user avatar
-2 votes
1 answer
105 views

How can I transfer a users information in a dashboard page after he/she logs in?

I am developing a Bank Management Project. Now I am stuck in a point. I want to create a login page where a user will submit his/her username and password then after clicks on the login button, a new ...
Shahparan Rifat's user avatar
-2 votes
1 answer
120 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 ...
Dan's user avatar
  • 109
-2 votes
1 answer
408 views

Which Software Architecture am I using? XAMPP, Apache, MySQL, PHP Android

I use XAMPP to host an Apache web server and a MySQL database. Most of the data processing is done on the user's mobile phone. After a certain activity, information of the user is sent to the web ...
santa's user avatar
  • 1
-3 votes
2 answers
175 views

Does DigitalOcean offer enough resources to run a scalable MySQL cluster?

I have a Kubernetes instance from DigitalOcean that has 2 worker nodes and 1 load balancer. Now I want to create a MySQL managed database cluster for the app that will run on that Kubernetes. Question ...
emma's user avatar
  • 133