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
-1
votes
0answers
3 views

Setting up a JDBC Driver on Visual Studio Code

My goal is to use a JDBC in order to program some databases using Java and MySQl. I am quite new to programming and I have thus far generally used Visual Studio Code to produce most programs. It's ...
1
vote
0answers
7 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 ...
-1
votes
0answers
7 views

Equipment management system

I am currently interning at an engineering firm, and as a peripheral task, I was asked to come out with an Equipment management systems. This system has to be able to track which equipment has been ...
-1
votes
0answers
4 views

Database solution for read scale with HA

We are planning for an internal social network for our company with Node and React. For database we are considering multiple options like Redis, PostgreSQL, MySQL and MongoDB. Our assumption is 90% ...
0
votes
1answer
9 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
11 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
12 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
15 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
9 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
8 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
19 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
24 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. ...
0
votes
0answers
8 views

Best database for embedded application

I'm developing a nodejs api server for a single board computer with 2 GB ram and 16 GB SD card (ODROID-HC2). The OS is Ubuntu Linux. I need a database mainly for admin purposes. Data collected from ...
0
votes
0answers
14 views

Is there any Node.js package that would allow me to mock MySql connection in order to test APIs that need db connection?

I want to do unit testing of a few APIs written by myself, which make some queries on a MySQL database. But I learned recently that establishing an actual connection during testing is not a good ...
0
votes
0answers
9 views

Summer project in javascript?

I would like to start a summer learning project, but I need some advice! I have knowledge in php and mysql, and thinking it might be some javascript that I should do my project in, but is open to ...
1
vote
3answers
30 views

Online IDE or Code Editor for PHP?

I'm a coding beginner. I'm trying to learn to code PHP and MySQL. Can someone recommend an online development tool for PHP? Requirements: Should be easy for a beginner to use / set up. I would ...
0
votes
1answer
28 views

What Technology is recommended to build a Resume Builder?

Good day, I am about to embark on a project of building a resume builder. The builder will be interactive as it will make suggestions for the end user. I want it to be fast. I have considered using ...
0
votes
0answers
6 views

How to connect pre-exising react app with php and my SQL - Beginner's Approach

Just to provide a quick background, i don't have any knowledge about using php as a server-side script with react app on the front-end. I don't know what goes into installing and configuring php so ...
0
votes
0answers
8 views

sublime text for php

I think Sublime Text is becoming more and more nice to work with, I have been using it for sometime now creating php, html, css, js and more scripts. I would like to know though is there any plugin I ...
0
votes
0answers
9 views

What is the best low-code tool for building a UI for inventory management?

I'd like to find a low-code UI solution to allow my e-commerce & data enrichment teams to perform CRUD operations and insert and update changes to a MySQL database. I've looked into Google App ...
0
votes
0answers
2 views

Tag questions of survey in Warehouse

I have a survey with 10 questions. 50 Persons have completed the survey, so I have table with 500rows in my table XXX. Issue: I have one column in table XXX that is the question. So 500 columns where ...
0
votes
0answers
9 views

Database Recommendation for Internal PGP Keyserver Application

My goal is to create a database that maps PGP keys to users for an internal security system. I would like to have two "tables" user info (UID, Name, Email, Title, Position) and PGP key info (Pub Key, ...
0
votes
0answers
8 views

School record system with JavaScript

So, I have just finished learning the basics of Javascript and was looking for a project. I decided on making an app for my school which manages the data of students. I plan to make in a server based ...
1
vote
2answers
28 views

What software can I use to Edit PDF online?

I have already built a database and using php I can edit,delete etc... from the database. I need an app which I can integrate in my app to edit pdf. I should be in such a way that when I click on the ...