Questions tagged [mysql]
If your question is explicitly for the MySQL database (server or client). Targeting "any" database, rather use the 'database' tag.
162
questions
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
&...
- 111
1
vote
1
answer
32
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.
...
- 113
0
votes
0
answers
8
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 ...
- 1,033
0
votes
0
answers
34
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
31
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 ...
- 111
0
votes
1
answer
79
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 ...
- 7
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
0
answers
16
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,...
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, ...
- 11
0
votes
1
answer
234
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 ...
- 113
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 ...
- 13
0
votes
2
answers
96
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
1
vote
1
answer
155
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 ...
- 206
1
vote
0
answers
88
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
1k
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 ...
- 113
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 ...
- 101
0
votes
0
answers
42
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, ...
- 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 ...
- 111
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
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 ...
- 101
2
votes
0
answers
293
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 ...
- 121
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
39
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 ...
- 58
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 ...
1
vote
1
answer
20
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 ...
- 13
1
vote
0
answers
82
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 ...
- 11
1
vote
0
answers
107
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 ...
- 11
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?
- 11
1
vote
0
answers
32
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 ...
- 111
1
vote
0
answers
27
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
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 (...
- 1
3
votes
2
answers
79
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
0
answers
23
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 ...
- 111
-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 ...
- 101
1
vote
0
answers
88
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
1
answer
34
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
1
answer
34
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
0
answers
19
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
0
answers
35
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 ...
- 11
1
vote
0
answers
14
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 ...
- 111
0
votes
0
answers
48
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
1
answer
650
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.
...
- 3
1
vote
3
answers
45
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
1
answer
55
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
2
answers
49
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 ...
- 11
2
votes
1
answer
262
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
0
answers
24
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 ...
- 11
0
votes
1
answer
33
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
1
answer
82
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 ...
- 19