Anyone recommend omnidb.org?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Anyone recommend omnidb.org?

Tom Browder
I'm looking at https://omnidb.org to use instead og pgamin4.

Any users here? Any recommendations?

Thanks.

Cheers!

-Tom
Reply | Threaded
Open this post in threaded view
|

Re: Anyone recommend omnidb.org?

Tom Browder
On Thu, Aug 29, 2019 at 02:23 Ilija Vidoevski <[hidden email]> wrote:
Hi Tom.

I use EMS SQL Manager lite for Postgresql.
This is freeware version and for me is OK.

Thanks, Ilija.

Cheers!

-Tom
Reply | Threaded
Open this post in threaded view
|

Re: Anyone recommend omnidb.org?

Lætitia Avrot
In reply to this post by Tom Browder
Hi Tom,

If you need to query data more than once a week, I strongly suggest to learn command line tools like psql.
It's more difficult than a GUI tool at first but you'll become so much more efficient in the future!

If you need some help with psql, may I suggest :

Have a nice day,

Lætitia

Le jeu. 29 août 2019 à 02:34, Tom Browder <[hidden email]> a écrit :
I'm looking at https://omnidb.org to use instead og pgamin4.

Any users here? Any recommendations?

Thanks.

Cheers!

-Tom


--
Paper doesn’t grow on trees. Please print responsibly.
Reply | Threaded
Open this post in threaded view
|

Re: Anyone recommend omnidb.org?

Tom Browder
On Fri, Aug 30, 2019 at 07:07 Lætitia Avrot <[hidden email]> wrote:
Hi Tom,
..l

Thanks, Laetitia, for the good advice. I generally do as you suggest for most regular use (usually with Perl 6 scripts), but sometimes a GUI is helpful for me looking around, especially when experimenting.

Best regards,

-Tom
Reply | Threaded
Open this post in threaded view
|

Re: Anyone recommend omnidb.org?

Gavin Flower-2
On 31/08/2019 00:23, Tom Browder wrote:

> On Fri, Aug 30, 2019 at 07:07 Lætitia Avrot <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>     Hi Tom,
>
> ..l
>
> Thanks, Laetitia, for the good advice. I generally do as you suggest
> for most regular use (usually with Perl 6 scripts), but sometimes a
> GUI is helpful for me looking around, especially when experimenting.
>
> Best regards,
>
> -Tom

Hi Tom,

I write sql scripts that I can annotate with comments, then execute in
psql via the \i command.  I only type SQL directly into psql for trivial
things.

I find GUI tools cumbersome.


Cheers,
Gavin



Reply | Threaded
Open this post in threaded view
|

Re: Anyone recommend omnidb.org?

Bzzzz
On Sat, 31 Aug 2019 10:52:57 +1200
Gavin Flower <[hidden email]> wrote:

> I write sql scripts that I can annotate with comments, then execute in
> psql via the \i command.  I only type SQL directly into psql for
> trivial things.
>
> I find GUI tools cumbersome.

metoo, I use a spreadsheet, as it is very workable for this matter ; I
export it's sheets in the text format, a pass of sed on the files to
eliminate double quotes and here we go (again:)

Jean-Yves


Reply | Threaded
Open this post in threaded view
|

Re: Anyone recommend omnidb.org?

Arni Kromić
In reply to this post by Tom Browder
I've tried it and it seems quite nice. Seems perfect as a backup GUI
tool for occasions when pgAdmin acts up because of a new bug; something
that unfortunately happens often lately.

The server version would be a full replacement for pgAdmin but
unfortunately it is quite hard to setup and even more unfortunately it
doesn't install itself as a system service (on Linux at least) so it's a
non option for me at the time.

The desktop version is very handy though.

Regards,
Arni

On 29/08/2019 01.30, Tom Browder wrote:
> I'm looking at https://omnidb.org to use instead og pgamin4.
>
> Any users here? Any recommendations?
>
> Thanks.
>
> Cheers!
>
> -Tom