Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Postgres.app

postgresapp.com

Post reply on HN
Print view View original

141–150 of 158 posts

Re: Postgres.app

#141

Post by mekster »

bob1029 wrote: post #135
scns wrote: post #93

Earlier quoted context omitted.

Not parent but mentioning nuget suggest parent is on dotnet, ie C/F# ergo semi-/typesafe. Parsing (not validating) at the edges should take care of it.

> Parsing (not validating) at the edges should take care of it. Precisely. We use a tiny ORM on top of Dapper to make sure everything goes in and out of columns as expected.

How is isolation important to use SQLite?

Edge does not provide safety to every database modifications like manually editing data and you're screwed already.

Re: Postgres.app

#143

Post by mekster »

elpatoisthebest wrote: post #75
jamil7 wrote: post #35

For a really nice client for macOS see Postico: https://eggerapps.at/postico/ (not affiliated, just a fan)

Postico is the only application I miss from the days when I developed exclusively on the mac. To be fair, I use (and like) TablePlus, but it's no Postico...

What's better with Postico over TablePlus?

Re: Postgres.app

#144

Post by mekster »

afavour wrote: post #71
easton wrote: post #38

Earlier quoted context omitted.

I'm curious, why postgres.app and not SQLite? I'd usually reach for SQLite as my next step up from Excel, but maybe that's wrong (it's very possible that you're talking about an order of magnitude more data than I am).

Not the OP but I never found a good GUI for SQLite. Postico is a fantastic GUI for Postgres. I’ll admit it’s been a very long time since I’ve looked, though.

What's wrong with TablePlus?

Re: Postgres.app

#145

Post by rubyist5eva »

scns wrote: post #111
rubyist5eva wrote: post #63

Earlier quoted context omitted.

It's so bad I just install a RHEL VM and use podman instead. The difference is insane.

Obligatory shilling for openSUSE Tumbleweed :) Newer libraries, Podman, rolling release and higher perf. Disclaimer: Just a fan.

My entire homelab is Suse based, love love love it. I use RHEL for development at work becase our entire infra is RHEL based and that's it, everwhere I have a choice I use Suse.

Re: Postgres.app

#146

Post by bob1029 »

mekster wrote: post #141
bob1029 wrote: post #135

Earlier quoted context omitted.

> Parsing (not validating) at the edges should take care of it. Precisely. We use a tiny ORM on top of Dapper to make sure everything goes in and out of columns as expected.

How is isolation important to use SQLite? Edge does not provide safety to every database modifications like manually editing data and you're screwed already.

We never allow for manual edits of live SQLite databases. Everything happens through code.

If someone wants to play around with a SQLite database from production, we just copy the file and hand it to them. That's kinda the whole point IMO.

Re: Postgres.app

#147

Post by elpatoisthebest »

mekster wrote: post #143
elpatoisthebest wrote: post #75

Earlier quoted context omitted.

Postico is the only application I miss from the days when I developed exclusively on the mac. To be fair, I use (and like) TablePlus, but it's no Postico...

What's better with Postico over TablePlus?

Well, I wouldn't say "better" just things I miss and notice that bug me about TablePlus. This is specific to my workflow and my project.

There are a couple quality of life things:

1) Postico can infer that I mean NULL if I delete a column value. TablePlus thinks that if I have clicked into a column, I MUST mean that I want an empty string. It happens to me pretty often where I accidentally click the wrong NULL column to update, and when I click away it sets it to "EMPTY", but maybe the column type is a timestamp or something...so I get an invalid type error when I go to add the one I meant to change manually. It's frustrating, but very common. You have to right click and click, the "SET NULL" option.

2) Postico gives me a toggle for ENUM types and Bool types. I can't remember what ENUM values I can choose in one of my tables, so that can be cumbersome.

3) Postico has DDL right at the bottom of the table

4) Table right click options. In Postico I can right click a table name and Open contents/structure/ddl, Copy Name (really useful for those dumb tables we set up in camelCase in the migration from mysql to postgres...), delete, truncate, Analyze, Vacuum, Reindex, Import CSV, and Export In TablePlus I can Import/Export Delete/Truncate. That's it.

Positive on TablePlus is that they did recently add some nice things to the SQL Query like wrapping my camelcase table name in double quotes for me. If only they could do that for the column names too...but it's not their fault we have our setup this way...

Also, I readily admit that Postico isn't as powerful as others. But I cannot use PGAdmin one more second in my life. I'd rather just use the cli.

Re: Postgres.app

#148

Post by scotu »

bdcravens wrote: post #103
NelsonMinar wrote: post #96

Earlier quoted context omitted.

Let's see... the user could download an app, click it, and run Postgres. Or they could figure out how to install Docker, then run a terminal, then type two obscure and inscrutable commands into it. Perhaps administrator privileges are required along the way. Sure, the Docker route is better in many ways. But perhaps you're not understanding the audience for a packaged Mac application.

I think it's a bad take to assume that everyone using a Mac needs a 1-2 click. If someone finds terminal commands "obscure", I'd hate to see what their SQL looks like, in which case maybe they shouldn't be running a database server. For what it's worth, installing Docker on Mac (the audience we're talking about) is as easy as installing Postgres.app (download an installer and open). No administrator privileges necess…

> If someone finds terminal commands "obscure", I'd hate to see what their SQL looks like, in which case maybe they shouldn't be running a database server

I think you are wrong. You are gatekeeping something extremely basic like a database from 1. beginners, 2. hobbyists, 3. even professionals that might have a different background than you (sql server on windows? Back when I used to write software for windows server, while using linux on my personal laptop, the command line was all but necessary), 4. my laptop died, I have to lead a dev workshop in 3 hours and I just got a new laptop but I don't have a full blown system that sets up my dev env because I literally have to do it once every 5+ years when I get a new computer, 5. more..

And I'm saying this as somebody who would probably go for the "command line" solution in most situations.

Re: Postgres.app

#149

Post by Mehdi2277 »

ramraj07 wrote: post #58
elnygren wrote: post #12

I've always preferred Docker for setting up databases and database-like services on a development machine because then everything is nicely isolated. i.e no need to worry about random files in /etc/foo, easy to setup many versions per project etc. This is what I've been using for Postgres: docker volume create postgres docker run -d \ -p 127.0.0.1:5432:5432 \ -v postgres:/var/lib/postgresql/data \ --name postgres \ -…

I’m yet to see people who use docker for development do it faster than People who don’t. They always end up having to mount specific folders etc which nullifies the isolAtion point and you lose so much because even something as simple as ide debugging becomes a complicated (if not impossible) task.

I've spent far too much time with build errors for environment issues that I do prefer docker or other environment management tools. I just have an alias for mounting relevant folders and value of docker is not isolation for my code, but isolation for system libraries.

A good example is recent mac update to big sur broke pip/python installs for a lot of people. Spending a while reading github issues to make something as basic as python and pip install numpy work is why I like docker for dev environments. There are IDEs that support docker extensions well.

I also do run most of my workloads on clusters so having things dockerized makes it much easier to reproduce a failure locally. Our CI that currently isn't dockerized occasionally has environment issues that are quite annoying to debug as I lack a good way to explore it's environment and see the mismatch.

Re: Postgres.app

#150

Post by ultrarunner »

jamil7 wrote: post #35

For a really nice client for macOS see Postico: https://eggerapps.at/postico/ (not affiliated, just a fan)

Also a fan of Postico. For anyone curious, I emailed support asking if there would be access to multiple query tabs after purchase/activation, but got no response. I'm happy to report that it does work that way, and works well. I hope this is app is still being supported because it's overall it's quite well done.
Post reply on HN