7 ms·

Everything that makes working with databases easier

78 points by mgramin 4y ago

thunderbong 4y ago
Ultorg should be there. IMHO, it's the best RDBMS viewer out there. https://www.ultorg.com https://www.ultorg.com
- jiriro 4y ago
  Started playing with Ultorg just last week and it looks amazing. It arranges results of join operations just the way I would design it in some report builder. But this is built-in with only two clicks:-)
- mgramin 4y ago
  Thank you. I have Ultorg in issues https://github.com/mgramin/awesome-db-tools/issues/291 https://github.com/mgramin/awesome-db-tools/issues/291 Could you create a PR?
pojzon 4y ago
PgBouncer, Flyway not on the list - hmm.
- nwatson 4y ago
  Flyway is there
- mgramin 4y ago
  Could you create a PR with PgBouncer?
jchw 4y ago
Would sqlc.dev fit here? It is now one of my favorite database-related codegen tools.
- mutant 4y ago
  > Would sqlc.dev fit here? It is now one of my favorite database-related codegen tools. So this scaffolds sql queries? That's pretty cool
- enobrev 4y ago
  This is excellent. I had just very recently thought to build this same thing for php and typescript. Haven't started it yet, but great to see the same thing out there for other languages.
  - jchw 4y ago
    If you don’t mind the codegen being written in Go, it does look like these folks also want to do the same thing for TypeScript. https://github.com/kyleconroy/sqlc/issues/296 https://github.com/kyleconroy/sqlc/issues/296 Given the success of packaging other Go and Rust tools into npm, like esbuild, I suspect it’s probably actually not too bad of an idea.
- teddyh 4y ago
  sqlc generates Go code, nothing else, but the web page of sqlc.dev does not mention this anywhere. Of course, this is a .dev site, and .dev is owned by Google, so it is only to be expected, I guess?
  - jchw 4y ago
    It is Go first and foremost, but there are work-in-progress generators for other languages, including Kotlin and (in my opinion, somewhat oddly,) Python. https://docs.sqlc.dev/en/latest/reference/language-support.html https://docs.sqlc.dev/en/latest/reference/language-support.h... It also only supports PostgreSQL as a first class option. It’s still maturing. That said, I’m using PostgreSQL + Go in production with no qualms.
- mgramin 4y ago
  Yep, thanks. Could you create a PR?
mberning 4y ago
A big omission is dbunit. It’s oldschool but very very powerful. I have used it for many things, but perhaps the must useful is extracting a subset of data out of oracle and inserting it into mysql in order to test components of production systems locally.
- mgramin 4y ago
  Unfortunately, last news in official site is 10 years old
  - mberning 4y ago
    They have had releases in the last year, and dbunit.sourceforge.net was updated in 2021.
armatav 4y ago
Is there a top 3 ranking available for categories like IDE?
dobin 4y ago
Unrelated, but I am happy I managed to avoid using any kind of DB in my last few small projects. User authentication? Hard code my credentials, and SSO for users. I dont want to store user accounts (als gets rid of all this password mail and reset stuff). Storing small amounts of data from users? Pickle it to files. Caching data? Keep it in-memory, retrieve it again when server restarts. Need to keep some data? Pickle it all 10 minutes and on sig-int. Saving so much time and nerves to not having to handle SQL, relations, foreign keys, docker-compose and all the other things.
- datalopers 4y ago
  And this is why I don’t hire Python devs for anything related to web.
  - dvngnt_ 4y ago
    why.
    - semicolon_storm 4y ago
      What happens when the program crashes in the middle of writing the data to disk? Now all the data you wanted to store is corrupted.
      - neurostimulant 4y ago
        You see, before you overwrite the actual file with the new content, you should wrote the new content in a separate temporary file first. That way, when your app detect corrupted files on startup due to power loss, you can program your app to look for the temporary files and write them to the main files if they pass your data validation. ... and before long, you'll reinvent database servers but shittier.
    - btilly 4y ago
      In this case, bragging about the steps taken to produce a strictly worse solution because the dev didn't want to learn what should be a basic dev skill. That said, criticizing all Python developers with this brush was very unfair.
cssanchez 4y ago
My issue with these awesome lists is that a lot of entries are out of date and may not even run anymore. The first entry, AnyMaestro's website has a news section last updated in 2016 (and it looks dated af), so why would I trust that tool with my DB credentials?
pvg 4y ago
Lists of things don't work that well as HN posts: https://hn.algolia.com/?dateRange=all&page=0&prefix=false&query=author%3Adang%20%22lists%20don%27t%22&sort=byDate&type=comment https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu...
srcreigh 4y ago
I don't trust this site since it doesn't include https://explain.dalibo.com/ https://explain.dalibo.com/
- mgramin 4y ago
  Thank you. Could you create PR or Issue with this tool?

78 points by mgramin 4y ago

thunderbong 4y ago

Ultorg should be there. IMHO, it's the best RDBMS viewer out there. https://www.ultorg.com https://www.ultorg.com

jiriro 4y ago
Started playing with Ultorg just last week and it looks amazing. It arranges results of join operations just the way I would design it in some report builder. But this is built-in with only two clicks:-)
mgramin 4y ago
Thank you. I have Ultorg in issues https://github.com/mgramin/awesome-db-tools/issues/291 https://github.com/mgramin/awesome-db-tools/issues/291 Could you create a PR?

pojzon 4y ago

PgBouncer, Flyway not on the list - hmm.

nwatson 4y ago
Flyway is there
mgramin 4y ago
Could you create a PR with PgBouncer?

jchw 4y ago

Would sqlc.dev fit here? It is now one of my favorite database-related codegen tools.

mutant 4y ago
> Would sqlc.dev fit here? It is now one of my favorite database-related codegen tools. So this scaffolds sql queries? That's pretty cool
enobrev 4y ago
This is excellent. I had just very recently thought to build this same thing for php and typescript. Haven't started it yet, but great to see the same thing out there for other languages.
- jchw 4y ago
  If you don’t mind the codegen being written in Go, it does look like these folks also want to do the same thing for TypeScript. https://github.com/kyleconroy/sqlc/issues/296 https://github.com/kyleconroy/sqlc/issues/296 Given the success of packaging other Go and Rust tools into npm, like esbuild, I suspect it’s probably actually not too bad of an idea.
teddyh 4y ago
sqlc generates Go code, nothing else, but the web page of sqlc.dev does not mention this anywhere. Of course, this is a .dev site, and .dev is owned by Google, so it is only to be expected, I guess?
- jchw 4y ago
  It is Go first and foremost, but there are work-in-progress generators for other languages, including Kotlin and (in my opinion, somewhat oddly,) Python. https://docs.sqlc.dev/en/latest/reference/language-support.html https://docs.sqlc.dev/en/latest/reference/language-support.h... It also only supports PostgreSQL as a first class option. It’s still maturing. That said, I’m using PostgreSQL + Go in production with no qualms.
mgramin 4y ago
Yep, thanks. Could you create a PR?

mberning 4y ago

A big omission is dbunit. It’s oldschool but very very powerful. I have used it for many things, but perhaps the must useful is extracting a subset of data out of oracle and inserting it into mysql in order to test components of production systems locally.

mgramin 4y ago
Unfortunately, last news in official site is 10 years old
- mberning 4y ago
  They have had releases in the last year, and dbunit.sourceforge.net was updated in 2021.

armatav 4y ago

Is there a top 3 ranking available for categories like IDE?

dobin 4y ago

Unrelated, but I am happy I managed to avoid using any kind of DB in my last few small projects. User authentication? Hard code my credentials, and SSO for users. I dont want to store user accounts (als gets rid of all this password mail and reset stuff). Storing small amounts of data from users? Pickle it to files. Caching data? Keep it in-memory, retrieve it again when server restarts. Need to keep some data? Pickle it all 10 minutes and on sig-int. Saving so much time and nerves to not having to handle SQL, relations, foreign keys, docker-compose and all the other things.

datalopers 4y ago
And this is why I don’t hire Python devs for anything related to web.
- dvngnt_ 4y ago
  why.
  - semicolon_storm 4y ago
    What happens when the program crashes in the middle of writing the data to disk? Now all the data you wanted to store is corrupted.
    - neurostimulant 4y ago
      You see, before you overwrite the actual file with the new content, you should wrote the new content in a separate temporary file first. That way, when your app detect corrupted files on startup due to power loss, you can program your app to look for the temporary files and write them to the main files if they pass your data validation. ... and before long, you'll reinvent database servers but shittier.
  - btilly 4y ago
    In this case, bragging about the steps taken to produce a strictly worse solution because the dev didn't want to learn what should be a basic dev skill. That said, criticizing all Python developers with this brush was very unfair.

cssanchez 4y ago

My issue with these awesome lists is that a lot of entries are out of date and may not even run anymore. The first entry, AnyMaestro's website has a news section last updated in 2016 (and it looks dated af), so why would I trust that tool with my DB credentials?

pvg 4y ago

Lists of things don't work that well as HN posts: https://hn.algolia.com/?dateRange=all&page=0&prefix=false&query=author%3Adang%20%22lists%20don%27t%22&sort=byDate&type=comment https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu...

srcreigh 4y ago

I don't trust this site since it doesn't include https://explain.dalibo.com/ https://explain.dalibo.com/

mgramin 4y ago
Thank you. Could you create PR or Issue with this tool?