Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql]

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

0
votes
0answers
16 views

Recommended technology for desinging online test platform for 5000 concurrent users [on hold]

we want to design a web base software to take tests we would have 80.000 registered users and 5000 of them will take the exam at the same time it might have pictures in them so what framework(...
0
votes
0answers
9 views

Lightweight beautifully-designed MySQL GUI for windows?

I'm searching for a MySQL GUI tool which has a beautifully-designed GUI. I need something like Sequel Pro on mac
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
1answer
16 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 ...
0
votes
0answers
9 views

Easy responsive GUI for php and mysql code

I have a website using php ( jquery, datatables etc.) with a mysql back end. The users would like to be able to change the themes, images , positions etc on the pages. I know you can embed php inside ...
1
vote
2answers
13 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 ...
0
votes
0answers
6 views

Relational or Graph-based Database for certain use case?

I would be glad if you could advice me the right database-technology for my problem: I want to store a bigger amount of objects (>5 mio.). These objects belong to different types (approx. 2000 ...
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 ...
0
votes
0answers
9 views

MySQL + Airtable

Phpmyadmin When editing fields in Phpmyadmin it looks like below: It's not a very fun way to edit the data. You need to click into each row to edit so the overview is lost when editing the data. You ...
0
votes
0answers
16 views

High Availability solution for MySQL

Guys I need an advice. I am not an SQL geek but have some experience with MySQL. So Currently I am stuck with choosing the best solution. So I need an advice from proffesionals who really had hands on ...
0
votes
0answers
7 views

Automaticly import csv table into mysql database [duplicate]

I want to know how to write a script or what program to use to automaticly import data out of different csv tables into my database. Ive got 2 different csv tables with data they get updated every ...
0
votes
0answers
5 views

What to use to host a remote connection for mySQL and website

I have create a java web app in netbeans that is locally connected to a MySQL workbench database. I now want this to be abled to access remotely and the website to be hosted online. How do I set up a ...
0
votes
0answers
9 views

Package with mysqli suggestions/autocomplete for Sublime 3

Is there any package that allows me to easy-complete my (my)SQL commands like PHP Completions Kit does for PHP? I'm not looking for any generators, just simply word-suggester. Actually, I think that ...
0
votes
1answer
38 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 ...
0
votes
0answers
9 views

Recommendation for Web-controlled music playback on pi

I want to work on a project I imagined a while ago where a raspberry pi plays back music from a queue. The queue should be accessible from a web page, hosted on the pi. As of now I have never worked ...
0
votes
0answers
5 views

MySQL + PHP + IoT - Notification on heartbeat failure

I'm working on a personal project that involves deploying internet-connected Arduino devices around my city. I'm planning on having them send a regular heartbeat to a PHP script that will log the ...
1
vote
0answers
18 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 ...
0
votes
0answers
14 views

Backend for local and remote synchronized database

I am creating a small software using PHP and I want it to connect to a local installation of MYSQL The requirement is: Local mysql database will be updated by php, local database should synchronize ...
0
votes
0answers
33 views

MySQL Connector/C++ 8.0 for Visual Studio 2017

I'm looking for a DLL or Static library for MySQL Connector/C++ 8.0 for both Debug and Release mode that works with Visual Studio 2017. Should be for 32-bit platform (windows 7 and windows 10 ...
0
votes
1answer
18 views

Are there any main differences between MySQL (MariaDB), PostgreSQL, Oracle, Microsoft Databases for usage in enterprise? [closed]

Lets take this: Company using Microsoft Server Database since 2008. Its company what heavily depends on working with data from databases. (Construction company ) Current database is outdated and not ...
0
votes
1answer
22 views

mysql viewer for windows that connects to SSH using a private key and a passphrase

I want to connect to a mysql database located on a linux server, through ssh and using private key and a passphrase, from windows 10, I'm looking for a GUI mysql viewer. PHPmyadmin won't work in such ...
0
votes
0answers
17 views

free mySQL management studio

This is my first question in this area I am looking for a good free mySQL management studio. I wonder if there is any thing as good as SQL Server Management Studio I tried mySQL workbench but is ...
0
votes
0answers
109 views

Simplest php/mysql form builder

I have a mysql database with several fields including columns called username and password in addition with few more columns of data. If an user enter username and password I need to display ...
1
vote
0answers
30 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, ...
0
votes
0answers
33 views

Open source web based accounting software

I am a web developer and am currently using MYOB, so I was looking for an opensource accounting web based (I do PHP/MySQL etc) software so that I can make my own plugins for it etc. I do Symfony ...
1
vote
0answers
16 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
47 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
1answer
25 views

Which server-side search technology to use for a multi-table string search?

I'm working on a platform that uses lots of database read power. Users perform lots of search queries, on various pages. Very often, when a search query is being handled, we use multiple ways to ...
0
votes
1answer
41 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.
2
votes
2answers
162 views

extract text from user's uploaded pdf and store it to database

I have an html form where a user can upload a pdf . I want to extract the whole text from pdf, search it for specific words and then store them in my database. Any ideas ? I don't ask you the whole ...
0
votes
1answer
33 views

Tuning MySQL/MariaDB

I am looking for a tool for identify and fix ddbb performance tuning problems. It must be free. I know the existence of mysqltuner and tuning-primer but still I haven't try it. Can anyone explain me ...
1
vote
0answers
21 views

Mssql vs mysql for software development [closed]

Me and my team are developing a database software.We came a long way working with ms sql server.The project we are working on is also based on MsSql.Now , after we're done with the software , we'll ...
1
vote
1answer
37 views

Test data generator for MySQL

I want a tool for populating a MySQL database with random data. The data generated for the primary and secondary keys should be coherent, so the data will not cause integrity errors. It should ...
1
vote
1answer
113 views

Windows GUI administration tool for MySQL that support 2FA

I'm looking for an alternative to HeidiSQL, Sequel Pro (OSX) or Navicat (software with GUI to manage MySQL database) on Windows that support SSH Tunnel with Two factor authentication. I've actually ...
1
vote
2answers
223 views

What open source program will graph data from mysql database?

I am looking for an open-source program to accomplish the same things that can be done with Qlik or PowerBI. The main difference is that I want the processing to be done on the server side rather ...
2
votes
1answer
72 views

Automated mysql table duplication between servers, via SQL

The problem: I need to backup a few servers databases (sometimes a single table, other times all tables in the database) and also in once case replicate a database on a nightly basis. So this is ...
0
votes
0answers
166 views

Is there any opensource java restaurant management system is available

I want to do an online mini project in java which is for food ordering in restaurant. Specifications Customer: Place the order, Pay the bill, Review order places, Employee: Take the order, Billing,...
2
votes
1answer
144 views

Drag and drop query browser

Is there a drag and drop query browser's like this for free or linux (except for Navicat, which is not free)
1
vote
1answer
28 views

SQL managing software to manage/edit querys

I've got a database I need to migrate to a new format. Now I have lots of data and I need some help in changing the queries to the format the new database accepts. Does someone know software to manage ...
2
votes
1answer
87 views

What is a good Python module to access data in a MySQL/MariaDB database?

I need to process a bunch of rows from a MySQL database table. I will be using Python as the programming language. Requirements: Python module reading the rows of an existing database/table data is ...
1
vote
1answer
183 views

Check for duplicate column names in an SQL query

I have a rather long SQL (MySQL flavor) query and want to check if different fields queries have the same name (or alias) like SELECT a, a .... Any software for this? I use Linux.
0
votes
1answer
50 views

MySQL client to Manage/Add/Delete Rows in Nested Set Tables

I am looking for a MySQL client such as Navicat or HeidiSQL that can manage/add/delete rows in nested set tables. To be more precise I am looking for client that will automatically rebuild the lft,...
-1
votes
3answers
95 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 ...
2
votes
1answer
40 views

Creating a database table from code with PHP

I have been experimenting with Python Django, and what I really liked was creating a database table from a model created in Python. I would love to do the same with PHP. I have been plowing through ...
3
votes
1answer
51 views

I need a GUI that will edit a TEXT column in MySQL

I normally use MySql Workbench. But I now have a table that has a column of type TEXT. It is used to store Python script for use in Jython. Some of these scripts can be quite large. Workbench only ...
1
vote
1answer
47 views

Good php mysql ORM library

I am having hard time writing same complex queries several times for bit different use cases like with limit, with filter, without limit etc. I came to know that using ORM we can manage this very ...
3
votes
0answers
890 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 ...
2
votes
2answers
153 views

Web-based tool to make analytics from a MySQL database

I have a hosted MySQL database, where I store several records like registered users and activites. I'm looking for a way to see these information in a more "graphical" way. For example, I would like ...
0
votes
5answers
102 views

What installer/software can I use to install multiple applications and services as well as place files in different locations?

Our clients have purchased something like 2000 machines (Dell all-in-ones running win8.1). The software we're building uses IIS and php to show content from the localhost through a Java front end. So ...
1
vote
0answers
29 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 ...