Questions tagged [mysql]

If your question is explicitly for the MySQL database (server or client). Targeting "any" database, rather use the 'database' tag.

78 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
2k views

Severalnines Clustercontrol Alternative software?

I have been dealing with ClusterControl software to provision MySQL cluster and monitor and scale from last few weeks. But they are not really responsive I tried to reach them to get a quote but they ...
3
votes
0answers
825 views

Dashboard/visualization tool with ElasticSearch, MySQL and custom (REST?) data sources and intuitive filter tools

we have statistics from multiple sources and would need to display them at a central place. At the moment, we have some custom charts using PHP and ExtJS for things stored in a MySQL database, then ...
3
votes
0answers
50 views

Microsoft Access to MySQL Database Converter

I am working on creating a basic master-detail application using VB.NET and MySQL, because of this I've tried to look for a simple master-detail application using VB.NET in the internet and I found ...
3
votes
0answers
38 views

XLS to MySQL DB

I'm looking for software that can help me with that work... I have an XLS file that store table of about 16k data. Each column has to become a new table with indexed values and the main table which ...
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 ...
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 ...
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 ...
2
votes
3answers
865 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 ...
2
votes
2answers
455 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 ...
2
votes
1answer
492 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 ...
2
votes
0answers
54 views

Community Messaging Web Application

I run a small online volunteer community (~700 users) that organizes and manages community cleanup dates in my area. We are looking for a messaging platform we can roll into our existing website (as a ...
2
votes
0answers
31 views

Comparison/Review Website Software

I am looking for website software (preferably open source), written in either PHP or ASP.net, where users can login and review a certain place and compare it against others in the area. Does anyone ...
2
votes
0answers
193 views

MySQL replication or Microsoft Sync Framework

I'm developing a Windows Application (WPF) which works on multiple instances of the same MYSql database, and those databases need to be synced, I'm not sure which solution should I go for, MS Sync ...
2
votes
0answers
137 views

PHP versus Angular and Node for a simple read only reporting web app

Purpose / user story: My dev team is looking to build a read-only web app, to allow reporting on top of a MySQL database. There is no need for CRUD forms or any input. The DB layer and transform layer ...
2
votes
0answers
90 views

Ecommerce - live search, select, and bill

I need a php/mysql plugin for server side, and js/jquery / or what so ever for client side. My problem is: - users search product in the search bar - beneth the search box, the products will display ...
2
votes
0answers
26 views

Bulk email mailing software with the capability to write details back to MySQL database

We're looking at replacing our current software Arial Software's "Email Marketing Director" (now discontinued). Details: The database of email addresses and other details is stored in a MySQL ...
2
votes
0answers
190 views

What is a fine MySQL class for Python?

I am new to python,earlier I used to develop in PHP. With PHP, I used MySQL as the back end Database.There I had different libraries,MySQL classes with easy to use functions available open , also we ...
2
votes
0answers
63 views

phpMyAdmin or MySQL Workbrench simple alternative for learning

I am looking for a PHP application or a Windows application to manage a MySQL database. I want to help children in learning databases, but MySQL Workbench, phpMyAdmin are too hard for begining. I am ...
2
votes
0answers
32 views

Need a Campfire-quality integrated chat system for a large site

I'd like to integrate a chatroom product/service into a typical PHP web app with thousands of users. We need (ideally): Private rooms with unique URLs Can invite other users Users can access full ...
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,...
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 ...
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 ...
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 ...
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
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
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 ...
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
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 ...
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 ...
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 ...
1
vote
0answers
4 views

Tool to convert stored procedures from SQL Server to MySQL

I am already tried like a below tools for conversion Mysql workbench Dataloader (trial version) DRPU database converter (trial version) But, still i can't able to convert Stored procedures from sql ...
1
vote
0answers
10 views

MySQL client with ability to view images in columns

I have a column with a path to image files. At the moment I'm using HeidiSQL, but I would like to have a client that automatically loads an image file from a path.
1
vote
0answers
7 views

Database table editor for Wordpress

I'm a software developer who will be building some relatively simple, but very custom components for a Wordpress website. Each component will rely on data located in one or two database tables. I'm ...
1
vote
0answers
18 views

DB admin software that can block certain query

I need to know if there exists a database administration software for MySQL which have the following features 1. Can have multiple connections to multiple db servers 2. Then, I can block any kind of ...
1
vote
0answers
42 views

Mysql user management centralized

I search software for centralized MySQL user management on linux platfrom. I want to manage multiple MySQL server (MariaDB 10+) or only users (create,remove and privileges) in one place. At the ...
1
vote
0answers
53 views

ORM with Master - Slave Replication and Load Balancing

I have an e-commerce website (built upon Opencart), utilizing Master-Slave replication (1 Master and 2 Slave DB servers). For effective load balancing, people recommended us to use Maxscale. However, ...
1
vote
0answers
28 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 ...
1
vote
0answers
64 views

Vehicle Tracking with MySQL Database

I have a database of vehicle data and would like to view it on a live updating map. Does anyone have any free, simple web solutions that connect with mySQL? I'd like the software to be a live ...
1
vote
0answers
30 views

Visual editor for MySQL views?

Is it possible to visually (or just comfortably) edit MySQL views? I got dbForge Studio fo MySQL, but it is able to visually edit SQL files only, not stored views. Is there any app, which is capable ...
1
vote
0answers
36 views

embedded database for mysql workbench

I am looking for an embedded database but all of the administration tools out there are really shocking quality. I do like mysql workbench as an administration tool though so I was hoping that there ...
1
vote
0answers
54 views

Push data to apps from MySql

I just stumbled over RethinkDB and I like the sound of it: RethinkDB pushes JSON to your apps in realtime. When your app polls for data, it becomes slow, unscalable, and cumbersome to ...
1
vote
0answers
67 views

Linux backup software (use backup2l?)

Today I've set backing up most important files on my Debian Linux server with backup2l and a Google Drive client. But some files (MySQL dumps) are big and change often. This way I was unable to set ...
1
vote
0answers
47 views

Which database to use for tracking URL visits?

I'm building a SAAS webcrawler. I would like to store information which URL was crawled by the user. I'm expecting this table to grow initially by 5-10 MB/month, later maybe up to 40 MB/month. The ...
1
vote
0answers
121 views

Any better software alternative for mysqldump

mysqldump does not have some simple and really useful options. e.g. its not possible to dump only views, or is not possible to disable version-comments (/*!40101 /*). Is there any even a little better ...
1
vote
0answers
715 views

Looking for a MySQL Report Generator I can integrate into a web app

I'm looking for a program that will allow a user to create a report from selected fields and tables in a mySQL database. The users won't know SQL commands, so it would all have to be done through a ...