Stack Exchange Network

Stack Exchange network consists of 174 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
1answer
20 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

Which is best way for php mysql website making in core method? [closed]

Which is best way for php mysql website making in core method? Need to consider the following, Optimized Secured User Friendly Without use of third party CSM or framework. Good performance (even ...
0
votes
0answers
6 views

How can i solve this error in pycharm? [closed]

error: command 'C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.16.27023\bin\HostX86\x86\cl.exe' failed with exit status 2
0
votes
0answers
6 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
3 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
votes
0answers
8 views

NodeJS file sharing server using express knex Mysql ,like Dropbox or Google Drive

i'am working on filemanager nodejs express project and i found to many exemples using static folder. What i'am looking for is if it is possible to make a file server for each user logged in a system. ...
-1
votes
0answers
11 views

microsoft azure SQL and tableau connection

I am trying to create a SQL Database and azure and connect there through tableau . I already setup all drivers for ODBC connection on my PC , but still not able to connect to my DB in azure. would ...
1
vote
0answers
14 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
13 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
17 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
17 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
14 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
63 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
26 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
18 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
12 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
44 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
24 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
0answers
12 views

Recommended back-end application for trying out nginx proxy_pass load balancing?

What's a good back-end application to try out nginx proxy_pass load balancing behind? I'm looking for something that runs over HTTP ideally and is pretty easy to setup, open source, runs on Linux and ...
0
votes
0answers
100 views

“Best” backend database/API/framework for my new NativeScript + Angular cross-platform mobile application

My type of application: Lots of chatrooms that users are subscribed to and get notifications from. These chatrooms are location based (GPS coordinates are important for what chatrooms you’re close to,...
0
votes
1answer
39 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
140 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
32 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
18 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
33 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
97 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
206 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
158 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
139 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
27 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
79 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
135 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
48 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
93 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
38 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
49 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
45 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
799 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
145 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
101 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
28 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 ...
0
votes
1answer
45 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 ...
1
vote
1answer
298 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
3answers
423 views

MySql command line with auto-complete

I am looking for free a Windows executable (not Java, Python, Ruby, etc...) Mysql command line/shell/console with autocomplete. It should autocomplete keywords (sel<tab> becomes select, ins<...
0
votes
2answers
58 views

Super complex database visualization

I work with MySQL, and I am using MySQL Workbench, to have a global visualization of my database. The problem is that my database is turning very complex, with lots of tables and relationships, so it ...
2
votes
0answers
47 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 ...
1
vote
2answers
110 views

Store billions of rows with no relation

I'm going to receive a large group of CSV files daily. Additionally I have 1 billion records of data (from those CSV files) but its not a fixed number (1b records daily). They're going to be growing ...
0
votes
1answer
60 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 & ...