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

SQG (SQL to Code Generator) v0.10: Java Streams and List Type Support

sqg.dev

Post reply on HN
Print view View original

1–9 of 9 posts

Re: SQG (SQL to Code Generator) v0.10: Java Streams and List Type Support

#2

Post by DarkNova6 »

Neat! Even-though they should probably use a custom type rather than the generic "Stream" to communicate that this needs to be closed. Or remove the try-with-resource block if closing is not necessary.

This way it leaves some room for misinterpretation.

Re: SQG (SQL to Code Generator) v0.10: Java Streams and List Type Support

#3

Post by uwemaurer »

DarkNova6 wrote: post #2

Neat! Even-though they should probably use a custom type rather than the generic "Stream" to communicate that this needs to be closed. Or remove the try-with-resource block if closing is not necessary. This way it leaves some room for misinterpretation.

Thank you for the suggestion!

Re: SQG (SQL to Code Generator) v0.10: Java Streams and List Type Support

#6

Post by vbilopav »

This was my first approach in realizing my PostgreSQL-centric, Db-first, or rather SQL-first vision of software development.

The project was call pgroutiner and it generated bunch of C# code for me out of PostgreSQL.

After doing couple of projects with it, I realized it wasn't enough. The new approach is a dynamic HTTTP REST API generation but, with plugin for code generation of frontend files (Typescript,. Javascript, HTTP files). This iw way better approach. Look it up, it's called npgsqlrest.github.io

Re: SQG (SQL to Code Generator) v0.10: Java Streams and List Type Support

#7

Post by nixon_why69 »

vbilopav wrote: post #6

This was my first approach in realizing my PostgreSQL-centric, Db-first, or rather SQL-first vision of software development. The project was call pgroutiner and it generated bunch of C# code for me out of PostgreSQL. After doing couple of projects with it, I realized it wasn't enough. The new approach is a dynamic HTTTP REST API generation but, with plugin for code generation of frontend files (Typescript,. Javascrip…

How often is this approach useful? Why not just send the SQL to the DB and get the records you need, do you have big collections of records in memory?
Post reply on HN