Re: Building a notification system.

2018-07-15 Thread Anto Aravinth
On Mon, Jul 16, 2018 at 8:02 AM, Christopher Browne wrote: > On Sun, Jul 15, 2018, 5:30 AM Anto Aravinth, > wrote: > >> Hello Everyone, >> >> >> I'm playing around with postgresql with SO datasets. In the process, I >> have dumped 60M questions data onto the postgresql. I'm trying to build a >>

Re: Building a notification system.

2018-07-15 Thread Christopher Browne
On Sun, Jul 15, 2018, 5:30 AM Anto Aravinth, wrote: > Hello Everyone, > > > I'm playing around with postgresql with SO datasets. In the process, I > have dumped 60M questions data onto the postgresql. I'm trying to build a > notification system on top of this, so that, when a user edits a questio

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

2018-07-15 Thread Christophe Pettus
> On Jul 15, 2018, at 16:06, Dmitry Igrishin wrote: > > The cross-platform GUI toolkit will be the challenge. > This is why I've consider GUI for the Windows only. And if I'll not find an > adequate GUI > toolkit (at reasonable price and/or license), there is an option to make the > GUI avail

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

2018-07-15 Thread Dmitry Igrishin
пн, 16 июл. 2018 г. в 1:14, Tim Cross : > > Dmitry Igrishin writes: > > > вс, 15 июл. 2018 г. в 22:42, Chuck Davis : > > > >> If you decide to proceed on this project there's no need to reinvent the > >> wheel. > >> > >> I use Netbeans for my development. it has quite a good facility for > >> wo

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

2018-07-15 Thread Tim Cross
Dmitry Igrishin writes: > вс, 15 июл. 2018 г. в 22:42, Chuck Davis : > >> If you decide to proceed on this project there's no need to reinvent the >> wheel. >> >> I use Netbeans for my development. it has quite a good facility for >> working with databases and I use it regularly with Postgres.

Re: two instances of postgres on the same machine?

2018-07-15 Thread Martin Mueller
Many thanks for your generous help, and on a Sunday afternoon as well. This is a wonderful listserv, and I am deeply indebted to it. MM On 7/15/18, 2:17 PM, "Tom Lane" wrote: Martin Mueller writes: > I created a dumpfile from a 10.3 postgres installation on a Mac and tried to resto

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

2018-07-15 Thread Dmitry Igrishin
вс, 15 июл. 2018 г. в 23:51, Ravi Krishna : > 1. dbeaver covers many DBMS and even nosql. Many shops are not one > product specific. That is definitely a plus. > On the other hand it is hard to support unique features of PostgreSQL in a tool that attempts to cover all the world. I can't say abou

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

2018-07-15 Thread Ravi Krishna
1. dbeaver covers many DBMS and even nosql. Many shops are not one product specific. That is definitely a plus. 2. Lightweight tool which can run even from command line will be a plus for the product you are thinking to develop. 3. Who cares in what language it is developed? We are a dbeaver sho

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

2018-07-15 Thread Dmitry Igrishin
вс, 15 июл. 2018 г. в 23:05, Ravi Krishna : > What would this new IDE offer which a product like dbeaver does not have. > AFAIK, DBeaver: - covers many DBMS (I want to focus on PostgreSQL); - full fledged IDE with feature rich editor (I want a lightweight tool that can be used from command

Re: two instances of postgres on the same machine?

2018-07-15 Thread Tom Lane
Martin Mueller writes: > I created a dumpfile from a 10.3 postgres installation on a Mac and tried to > restore it on another Mac 1,000 miles away, but forgot that that machine runs > Postgres 9.6. OK ... > The command > /Applications/Postgres.app/Contents/Versions/9.6/bin/psql -U postgres >

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

2018-07-15 Thread Dmitry Igrishin
вс, 15 июл. 2018 г. в 22:42, Chuck Davis : > If you decide to proceed on this project there's no need to reinvent the > wheel. > > I use Netbeans for my development. it has quite a good facility for > working with databases and I use it regularly with Postgres. Since > Netbeans is now licensed u

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

2018-07-15 Thread Ravi Krishna
What would this new IDE offer which a product like dbeaver does not have. --Sent from phone.

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

2018-07-15 Thread marcelo
For windows platforms only, there is https://www.sqlmanager.net/products/postgresql/manager/ which in Lite version is free. I use it near daily and works like a charm. On 15/07/2018 16:08 , Dmitry Igrishin wrote: Thank you all for your responses! Okay, if I decide to start this project, the Lin

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

2018-07-15 Thread Chuck Davis
If you decide to proceed on this project there's no need to reinvent the wheel. I use Netbeans for my development. it has quite a good facility for working with databases and I use it regularly with Postgres. Since Netbeans is now licensed under Apache 2 you might find useful code there. Be ass

two instances of postgres on the same machine?

2018-07-15 Thread Martin Mueller
I made a stupid mistake with a backup and would be grateful for some advice on how to extricate myself. I created a dumpfile from a 10.3 postgres installation on a Mac and tried to restore it on another Mac 1,000 miles away, but forgot that that machine runs Postgres 9.6. The command /Applica

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

2018-07-15 Thread Raymond O'Donnell
On 15/07/18 20:08, Dmitry Igrishin wrote: Thank you all for your responses! Okay, if I decide to start this project, the Linux platform will be supported. As I see it, pgspa (PostgreSQL Server Programming Assistant) should have both the command line interface, and the GUI for visualizing som

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

2018-07-15 Thread Dmitry Igrishin
Thank you all for your responses! Okay, if I decide to start this project, the Linux platform will be supported. As I see it, pgspa (PostgreSQL Server Programming Assistant) should have both the command line interface, and the GUI for visualizing some aspects of the work. The tool should be frien

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

2018-07-15 Thread Chuck Davis
I use Linux exclusively in my business and for development. There is no room in the world these days for a Windows-only product. If people choose to use Microsoft platforms they should expect to purchase Microsoft licenses for their needs. That said, a good, cross-platform tool for Postgresql wo

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

2018-07-15 Thread James Keener
Being libre software that doesn't necessitate a closed source operating system. Jim On July 15, 2018 12:59:08 PM EDT, Dmitry Igrishin wrote: >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 ass

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

2018-07-15 Thread Benjamin Scherrey
Linux compatibility. :-) Seriously. Our organization does not use Windows anywhere and we're a serious Postgres shop. -- Ben Scherrey On Sun, Jul 15, 2018 at 11:59 PM, Dmitry Igrishin wrote: > Hello all, > > Colleagues. There is an idea to develop a commercial IDE for PostgreSQL > under Wind

Re: Building a notification system.

2018-07-15 Thread Anto Aravinth
So just maintaining a notification table along with user id would do I believe. Just notifies the user if he/she has the userid in notification table and its not in read state. On Sun, Jul 15, 2018 at 10:23 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Sunday, July 15, 2018, Dav

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

2018-07-15 Thread Dmitry Igrishin
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.

Re: Building a notification system.

2018-07-15 Thread David G. Johnston
On Sunday, July 15, 2018, David G. Johnston wrote: > On Sunday, July 15, 2018, Anto Aravinth > wrote: >> >> I'm not sure, how to get started with this. Read about NOTIFY: >> https://www.postgresql.org/docs/current/static/sql-notify.html >> >> >> Not sure that fits my use case, thanks for your he

Re: Building a notification system.

2018-07-15 Thread David G. Johnston
On Sunday, July 15, 2018, Anto Aravinth wrote: > > I'm not sure, how to get started with this. Read about NOTIFY: > https://www.postgresql.org/docs/current/static/sql-notify.html > > > Not sure that fits my use case, thanks for your help in this. > It doesn't. You need to record time stamps for

Re: TPC-H

2018-07-15 Thread Imre Samu
> Is there a table definition script available that is widely used for TPC-H in Postgresql to get results that can be compared? There are multiple "PostgreSQL + TCP-H" projects on the github - Maybe you can reuse some ideas ... https://github.com/search?q=%22TPC-H%22+postgresql&type=Repositories

TPC-H

2018-07-15 Thread Malte Vesper
Hello, I am trying to run TPC-H on PostgreSQL. While I was able to create the tables and run the queries, I am wondering if there is a table definition forTPC-H and PostgreSQL that is generally used, as far as I understand the TPC-H user can choose to create indices or

Building a notification system.

2018-07-15 Thread Anto Aravinth
Hello Everyone, I'm playing around with postgresql with SO datasets. In the process, I have dumped 60M questions data onto the postgresql. I'm trying to build a notification system on top of this, so that, when a user edits a question, I need to show a notification to the user when he/she logs in