5 votes

mysql database visualization software for windows 7

There are plenty of these, and G.I.Y.F. But, what's wrong with the classic MySql workbench? In addition to allowing you to graphically create a new data base schema (and generate code to create it), ...
Mawg's user avatar
  • 9,033
2 votes
Accepted

MySQL Workbench equivalent with possibility of two-factor authentication

I am actually looking at this same issue myself, per my boss wants GUI access to our databases for himself and the developers at my company. I have found that Jetbrain's Datagrip works for 2FA (key ...
Gregory Martin's user avatar
2 votes

Technology stack for a Linux hosted web application

I'm a fan of the LAMP stack being, in my case: Linux (you've got Ubuntu) Apache MySQL (one of the requirements) PHP There's loads of free IDEs out there for PHP, you can use Eclipse, Netbeans or many ...
gabe3886's user avatar
  • 441
2 votes

Free options to MySQL Query Analyzer

If you are looking for something to help you analyze and optimize queries, the two tools that I can recommend most are Percona's PMM and Shattered Silicon's SSM (fork of PMM v1). Both support ...
Charlotte Ruddick's user avatar
2 votes

MySQL Workbench equivalent with possibility of two-factor authentication

Annoying that MySQL Workbench still lacks this in 2021: But, luckily, SSH tunnels can help. Simply SSH to the server using whatever client, then create the necessary tunnel. Since Ubuntu 20.04 LTS ...
AnthonyK's user avatar
  • 121
2 votes
Accepted

Check for duplicate column names in an SQL query

No software needed. Create a dummy view using your query. If it works, you're good, because views don't support multiple columns with the same name. CREATE VIEW v1 AS SELECT ... ...your query. If ...
Michael - sqlbot's user avatar
2 votes

Portable convert excel to mysql

Try https://sqlizer.io (I work here) which converts Excel (xls and xlsx) files to SQL databases. It's free for small databases (under 5000 rows) then costs $15. You have to tell it which worksheet and ...
a_good_swan's user avatar
2 votes
Accepted

GUI-based version control tool for MySQL

Providing that you, or your organisation, are ready to pay for it there is Datical DB which is a commercial tool built on top of Liquidbase and provides, amongst other stuff, a GUI interface. The web ...
Steve Barnes's user avatar
  • 31.6k
2 votes

Test data generator for MySQL

I've seen this question before https://stackoverflow.com/questions/15608438/how-can-i-populate-my-databases-all-tables-with-random-data! I found that filldb.info seems to works well. Main Database ...
François's user avatar
2 votes
Accepted

Recruitment: FOSS CRM(-ish)

Some suggestions: SuiteCRM is a fork/successor/improvement on the old community version of SugarCRM. You can use it for both contacts (candidates) and companies. You can record notes/calls etc, and ...
Z Z's user avatar
  • 2,475
2 votes
Accepted

What Technology is recommended to build a Resume Builder?

I recommend you to investigate a bit different approach for generating PDF from HTML. Instead of trying to find a perfect HTML to PDF library for your technology stack (e.g. PHP) try to take advantage ...
Andrew Taylor's user avatar
2 votes

is there a Mysql adapter for DBT?

I just published an initial adapter for MySQL: https://pypi.org/project/dbt-mysql/ Any bug reports are welcome! I only tested against MySQL 8.0, and it probably won't work with MySQL 5.x due to lack ...
dbeatty10's user avatar
2 votes

open source tool for SQL Queries

Pretty much any maintained open-source SQL Editor may be suitable for you. It really depends if you prefer also to be lightweight: Squirrel SQL - small footprint, universal (both source and os), ...
Kube Kubow's user avatar
1 vote
Accepted

Drag and drop query browser

[Update] OP has idicated that this answers his question. I leave the others below, in case they are of any use to others in future. Valentina Studio Pro includes a visual SQL query builder and you ...
Mawg's user avatar
  • 9,033
1 vote

SQL managing software to manage/edit querys

TLDR version - local mysql server, local apache server w/ php support, and phpmyadmin If you have your existing queries, and a sample dataset that hits all the combos, you could load it all up in ...
ivanivan's user avatar
  • 2,488
1 vote

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

Pandas provides a database abstraction layer over SQLAlchemy with a fallback to sqlite. Read the rows of an existing DB - Definitely but conceptually when using pandas dataframes you tend to think in ...
Steve Barnes's user avatar
  • 31.6k
1 vote

mysql database visualization software for windows 7

MysqlWorkbench Or you could try Toad for Mysql Both are free and in both you can see either data or schema details, modifying either in a tabular interface. MySqlWorkbench has a modeling interface ...
Andrew Seabrook's user avatar
1 vote
Accepted

What technology stack is needed to scale my app and find a balance between performance and productivity?

DB has to be SQL, but MySQL is buggy and I need a faster DB system for faster response times to the client. sqlite would be a good choice: The SQLite website (https://www.sqlite.org/) uses SQLite ...
Paul Sweatte's user avatar
1 vote

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

You can manage, add, delete rows using EMS SQL Manager for MySQL. For other purposes you asked please visit: Specifying master level using EMS SQL Manager Here's some of its features Advanced data ...
onurcano's user avatar
  • 674
1 vote

Creating a database table from code with PHP

use mysqli or pdo. Then you input a standard SQL statement in and execute it. $db=mysqli_connect('localhost','root','xxxx'); mysqli_select_db($db,'db'); mysqli_query($db,"create table scooby { col1 ...
cybernard's user avatar
  • 1,726
1 vote

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

For your need i think sqlyog will be the best product it is although not free but you will get 30 day trial for premium version and support for this. You can edit text type like this. Your text ...
Abhishek Gurjar's user avatar
1 vote
Accepted

Good php mysql ORM library

Have you looked into the Doctrine Project? Doctrine2 was inspired by the Java Library Hibernate. It comes with an excellent database abstraction library (DBAL) and a query language called DQL. ...
Layton Everson's user avatar
1 vote

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

You should be able to use the Deployment Image Servicing and Management (DISM) from the Windows Deployment Services Toolkit to come up with an image that fits onto a single DVD or USB drive and needs ...
Steve Barnes's user avatar
  • 31.6k
1 vote

CSV to SQL Insert Statement Software

I'd suggest you look at Data Transformer (disclaimer - I'm its developer). It can convert CSV/JSON/XML to SQL. The generated SQL contains "insert" statements for each line and a "create table" ...
Geo Systems's user avatar
1 vote

CSV to SQL Insert Statement Software

there's sqlizer.io (I work here) which is a web-based tool that does exactly as you're describing. Check it out (it's free for up to 5000 rows).
a_good_swan's user avatar
1 vote

MySql command line with auto-complete

You can do this with two parts: Install cygwin with the mysql packages. This gives you the command line on windows. Then, enable the mysql autocomplete, either in a command line switch or in my.cnf.
user151841's user avatar
1 vote

MySql command line with auto-complete

You can try MySQL-Workbench. It has auto-complete option, but is not command line. Learn more about it here
kaushik karan's user avatar
1 vote

Super complex database visualization

I think you should try different approach to your problem - don't try to create huge diagram, human capacity to digest large number of elements is limited. Create more smaller diagrams, each for a ...
Bad Pitt's user avatar
  • 131
1 vote
Accepted

Store billions of rows with no relation

I used to manage informations like these. I used PostgreSQL, where you have the advantage of a relational db and Nosql. You can store in a single record, normalized data, like import data, an id, etc....
user_0's user avatar
  • 216

Only top scored, non community-wiki answers of a minimum length are eligible