ragnar-lodbrok / meow-sql Goto Github PK

I have this table:

CREATE TABLE `characters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `name` char(50) NOT NULL,
  `world_id` int(10) unsigned NOT NULL,
  `x` int(10) unsigned NOT NULL,
  `y` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_character` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4

When I try to insert a row into this table with meow-sql, it crashes.
After some investigation, I notice that the tab 'Basic', which shows the columns in the table, doesn't show the x and y columns (only the first four columns are shown). The tab 'Data' however does show the x and y column. But when I try to insert data in that tab, meow-sql crashes.

and change active database

Now it's shown on top left corner

Hello Ragnar.

HeidiSQL' developer has an offer to make, that maybe interest you.
Could you please take a look at his post?

Remember windows positions, UI sizes etc

Hello,

This is not directly an issue, but more a feature request.
HeidiSQL show the SQL queries of all the actions you do in the GUI. Could this also be implemented?

Show Query Logs in UI

Something minimal to edit data

Set default column length for newly created columns e.g. 50 for VARCHAR

But: resizeColumnsToContents() is very slow, so better to check first say 50 rows like done in HeidiSQL, see:

Update a project and instruction of building on Windows.

Parse spatial/geometry data as binary (not Unicode string as now) and display as hex.

Example: sakila.address.location is GEOMETRY column and not shown correctly.

Add dropdown with enum values for table data editor

Read table structure back from server after saving it?

Allow to use multiple columns for editing/creating foreign keys.

It would be nice to have support for PostgreSQL.

Now we have only 32 bits

Just realized you can't now lol

libstdc++.so.6: version 'GLIBCXX_3.4.20' not found, please see https://github.com/AppImage/AppImageKit/wiki/Creating-AppImages#libstdcso6

Reference:
AppImage/appimage.github.io#442

If table data cell has multi-line content, e.g.:

str1
str2
str3

... it will be displayed as str1str2 without ellipsis at the end and white spaces (more over str3 will not be shown at all).
Need to display it with white spaces at place of linebreaks and with "..." at the end if the string is too long.

Steps:

1. Create new table
2. Add new column that has Allow NULL = true
3. Add Primary Key with column from 2
   Result: Error on save: "All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead"
   Expected: column from 2 will auto change Allow NULL to false.

Multiple sessions (open session manager from main window)

Allow to edit table data

Save move changes when data not affected (only position)

Fix multiple issues with size of labels, icons, controls and table row height:

It's my dream to run HeidiSQL natively on Linux and I know many developers who want it too. So @ragnar-lodbrok maybe we can help somehow to the project? Could you set up a sponsoring profile on Github?