Questions tagged [mysql]
If your question is explicitly for the MySQL database (server or client). Targeting "any" database, rather use the 'database' tag.
164
questions
0
votes
0
answers
20
views
Adding a Spring Boot API between JavaFX Application and MySQL Database: Pros and Cons? [closed]
I have JavaFX appliciton witch connects directly to a mysql database it accomplish basic crud operation. Is it a good idea to insert spring boot wep api between the database and the application? What ...
- 1
2
votes
1
answer
534
views
Angular + Node + MySQL : Reporting + Forms + Authentication
I am trying to make an in-house simple solution with Node/Angular/MySQL stack where the users are expected to enter data through 4-5 different type of forms, the entered data needs to be reported on a ...
CommunityBot
- 1
2
votes
1
answer
696
views
Open source 3D asset management (PHP/MySQL/HTML5)
I am looking for an asset management system which:
I could run on our PHP/MySQL server.
Could store files in a tree directory structure.
Could either preview 3D file formats or would allow to add a ...
CommunityBot
- 1
0
votes
0
answers
11
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. ...
0
votes
3
answers
160
views
Free C/C++ IDE & compiler to create command line Mysql access program
I just need to code a short command line program to run a SELECT and convert the result to CSV, so am open to any free IDE/Compiler solution for Windows 10.
I tried MS Visual Studio and the official ...
CommunityBot
- 1
1
vote
1
answer
128
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 ...
2
votes
2
answers
588
views
Extract text from uploaded pdf and store it in a database
I have an HTML form where a user can upload a PDF.
I want to extract the whole text from the PDF, search in it for specific words and then store them in my database. Any ideas?
I don't ask you for the ...
CommunityBot
- 1
1
vote
2
answers
83
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, ...
CommunityBot
- 1
3
votes
2
answers
33
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 ...
CommunityBot
- 1
3
votes
2
answers
5k
views
Free options to MySQL Query Analyzer
Basically, I'm looking for a free option to MySQL Query Analyzer.
I need a tool that can log all queries and analyze the performance of those queries (time, memory, affected rows, errors and things ...
0
votes
1
answer
198
views
Software to create a database structure from a batch of XSD files
In my work we're now generating a database from a lot of XSD (50-100) for generating reports. This is a constriction imposed by the ministery, so there's nothing we can do. So the problem I'm having ...
CommunityBot
- 1
1
vote
1
answer
183
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 ...
CommunityBot
- 1
1
vote
0
answers
37
views
Free Database ERD Creator
I am looking for a free option that I can use to design my databases. The following features are a must:
Needs to be free or under $100
Able to generate SQL statements to generate the completed ...
CommunityBot
- 1
22
votes
5
answers
21k
views
Tool to Visualize SQL Database Schema for Linux/Windows
Please recommend a tool to visualize database schema.
It should be able to generate schema of existing DB.
support - mySQL platform - Linux/Windows licence - free/open-source
Something like ...
- 113
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
&...
- 2,754
1
vote
1
answer
33
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.
...
CommunityBot
- 1
8
votes
5
answers
7k
views
OS X MySQL client?
I'd like to have a nice GUI for MySQL on OS X. The app must:
Support connecting to external databases
Support tunneling over SSH
Show a nice GUI for editing and creating table schema
Give access to a ...
3
votes
3
answers
2k
views
Is there any database which can be accessed offline without internet connection?
we need to design web and mobile app solution for a client.
the requirements are following
Application with offline capabilities, that will sync with cloud when you reconnect to the internet, but the ...
CommunityBot
- 1
0
votes
0
answers
9
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 ...
- 6,716
0
votes
2
answers
120
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 ...
0
votes
0
answers
49
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 ...
1
vote
0
answers
84
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
0
answers
34
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 ...
- 2,007
0
votes
1
answer
81
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 ...
3
votes
2
answers
81
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 ...
- 101
0
votes
0
answers
48
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
3
votes
3
answers
2k
views
MySQL Workbench equivalent with possibility of two-factor authentication
I'm trying to access a remote database using MySQL Workbench, but the server has a two-factor authentication and, apparently, Workbench does not have this feature.
So, I'm looking for a GUI MySQL ...
- 121
0
votes
1
answer
244
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 ...
- 26
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 ...
- 111
1
vote
2
answers
30
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 ...
- 6,716
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,...
- 111
17
votes
3
answers
16k
views
MySQL client for iOS?
I'd like to be able to manage my MySQL databases from my iPad. I currently use Sequel Pro on my Mac, and I love it.
The app must
Support connecting to remote databases
Support tunneling over SSH
...
- 1
1
vote
0
answers
75
views
A better MySql console for Windows
Actually, I am only looking for a single feature:
I would like to emulate the Bash shell's Ctrl-r in a MySql console.
That is to say, I type the first few characters of a previously issued command and ...
0
votes
1
answer
77
views
Alternatives for MySQL Workbench
What are the alternatives for MySQL Workbench on MacOS?
Because in the MacOS version of Workbench, you cannot forward engineer with the 'insert' queries unlike its windows version.
- 6,716
1
vote
2
answers
23
views
Current RDBMS options in the cloud
We currently have a MySQL installation that, because "it just works" has not been given the attention that it should have been. As such it is now running an unsupported version.
As moving to a ...
- 3,148
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?
- 21
1
vote
0
answers
91
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 ...
- 11
0
votes
1
answer
35
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 ...
CommunityBot
- 1
0
votes
1
answer
2k
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 ...
- 422
0
votes
1
answer
354
views
Portable convert excel to mysql
Is there a portable windows (xp and above) software that can convert a excel file (xlsx, xls and ods) into mysql file (sql)?
- 6,716
2
votes
0
answers
302
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
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 ...
- 111
1
vote
2
answers
45
views
Visual SQL Builder that includes ability to update data
I do not know SQL and need to create a script that will update data in our database. I know there is software and services out there that provide a drag & drop interface that build sql queries to ...
CommunityBot
- 1
1
vote
0
answers
9
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 ...
- 11
0
votes
3
answers
175
views
CSV to SQL Insert Statement Software
I am looking for software to assist me in the process of converting CSV files into insert statements for MySQL. The software would ideally have the following characteristics:
Be able to convert a ...
- 51
0
votes
3
answers
124
views
Gratis MySQL visual query builder
I am looking for a gratis Windows program to connect to a database and allow non-techie users to easily, visually, build queries.
[Update] I think that I didn't make it clear - these tables & ...
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 ...
-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 ...
- 656
1
vote
0
answers
16
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 ...
- 111
-1
votes
1
answer
43
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 ...
- 186