Questions tagged [mysql]

If your question is explicitly for the MySQL database (server or client). Targeting "any" database, rather use the 'database' tag.

Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

Relational Database and query interface with seeding and migration for Nodejs. Having 'n' no of DB's with dynamic db connection during every api calls

Statement : Here i am working based on Multi-Tenant Architecture. so every client organisations need to have their own Databases and they are relational. so, in my case i need to work with " 'n' no ...
0
votes
0answers
15 views

Gratis MySql optimizer

I have gotten by until now with ensuing 3rd order norm and having good indexes & foreign keys. Today an AJAX query is exceeding 30 seconds on a modest search (PHP builds JSON arrays for each ...
0
votes
0answers
16 views

Rental Tools Management PHP&Mysql

i am searching a web application ( preferable in php ) to manage my rental tools . let me explain you : My company rents a lot of tools ( a list like 100/300 rows/articles ) to other companies , but i ...
0
votes
0answers
7 views

Markdown editor to database field

I have not seen a Markdown editor that saves the data to a database. I use Windows 10 Should save and load to and from a mysql database field My requirements are not high because there seems to be no ...
-1
votes
1answer
17 views

How can I check if my SQL query is right without executing it?

Its similar to https://stackoverflow.com/questions/377883/how-to-check-if-mysql-query-is-valid-without-executing-it But its for Go and I want a solution in Python. It will be better if there is a ...
0
votes
0answers
10 views

Draw a diagram of MySql data (NOT the database schema, the actual data, with relationships)

I have a specific case in mind, and could code it with Python and GraphViz, but first I would prefer not to reinvent the wheel & also to see if there is a generic tool out there that would help ...
1
vote
0answers
110 views

Index Analysis and Tuning tool for PostgreSQL, MySQL, and Oracle?

I have used SentryOne Plan Explorer to perform index tuning and index analysis with great success on SQL Server and Azure SQL Database. What are some of the better equivalent tools to consider for ...
1
vote
0answers
12 views

Is there a MySQL versioning and migration which supports users, or only users?

Is there a way to Declaratively manage your Users and permissions in MySQL >= 5.7? I would like to specify my structure and have it generate the necessary SQL to alter it to that state. As far as I ...
-1
votes
1answer
29 views

Should I learn MySQL and SQL server together for learning SQL? [closed]

I am starting to learn SQL so I was wondering which RDBMS should I use, i.e. MySQL or SQL Server, so I can also mention that tool in my resume to give good impression to get a job here in India. So ...
0
votes
0answers
12 views

Application for MySQL database comparison and merge

I am looking for a tool that allows me to compare 2 different databases in terms of structure and data. I can have both databases running locally in my machine, so remote analysis is not needed. I ...
0
votes
0answers
26 views

Which db should I use for a small project?

I`ve created a small project about a dentist. It is built with ASP and for my db I`m using MS Access. I think that he will add more or less about 1000-1500 records per year. My fear is that there ...
0
votes
0answers
4 views

Recommended GUI + SQL Libraries for Python + SQL Web Application

I am currently looking into creating a web application using Python and SQL language that will allow users to access/alter database contents. The users will not be tech savvy, so I would like their to ...
1
vote
1answer
13 views

What tools should I use to create a user-form to create SQL queries and interact with my database imported on myphpadmin?

I am new to databases. I imported a large database using phpmyadmin and it has a FieldA which is a field consisting of grades. Now what I want to do is have an HTMl form, which takes two inputs min ...
1
vote
0answers
19 views

What is the Cheap and Best Online Database for Android application used by 200k daily users?

I am student developer who is working on building an Educational Video App with roughly 200k users from scratch.I am currently using Firebase Realtime Database.The data stored is around 2MB But I ...
0
votes
0answers
5 views

Server for android backend logic

I am creating android app, for which i will use MySQL to store data. I didn't wanted to use firebase, it's pricey, and my app will store big data (app is for worldwide use, so it will consume very ...
1
vote
0answers
8 views

How to structure bus timetable database be used for a public transport app? And what is the recommended approach? noSQL, SQL, API?

I'm very new to cloud data management and to be honest, I don't even know where to start looking! So please be patient if I get some terminologies wrong. I am working on a flutter app that the users ...
1
vote
0answers
8 views

How to handle or execute large SQL script (5gb) in Mysql workbench

I have received a large SQL script from another company in order to migrate it, it's around 5GB, It was very difficult to open that script on MySql workbench because it keeps hanging when I import the ...
0
votes
1answer
35 views

is there a Mysql adapter for DBT?

I am looking for a mysql/mariadb adapter for dbt (https://www.getdbt.com/). I am guessing at least a partial one exists somewhere, but I have not been able to find it. Any leads?
0
votes
0answers
4 views

Suggestions for software on updating PHP mysql to mysqli automatically

I'm updating my code from PHP 5.6 to 7.3 and in the process need to update all of my MySQL code to MySQLi. There are a few tools I've found to automate the process such as https://github.com/philip/...
0
votes
0answers
9 views

Synchronise/Synchronize MySQL with Mobile JSON/Javascript Objects

I am building a mobile app (using React-Native and Redux). The data (on the client/mobile) are in Javascript Objects, which can be easily changed to JSON. Although the client data (on the mobile ...
1
vote
0answers
13 views

Android Push Notification for MySQL and PHP

I've done research these past 3 days on how to possibly be notified in realtime for mysql. The issue is MySQL doesn't have that feature available so you have to result to other options like: Migrate ...
0
votes
0answers
13 views

Key difference between SQL Server 2016 and MySQL

My company is in the midst of an IT overhaul and considering a shift away from MS SQL Server (2016 Standard) to a MySQL database. I have used MS SQL Server for years, so I am apprehensive to make ...
0
votes
0answers
185 views

View Count Simple Tool

Recently I was considering logging Apache data directly into MySQL and let it aggregate. However, several forum members were against and advised to use ELK Stack instead. Unfortunately, after some ...
-2
votes
1answer
13 views

Install MySql in a second PC for JS practicing

I am new to JS and i would like to start playing around with JS and databases. First of all i think that the first step i should take is to install MySql (correct me if i am wrong).I have a second PC (...
0
votes
0answers
5 views

What schedular library in Java for jobs that query the MySQL db?

Please suggest me a job scheduler library, in Java. This will be used to write jobs with Cron triggers, that will query MySQL DB for around 150k entries, and do some manipulation on the data and store ...
2
votes
1answer
36 views

Easy Windows GUI to edit content of MySQL tables (must be much simpler than Workbench/etc)

Looking for a recommendation on a MySQL DB manager with easy and slick UI. It needs to be able to handle direct queries, visually edit tables and databases mostly with mouse clicks. Kinda looking for ...
1
vote
0answers
9 views

Tool to archive old data from MySQL database, without losing the relation

I have a MySQL database that is rapidly increasing. This database contains all transactional data. I need to archive the database and move the two years old data into the archive so that the ...
0
votes
0answers
6 views

Simple Python Web App to Display Result Sets from Different SQL and MySQL DB w/ Multi Connections

I have system metrics stored in SQL and MySQL tables on a few different connections. I want to display these as a helpful Systems Monitor UI for those on the network that they can access through their ...
0
votes
0answers
7 views

Sever host for simple PHP mysql dynamic website

I've been working on my first serious web project for about 6 months now - the time has now come to deploy it. I am a complete noob and this is new territory but equally this site is very important so ...
-1
votes
1answer
9 views

What Database type should I use for a scraped data comes from many websites?

I'm building a REST API using NodeJS storing a scraped data that comes from many websites ( the API I'm building is about selling - buying used cars ) There's a potential to scale in the future ...
0
votes
0answers
9 views

Which environment to use for SQL

I'm not quite sure how to google this question, as I keep getting mixed results. I have a set of data I want to work with. I have a function that pulls the correct data that uses MySQL 5.7 (I ...
0
votes
0answers
23 views

MySql partitioning

I am trying to partition by a column named "type" in my table called "camps". I only have 4 types of values inside the "type" column. These are "article, page, comment, category". I would like to have ...
1
vote
0answers
21 views

Free External Django Barcode Scanner

I'm looking for a free barcode reader to integrate with my Django database project and MySql. I was looking at Zbar barcode reader but i don't really know how to implement them to connect to my ...
-1
votes
1answer
16 views

firebase or MySQL database?

We are developing one prestigious product. Can anyone tell me which one is best to use for the backend? firebase or MySQL database/Some OtherDb? This app has features like. Users, profiles management, ...
0
votes
0answers
3 views

MySQL database, with python, with GUI — What host/software should be used?

For a very high-storage project (up to 2TB), I need to make a database (mySQL). Want to make it with python, and eventually add a GUI to the database… what software should I use, what webhost should I ...
0
votes
1answer
11 views

Good freeware ETL tools to move data from one MySQL server to another MySQL server?

I have some business processes I run that require pulling and comparing data from two different MySQL servers, which, by virtue of being MySQL, are unable to talk to each other. Currently this is done ...
0
votes
0answers
11 views

Tools to test JPA/Hibernate queries

Currently, I've been using Dbeaver to test my queries before actually writing the real code. But it is only suitable for native queries. "SELECT COUNT(p.id) FROM profile p WHERE p.name =:name AND p....
1
vote
0answers
12 views

Create a standalone GUI application compatible with windows 7

I want to create a standalone GUI application compatible with windows 7 and through which pre-created database accession will be easier. I know to create these kind of application VB.NET is used, ...
0
votes
0answers
9 views

Truck logging and caller web application

I'm looking for a web application with these functions: Truck arrives to the warehouse, the reception add the informations from the truck (when, where from, license number etc.) The warehouse workers ...
1
vote
0answers
21 views

Fastest tool/library to read 40k small JSON files data from S3 folder and load them into MySQL database

I have a S3 folder with 40k++ json file where each of the file has the following format: [{"AAA": "XXXX", "BBB": "XXXX", "CCC": "XXXX"}] Tried to read each json files through boto3 with something ...
0
votes
0answers
9 views

best software to store and retrieve information on books for both web and desktop/mobile apps

I have been looking for a while but can't seem to find something that fits my needs. A basic rundown of what I am looking for is a software/api that will allow me to store and retrieve information ...
0
votes
0answers
5 views

Launching python3 scripts from php

Recently I was tasked with developing a data analysis dashboard. Now that I'm nearing completion of this project I have run across one annoying issue that I'm struggling to solve. In particular all of ...
0
votes
0answers
6 views

Best Free SQL Program to Upload Excel CSV file

I am looking for a free program that works with Mac and is able to upload an Excel CSV file. The reason for this request is because I have an interview and the company gave me an assignment to write ...
0
votes
0answers
11 views

Recommendations for an ELT tool for Workflow Automation

i get raw data quarterly. Essentially they are dumps from relational database tables. I import them into mysql bounce them against a reference database to get some validated columns then export the ...
0
votes
0answers
10 views

Fetching Words from php database tables and award weights

Could someone recommend to me software that can fetch words from different tables and assign a number/weight depending on the table that the word is coming from. For example if the word is coming from ...
0
votes
0answers
12 views

MySQL Community Edition - User/Connection count restrictions

Can I use mysql community edition for my application where there would be 1000+ hits (number of users or number of concurrent connections). Is there any legal / license restrictions? Following I have ...
0
votes
0answers
7 views

Free online database recommendation when upload mobile application to Google Playstore

Could anyone of you please recommend me any free server that can host my mobile application? as I wish to build a mobile application and upload it to Google Playstore. Excuse for a total newbie ...
1
vote
0answers
7 views

Database reccomendation for retrival of data (strings, int and float) with python

I'm looking for recommendation for the following: I currently have approximately 10 Million csv file each with the following identical data structure as file attached: I want to transfer all this ...
0
votes
0answers
20 views

Software to create a user-friendly web UI to view and insert data into MySQL database

I have been using phpmyadmin on WAMPserver to manage MYSQL database. However I wish to create another interface where my other users can access the database to INSERT and SELECT data only.(I know this ...
0
votes
1answer
76 views

Cross-Platform mobile app development tool to connect to remote mysql database

I am working on a native PHP website with a very bad architecture and with no web services to use. The owner needs a mobile app to communicate with his website and fetch some data from the database. ...