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

MySQL Client with settings across devices

Is there any MySQL client with which I can save settings (connection info, authentication, port etc) and it'll be available to usable by my other devices? For SSH I'm using Termius and I need software ...
1
vote
0answers
10 views

Overview of using Grafana for automated sql reports?

I have a couple types of databases (postgres, mysql) that I regularly run queries on and email the reports. I want a reporting dashboard to automate these tasks. I've heard Grafana is a good way to go,...
0
votes
0answers
9 views

PHP/Web-Frontend: Tools/Script to generate SQL reports

can someone recommend me a free framework / script which offers a webbased GUI frontend to build some SQL reports? E.g. I want to be able to be able to drag/drop tables and model the relations within ...
0
votes
1answer
57 views

Software for creating graphical applications for interacting with a MySQL Database

So I'm currently looking at modernizing our company's (<50 employees) database system, which is pretty archaic. The system uses Alpha Five, the database in question isn't even really relational, ...
0
votes
0answers
12 views

What DataBase is a better match?

I want to learn a Database and I'm looking for a database that has the best match with the programming languages that I use , That are C/C++ and Python . Personally I stuck between mySQL and ...
0
votes
0answers
28 views

LDAP proxy server that queries a MySQL database and return the data as LDAP result

I have an application storing its hashed and salted user data in a MySQL database. Users should get authenticated on other systems like XMPP with the same credentials. Since they're properly hashed ...
0
votes
1answer
30 views

Stand-alone Composer package for CRUD with PHP 8

For years, I've been making do with the outdated and ill-supported php-activerecord to do very simple insert and update operations for a tiny script that is for my own use and doesn't need to be a ...
1
vote
2answers
17 views

How to use MySQL cloud services (gratis)?

I am new to web development. My team is planning to create a dynamic website as a project. I want to have a relational database (MySQL) but all tutorials seem to use MySQL and PHP locally. We want to ...
0
votes
0answers
13 views

Forward Engineer to SQL Server?

Are there any software like MySQL Workbench, that allows Forwarding Engineering to SQL Server? Alternatively, considering that MySQL Workbench Forward Engineering generates the SQL script, is there a ...
0
votes
1answer
55 views

open source tool for SQL Queries

I program in SQL, however I am not someone who comes from IT. In my new job, we have to choose an open source tool for doing only queries (using SQL language), it means we are going to connect to some ...
1
vote
1answer
31 views

Self-Hosted Calender System for Scheduling Appointments based on Timeslots, similar to 'Calendly'

Is there a free, open source appointment scheduling-system similar to Calendly where I can predetermine timeslots for others to choose? And if one person selected a timeslot, then that timeslot is ...
0
votes
0answers
30 views

Create survey questions from a database query

The following diagram (hopefully) displays what I would like. Say I have a database of pupil-teacher information from a school, two tables: one with pupil-class; the other class-teacher. The first ...
0
votes
0answers
9 views

Java library or tool for simple loading from a database

I work on a simulation program that reads data from a number of tables in a MySQL database. The database is read-only, and usually the queries are just SELECT * FROM .... Up to this point, the program ...
1
vote
0answers
29 views

What is the best “all-in-one” REST API framework for MariaDB/MySQL to use with Vue/Nuxt.js frontend?

So I'm developing with Nuxt.js on frontend and I need to know what you think is the best REST API framework availible. For the moment I use REST API that I developed myself and call it with axios in ...
0
votes
1answer
49 views

SQL to Pyspark Conversion

Suppose you are given a .sql file containing 10,000 lines of SQL commands and you were told to convert them to PySpark. What software would you use? ...the task I want to accomplish: Somehow automate ...
2
votes
1answer
22 views

Remote Database and Table creation using MySQL and accessing information using the JAVA

I don't know if this question has been answered before but I could not find any answer so I am posting. If found duplicate I am really sorry and guide me to the original post. I am trying to learn how ...
0
votes
0answers
25 views

Database for student and progress attendance web application

In the project I want to do I will be requiring a database for the following: Store and access login details for Admin, Managers and Faculty. Store students and their information, i.e. Phone numbers, ...
1
vote
0answers
7 views

Library for creating MySQL queries from Java Script (other than Sequelize)?

Is there any good tool (library) to create MySQL queries from JS objects? I'm mainly interested in a low level tool, without instantialization and instance methods. Pure SQL output, but built ...
1
vote
0answers
7 views

Check integrity of MySQL database in app

I'm working on an app using Codeigniter(PHP) and MySql(5.7.24); Multiple independent clients have this app installed on their servers. When there is an update/bugfix, we have an update server we push ...
0
votes
0answers
19 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 ...
-1
votes
1answer
549 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 ...
2
votes
0answers
189 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
15 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
31 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
30 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 ...
1
vote
1answer
15 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
33 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
43 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
vote
2answers
1k 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?
1
vote
0answers
18 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
16 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 ...
-2
votes
1answer
14 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 (...
2
votes
1answer
62 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
14 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 ...
-1
votes
1answer
10 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 ...
1
vote
0answers
56 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 ...
-2
votes
1answer
23 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
1answer
15 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 ...
1
vote
0answers
14 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, ...
1
vote
0answers
32 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 ...
1
vote
0answers
8 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
29 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
475 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. ...
1
vote
3answers
38 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
44 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 ...
1
vote
2answers
42 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 ...
2
votes
1answer
137 views

MySQL server to receive an SQL query and convert to LDAP to query LDAP backend

The requirement is to receive an SQL query(over tcp) from a client(which is using a mysql client library - libmysqlclient.so.16.0.0) and then convert it to an LDAP request and send out to an LDAP ...
1
vote
0answers
22 views

What tools could I possibly use to make an Android app real-time while using MySQL as database?

I have already developed a website mainly using Laravel and MySQL for back-end. I have built an API using Lumen micro-framework, that is used for the communication between the Laravel app and the ...
0
votes
1answer
32 views

Nodejs ORM for MYSQL

The purpose to find recommendation for a node-js package to interact with mysql db which can achieve following objectives It should be highly documented Resolve maximum of MYSQL query handling in ...
1
vote
1answer
68 views

Choosing the right database management system?

I am writing a Telegram bot script which needs to store inputted user data. I have no real experience using database management systems such as SQLite, MySQl and Postgres. I don't need my application ...