Skip to main content

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
0 answers
15 views

Performance test between MySQL and MongoDB

I am a beginner in the field of databases and I need to compare the performance between MySQL and MongoDB. For this, I will insert 1 million records and then perform a join. I will measure the ...
Valher7's user avatar
1 vote
0 answers
33 views

What solution can I use for edit SQL tables but with some patching of tables already done? like the SELECT JOIN

Hello I'm doing a side project based on mysql for the data part and php for the backend part of visualizing data, javascript and various libs for data representation and so on on the frontend. The ...
user3450548's user avatar
0 votes
0 answers
13 views

Looking for a solution to migrate excel app

I am searching for a php based solution to shift from old style excel app. Here are my requirements. Looking for a php driven paid / opensource solution, which provided similar interface like excel. ...
phpboy2020's user avatar
0 votes
2 answers
31 views

Database for having very long but simple tables

I am in need for a database that can store very long tables. E.g. MYTAB ----- name STRING date DATETIME mark INTEGER value DOUBLE "A.112.akizo", "2023-01-01 01:00", 0, 1234.54 &...
chris01's user avatar
  • 111
1 vote
1 answer
38 views

MySQL interface with copy/paste functionality and conditional formatting

I am looking for a MySQL UI with some spreadsheet-like features. We need: Copy & paste functionality Conditional formatting I have tested a lot of tools and have not found exactly what we need. ...
Alan Reed's user avatar
  • 113
0 votes
0 answers
10 views

How can I copy the recent copy of my database backup from the website to the development machine?

I finally have daily mysql backups working on my 3 shared servers hosting 6 websites. They are organized in folders such as backup\2022-08-20\ backup\2022-08-21\ where each folder has that days ...
Rohit Gupta's user avatar
  • 1,304
0 votes
0 answers
259 views

What is a good database tool for offline access?

I'm trying to find the right database service to use. I need multiple computers (1-5) to be able to access/write/read to the database simultaneously, locally (without internet access, via connecting ...
user16369266's user avatar
1 vote
0 answers
41 views

PHP/MySQL monitor tool/dashboard

So I have tried to Google around a lot, but I feel that the are so many tools out there and I don't find anything that is perfect what I'm after. So I'm currently building a system that has a lot of ...
zarex360's user avatar
  • 111
0 votes
1 answer
97 views

looking for alternative rdbms for oracle which is build by russian

can anyone suggest any alternative to DB2, Sybase, and Oracle? I knew that Teradata is a good alternative to these. But most oracle guys ridicule to this they still think Oracle is superior and more ...
CADENTIC's user avatar
1 vote
0 answers
14 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 ...
ahmetertem's user avatar
1 vote
0 answers
18 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,...
Trouble Bucket's user avatar
3 votes
2 answers
93 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, ...
lwb's user avatar
  • 31
0 votes
1 answer
265 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 ...
Keyslinger's user avatar
1 vote
2 answers
39 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 ...
Vasvi Sood's user avatar
0 votes
2 answers
160 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 ...
Vicky's user avatar
  • 1
1 vote
1 answer
220 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 ...
anpami's user avatar
  • 206
1 vote
0 answers
100 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 ...
Aline's user avatar
  • 11
0 votes
1 answer
3k 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 ...
Alex's user avatar
  • 113
3 votes
2 answers
35 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 ...
BATMAN_2008's user avatar
0 votes
0 answers
49 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, ...
Kwsswart's user avatar
  • 101
1 vote
0 answers
9 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 ...
Eggon's user avatar
  • 111
1 vote
0 answers
10 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 ...
Lohith's user avatar
  • 11
0 votes
0 answers
24 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 ...
Mawg's user avatar
  • 9,048
-1 votes
1 answer
2k 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 ...
J Arun Mani's user avatar
2 votes
0 answers
327 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 ...
Jaxidian's user avatar
  • 121
1 vote
0 answers
18 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 ...
Marvin Irwin's user avatar
-1 votes
1 answer
61 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 ...
prasad_21's user avatar
0 votes
0 answers
39 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 ...
user3110078's user avatar
1 vote
1 answer
22 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 ...
Jake Gylen's user avatar
1 vote
0 answers
95 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 ...
pakornpp's user avatar
1 vote
1 answer
164 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 ...
Saif Obeidat's user avatar
1 vote
2 answers
2k 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?
MatthewH's user avatar
1 vote
0 answers
33 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 ...
Bilal Abdeen's user avatar
1 vote
0 answers
40 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 ...
Juan Colmenero's user avatar
-2 votes
1 answer
21 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 (...
Dimitris's user avatar
3 votes
2 answers
82 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 ...
Çağlayan Karagözler's user avatar
1 vote
0 answers
26 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 ...
Sayed Uz Zaman's user avatar
-1 votes
1 answer
14 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 ...
hesham shawky's user avatar
1 vote
0 answers
102 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 ...
Django Newbie's user avatar
-2 votes
1 answer
36 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, ...
Hairsh Kuramsetty's user avatar
0 votes
1 answer
48 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 ...
Steven Day's user avatar
1 vote
0 answers
20 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, ...
Sanghamitra Lahiri's user avatar
1 vote
0 answers
36 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 ...
ahboy's user avatar
  • 11
1 vote
0 answers
19 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 ...
Pro Girl's user avatar
  • 111
0 votes
0 answers
68 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 ...
WhiteRose's user avatar
0 votes
1 answer
665 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. ...
Nicole's user avatar
  • 3
1 vote
3 answers
47 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 ...
Stephen McAteer's user avatar
0 votes
1 answer
60 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 ...
Chidiebere Onwunyirigbo's user avatar
1 vote
2 answers
58 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 ...
joker13's user avatar
  • 11
2 votes
1 answer
291 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 ...
Pavani Chirala's user avatar