Giter VIP home page Giter VIP logo

pgedit's People

Contributors

dimaaan avatar

Watchers

 avatar

pgedit's Issues

Adopt FastColoredTextBox in SQL editor

Preface

  1. Standard text box have an issue in multiline mode: Ctrl+A doesent select all text.
  2. Anyway syntax hilight needed in future

So

FastColoredTextBox looks nice. I'l try to use it

Investigate

  1. Mono support
  2. Language and translations
  3. Ability to work with SQL AST

SQL Editor: More information on error

For example, run script on pgAdmin outputs following

NOTICE: table "tenant_balance_income" does not exist, skipping
CONTEXT: SQL statement "DROP TABLE IF EXISTS tenant_balance_income"
PL/pgSQL function inline_code_block line 48 at SQL statement
NOTICE: CREATE TABLE / UNIQUE will create implicit index "tenant_balance_history_id_key" for table "tenant_balance_history"
CONTEXT: SQL statement "CREATE TABLE ... )"
PL/pgSQL function inline_code_block line 51 at SQL statement

ERROR: null value in column "balance" violates not-null constraint
DETAIL: Failing row contains (7, 784, 7, 29869.00, t, BANK_TRANSFER, 2014-08-11 08:49:17.758, null, Платеж по счету № 8311).
CONTEXT: SQL statement "INSERT INTO ..."
PL/pgSQL function inline_code_block line 69 at SQL statement
********** Ошибка **********

ERROR: null value in column "balance" violates not-null constraint
SQL-состояние: 23502
Подробности: Failing row contains (7, 784, 7, 29869.00, t, BANK_TRANSFER, 2014-08-11 08:49:17.758, null, Платеж по счету № 8311).
Контекст: SQL statement "INSERT INTO ..."
PL/pgSQL function inline_code_block line 69 at SQL statement

pgEdit outputs
ERROR: 23502: null value in column "balance" violates not-null constraint

Enumeration items

Display enumeration items tooltip in table shema -> column type if column type is enumeration

Update shortcuts

Sync context menu shortcuts with main menu, so user can see them
Ctrl+E SQL Editor

Removing connections enhancement

  1. Remove database by selecting it in TreeWorkspace and pressing DEL
  2. Add hotkeys to "Remove server" and "remove database" context menu items
  3. When last database on server removed also remove server itself

Navigation with primary keys

Clicking by primary key cell opens menu with depend tables. selecting table send user to table with dependent rows filtered

filter by value

On table workspace add ability to filter column by some value. Value suppiled by user

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.