Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?
Дата
Msg-id CAFj8pRALWrdJvHEAmmvpLX0Jpk4JnLvQC17-hc0C0TkO6zAhRw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?  (Dmitry Igrishin <dmitigr@gmail.com>)
Ответы Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?
Список pgsql-general


2018-07-16 13:52 GMT+02:00 Dmitry Igrishin <dmitigr@gmail.com>:


пн, 16 июл. 2018 г. в 14:26, <kpi6288@gmail.com>:

We – and the majority of our customers - are mainly focused on Windows. We use pgadmin iii and our own assistants. pgadmin iv ist still too slow on Windows compared to pgadmin iii. That is one reason why we still use PostgreSQL 9.6.  

For performance reasons I mostly use the C++ language. Thus, I think the performance
should not be a problem here.
 

 

That said, one requirement on a commercial tool for us would be royalty free distribution to our customers. It should however provide the functions of pgadmin iii.

Do you need an administration tool or an assistant for database development? I conceived Pgspa as a
development tool, which works with source files organized in the usual way. For example, the sources
of the schema "foo" could be organized as:
  foo/functions/*.sql
       /views/*.sql
       /triggers/*.sql
       ...
The developer works with files rather than objects retrieved from the database and loaded
into the tree view of the GUI (like in pgAdmin and most of other similar tools). Though, the
database browser GUI is a useful feature of course, and should be implemented.

Few years I am thinking about new IDE for stored procedures. Probably It should not be written from scratch, but It should to be multiplatform.

what can be nice

1. source should be in files with GIT support
2. integration with developer databese + well autocomplete support
3. formatting - SQL, PL, ..
4. online code validation
5. The should not be strong relation between files and schemas. Now is not too hard to have information what content is in some file. There can be physical organization (by files), and logical (by schemas, functions, views, ...)
6. good performance is important - but Java is good enough today - DBeaver is has good speed

Regards

Good luck - can be pretty hard to write it.

p.s. IDE for developers is some different than admin tool for administrators. Should be decided what is target.

Pavel



 

Regards Klaus

 

 

Von: Dmitry Igrishin <dmitigr@gmail.com>
Gesendet: Sonntag, 15. Juli 2018 18:59
An: pgsql-general@postgresql.org
Betreff: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

 

Hello all,

 

Colleagues. There is an idea to develop a commercial IDE for PostgreSQL under Windows.

At the initial stage, not so much an IDE, as an assistant for the server side development.

What features would you like to see in such an instrument? Thanks.


В списке pgsql-general по дате отправления:

Предыдущее
От: Dmitry Igrishin
Дата:
Сообщение: Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?
Следующее
От: Dmitry Igrishin
Дата:
Сообщение: Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?