dataflareapp / dataflare Goto Github PK

Describe the bug

As you can see countrycode is a FK on both tables but when I see the schema, repeat FK Column 4 times per each table

Platform and Database

Windows 11, Postgres 15.3

Describe the solution you'd like

I'm trying to connect to an AWS aurora instance through SSH with a Public Key (.pem)
But it seams that the only option that it is available is through a Private Key (.key)

Describe the solution you'd like

Currently, when I open a new (or existing) postgres connection, the schema "pg_catalog" (or whichever is the first one when all available schemas are sorted alphabetically).

However, as this schema is probably not the one, people want to see, it would be great if the schema "public" would be selected per default.

Describe the solution you'd like

Is it possible to add a force drop/truncate when I want to clear my database or clear my data from a table.

Describe the solution you'd like

• When the row index is clicked, it opens the edit mode.
  It would be useful to select the entire row and copy its values as Ms Excel does.

Describe the bug

error returned from database: 3 is outside the valid range for parameter "extra_float_digits" (-15 .. 2)

Platform and Database

windows 10, postgreSQL 10

Describe the bug

If there are no rows, displaying columns is not responsive.

It cannot be possible scroll horizontally.

Whith data (good):

Without data (bad):

Platform and Database

Windows 11 - PostgreSQL

Describe the solution you'd like

Please provide support for Libsql specific features like

• ALTER TABLE extension for modifying column types and constraints
• Randomized ROWID
  https://github.com/tursodatabase/libsql

Describe the bug

When opening Dataflare 0.2.6 in MacOs Catalina 10.15.7 there is no main window present for the app:

Maybe the app is missing a MacOS min version requirement?

Platform and Database

MacOs Catalina 10.15.7
DataFlare 0.2.6

Describe the solution you'd like

In macOS when I make a click with two fingers to show the contextual menu over a table, there's no option to duplicate the table.

It would be great if that option could be added.

Here's an example of what I mean:

Describe the solution you'd like

I would like to be able to double click (or with a similar interaction) on a foreign key of a record in one table. This double click would ideally open the referenced table in a new tab with a pre-filled in query.

Example:

1. I open the table "comment" that references the "post" table via the foreign key "post_id"
2. I double click on the column (or a specific part of it, or right click) "post_id" of the first "comment" record in the "comment" table
3. The "post" table opens with the filter query pre-filled and executed, so the correct "post" record is shown: "post_id" = '2'

Describe the bug

I have reinstalled the application and in all my attempts, the application never starts, no matter how many times I change the settings to administrator, the application does not start.

Platform and Database

Windows 10

Describe the solution you'd like

I would like to set an access mode per database connection, so that I can assign myself only readonly-access or read-and-write-access to prevent me from accidentally modifying data.

Describe the bug

On windows, the icon is super blurry....

Platform and Database

Windows 10

sqlite

Describe the bug

Got the following message on executing LOAD httpfs;

DuckDb("IO Error: Extension "/Users/wangjie/.duckdb/extensions/v0.9.1/osx_arm64/httpfs.duckdb_extension" could not be loaded: dlopen(/Users/wangjie/.duckdb/extensions/v0.9.1/osx_arm64/httpfs.duckdb_extension, 0x0006): tried: '/Users/wangjie/.duckdb/extensions/v0.9.1/osx_arm64/httpfs.duckdb_extension' (code signature in <5CE6D284-D802-3C3D-B84C-F1C9A34B00FE> '/Users/wangjie/.duckdb/extensions/v0.9.1/osx_arm64/httpfs.duckdb_extension' not valid for use in process: mapping process and mapped file (non-platform) have different Team IDs), '/System/Volumes/Preboot/Cryptexes/OS/Users/wangjie/.duckdb/extensions/v0.9.1/osx_arm64/httpfs.duckdb_extension' (no such file), '/Users/wangjie/.duckdb/extensions/v0.9.1/osx_arm64/httpfs.duckdb_extension' (code signature in <5CE6D284-D802-3C3D-B84C-F1C9A34B00FE> '/Users/wangjie/.duckdb/extensions/v0.9.1/osx_arm64/httpfs.duckdb_extension' not valid for use in process: mapping process and mapped file (non-platform) have different Team IDs)")

Platform and Database

macOS 14.0 / DuckDB 0.9.1

Describe the solution you'd like

In the table column modification view, as for the Primary and Not null columns, add a Unique column to find out if a column has a uniqueness constraint.

Describe the bug

Maybe the app just doesn't work on my OS (macOS 11.7.10 BigSur)?

But when opening, and trying to select a database to create a new connection nothing happens, also tried using keyboard just in case.

Platform and Database

macOS 11.7.10 BigSur

Describe the bug

Schema:

As an example, in Table Plus a point is shown in this format: (xx.xxxxxxx,yy.yyyyyyyy).

Platform and Database

Postgres 15.4 on NeonDB.

Describe the solution you'd like

Triggers in SQLlite DDBB aren't working, it prompts "Rusqlite("incomplete input")" error and "Rusqlite("cannot commit - no transaction is active")"

Describe the solution you'd like

I don't know if it already has this function, and if it does it doesn't work correctly, but it would be great to add the drag and drop sql script files function to simplify the function of importing scripts that has to be done manually

Describe the bug

Schema:

Platform and Database

Postgres 15.4 on NeonDB.

Describe the bug

The Mssql connection option returns a message that says 'An error ocurred during the attempt of performing I/O: tls handshake eof'

Platform and Database

Windows 10 - 64 bits, MSSQL connection

Describe the bug

Platform and Database

Intel macOS 14.0 MySQL 8.0

Describe the solution you'd like

Run filter when pressing enter key

• Run filter when pressing Enter Key, as if the Apply button was clicked.

Describe the bug

when i would like to execute all clausules from my sql file, Dataflare will execute some of the clauses, instead of all.

Example:

this consult has eight tablas , when i executed the file. DataFlare don't create all tables and alter tables clausules

Platform and Database

Windows 11 23580.0 / mariaDB

Describe the bug

I get

TypeError: window.crypto.randomUUID is not a function. (In 'window.crypto.randomUUID()', 'window.crypto.randomUUID' is undefined)

when trying to import from a mysql url mysql://user:[email protected]/dbname

Platform and Database

macOS 11.7.10 BigSur 😇

Describe the solution you'd like

In the drop-down list, add a link to display all the PKs and FKs of the table associated with a column.

Describe the solution you'd like

• Actual behavior:

• Should be like this:

Describe the solution you'd like

When an update is made, have a button to confirm the changes and not update them directly, this as a security layer for the human factor

Describe the bug

I am using Key authentication with a username and no password.

Here is the error it gives when testing the connection:

error communicating with database: Connection reset by peer (os error 54)

I've used other software to connect to the remote database without issue.

Platform and Database

Running in Docker on Linux, postgres 16.

Describe the solution you'd like

this looks awesome, thanks. i'd like to host this on the server, adjacent to the db. preferably in the same docker compose file. like dbgate

Describe the solution you'd like

Synchronize row limit between opened table tabs

• Actual behavior:
  1.- When the user changes the row limit number, is changed only in the current tab but not in the others.
  2.- When the table tab is closed, the limits resets to default.

• Should be like this:
  1.- If the row limit is changed when there are more than one opened tables, each table limit should be the same.
  2.- When the table tab is closed, it should remain the same when is opened again.

Describe the solution you'd like

Add a Comment column in the column edit view.

Describe the solution you'd like

Currently if I simply wanted to browse a database and look at all its tables, I will end up with lots of tabs! I would prefer to decide when a new tab is created instead of having one created automatically. This could be a toggle in the settings.

What is your question?

1. I tried to edit a table, and I just be able to edit the name of the column and (add new one and remove old ones), this is the objective of this function? Or in the future I can change type column, default value, check and un check options?

2. I just updated the application and a feature that I suggested was added (Amazing..!!) But I do not know what else were added, I know that many times you make a post on twitter with the updates but I think would be great a section maybe inside Help and Feedback with the history of the versions or maybe current version, I am a developer too so I know this is kind of boring but for the user could be useful

Sorry if I recently open many issues, because I really like Dataflare haha

Thanks

Describe the solution you'd like

Add a tree like view for partitioned tables so that by default only main partitioned table would be visible in table view. And all the attached partitioned would be hidden on lower level

Describe the solution you'd like

This DB client is looking great!

Turso has launched a DB that is getting very popular. It's based on libsql.

There is no support for LibSQL yet in TablePlus or any other desktop clients that I know. It'd very useful and a unique feature for Dataflare.

I'm not affiliated with Turso. Just a user.

Describe the solution you'd like

Now when you execute a query and there are no rows to display it says "no rows", it would be nice to be able to see the table with empty rows.

What is your question?

I try to import my sql file, found export but where is import feature?

Describe the solution you'd like

I think this would a be nice to add it, because if I want to edit a table I can see the different checks of the columns, just consideration

Describe the bug

On testing connection is successful

but after press connect button I got error
Token error: 'Invalid object name 'information_schema.schemata'.' on server SERVER_NAME executing on line 2 (code: 208, state: 1, class: 16);

btw if I connecting with SSMS to remote server is still working

Platform and Database

Windows 11 
version 23H2
OS Build 22635.2915

Microsoft SQL Server Standard Edition (64-bit)
Version 13.0.1601 RTM

Describe the solution you'd like

I'm unable to locate the option to save an .sql script

Describe the solution you'd like

Currently I must open sqlite files from the app....

Could Dataflare also support opening files in the Finder?

Describe the solution you'd like

So that I don't have to manually enter host, db name, password etc.

Describe the solution you'd like

I just started using Dataflare today on my Windows laptop, and it works great so far. Currently, the schema manager is quite a great feature in the software. However, there are some enhancements that could make it better

• First, I would love to export the schema manager as an image in order to share with my colleagues and use it for creating data dictionary for my use case.
• I personally love to see the auto-arrangement feature in it, so I can view the schema easier than before.
• If it is possible, I would love to see the overview of every single schema in the database repository, with grouping based on schema. My current projects are using PostgreSQL, and there are a ton of schemas to understand the relationships between tables across schemas. So, having database overview would be a plus in my book.

Those are my feedback about the enhancement for Schema Manager, so far.

Describe the solution you'd like

I am not sure which tool use the app to suggest autocompletes but if you can add when we use alias to table for example

FROM users S

Would be amazing when me type S. suggests all the columns of the table maybe could help when we do not know the structure of the table

Thanks..!

Describe the bug

When you have too many columns and you want to display the INSERT query, the code isn't scrollable.

Platform and Database

Windows 11 22H2
MariaDB

Describe the bug

Every time I change the value of a record from the table content view UI and saved I get a "Primary key not unique".
This happens even with simple string changes on a varchar. If I made the same change via SQL sentence it get saved without problem at all.

I made a video showing the issue:

Platform and Database

OS: MacOs 13
DB: postgres 9.5

Describe the solution you'd like

I assume the color theme is based on your system preferences, but it would've been nice to be able to change it manually from within the application as well.

Thanks, the app seems great!