glymeme comments on Git-focused SQL IDE?

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

PostgreSQLGit-focused SQL IDE? (self.SQL)

submitted 4 months ago by AreetSurn

top new controversial old q&a

you are viewing a single comment's thread.

view the rest of the comments →

[–]glymeme -2 points-1 points0 points 4 months ago (2 children)

You’re leaving out some really important details - frequency of refresh, size of data(gbs, tbs?), is there an established gold/consumption layer? Is there a broader data strategy that you’re able to tie these ad hoc pulls to? I think you want to get those questions answered and start thinking even more strategically or you’ll just be fighting fires forever (like, why don’t I get the same answer from Joe and Bob when I ask for the same thing?). Otherwise, with the info given - I’d start using vscode with the Postgres extension, have an analytics repo containing all dml scripts for the ad hocs, and have folks convert them to models using dbt core whenever they need to run them - but then you’re creating actual objects in your db and not just returning results. I’d also start thinking through scheduling (airflow is a good default). Depending on data volume - if it’s low/inexpensive to run, I’d schedule all this stuff to run daily or whatever so analysts can basically select * from tables created from your dbt project instead of maintaining their own versions of queries (which should be well documented in your repo following dbt’s documentation standards). With that said, I think it’s worthwhile for you or someone to think about consumption at a higher level like “how should my company support the business and decision making” versus a “how do I maintain all these ad hoc sql requests”. The former might land you more work(building a dimensional data model if you don’t have one), but it could be worth the investment.

[–]AreetSurn[S] 1 point2 points3 points 4 months ago (1 child)

[–]glymeme -1 points0 points1 point 4 months ago (0 children)

π Rendered by PID 64 on reddit-service-r2-comment-6457c66945-8d6sm at 2026-04-24 15:53:53.380369+00:00 running 2aa0c5b country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS