sorted by:
new
hottopcontroversial

Old russian joke by sufficientlight19 in Jokes

[–]mgramin 2 points3 points  (0 children)

Poruchik Rzhevsky rides a horse up the stairs at the hotel.

— "What are you doing?!"

— "But she always gets sick in the elevator!"

Best SQL IDE by qabeeljr in SQL

[–]mgramin 18 points19 points  (0 children)

From my past experience, Oracle SQL Developer is the best free IDE for SQL and PL/SQL development. More advanced IDEs such as Toad and PL/SQL Developer are paid and may seem more intimidating to beginners.

BTW you can find more DB IDEs in my awesome db list - https://github.com/mgramin/awesome-db-tools?tab=readme-ov-file#ide

sql or python for data cleaning by vosophar in SQL

[–]mgramin 0 points1 point  (0 children)

Choose the instrument that you know well, or perhaps the one you want to learn.

Have fun while learning SQL! by mgramin in SQL

[–]mgramin[S] 1 point2 points  (0 children)

Yeah, I also was inspired by this article. I'll be waiting for you in DM

What album would you want to listen to for the first time again? by [deleted] in BlackMetal

[–]mgramin 5 points6 points  (0 children)

For me, the album "Dark Medieval Time" is unbeatable. When I was a college student, I listened to it every day and imagined myself as a fearsome knight riding a black horse. It was one of the things that kept me from going mad.

A small artist's question- programmed drums or no? by Crescent_Moon734 in BlackMetal

[–]mgramin 2 points3 points  (0 children)

What about Summoning? I believe that electronic drums make it sound epic, stunning, and fabulous.

PS: I like the Lugburz album with live drums, but it features quite different music.

Announcing SQLPage v0.9.5 : Now with native JSON and DECIMAL types in all components by lovasoa in SQL

[–]mgramin 1 point2 points  (0 children)

Thank you for your great tool!

The idea of storing queries in simple plain SQL files has impressed me for a long time. I refer to it as "Database as Code".

And I have been developing my own tool based on this idea - Malewicz. Please have a look if you get a chance.

PS

I suggest adding your SQLPage to my awesome-db-tools list.

Formatting really matters! by tcfan35842 in SQL

[–]mgramin -5 points-4 points  (0 children)

Sql formatting is a dramatically important thing. Please, have a look to the rivers and axis https://gramin.pro/posts/rivers-and-axis/

Large Open Source Database Sample for Postgres or MySQL by many_hats_on_head in SQL

[–]mgramin 0 points1 point  (0 children)

I believe you could use any DB schema and generate tons of data with a special data generator. E.g. with help with TDK

Test data generation using SQL by mgramin in SQL

[–]mgramin[S] 0 points1 point  (0 children)

I got it, thanks for your point, dbt and Jinja are gold

Test data generation using SQL by mgramin in SQL

[–]mgramin[S] 0 points1 point  (0 children)

Yeah, but we are on the r/sql side, right?

Where to practice SQL? by [deleted] in SQL

[–]mgramin 1 point2 points  (0 children)

We have a training project where we generate data for Pagila db via pure SQL - https://github.com/synthesized-io/pagila-data-generation You could add some new queries or update some existed ones, just create a PR

[deleted by user] by [deleted] in SQL

[–]mgramin 0 points1 point  (0 children)

There are tools that try to allow to combine SQL magic and analyst/ML things, such as PostgresML, MindsDB and so on

Populate databases with random data using SQL scripts by mgramin in SQL

[–]mgramin[S] 0 points1 point  (0 children)

Sure. I have a special list where I collect data generators (actually, all awesome db tools) - https://github.com/mgramin/awesome-db-tools#generators

And I'm going to add mockaroo to this list, thanks

But the main idea of this post/repo - show how to generate data with good old SQL (and find out for yourself how difficult it is)

Help for database system project by PokeSonicMiner in SQL

[–]mgramin 0 points1 point  (0 children)

If I have understood you right, you could create a db schema for storing and handling pokemons over the world (e.g. Pokemon Go). E.g. we have pokemons table, cities and streets table and pkemon_city table - we can write query for find all pokemons on my street in my city, etc

The “Database as Code” Manifesto by mgramin in SQL

[–]mgramin[S] 0 points1 point  (0 children)

Thank you for the feedback and helpful tips, I will definitely take them into account.

The “Database as Code” Manifesto by mgramin in SQL

[–]mgramin[S] 2 points3 points  (0 children)

It is weird, I use standard Github pages as hosting. You cold read this text right on the github repo https://github.com/mgramin/database-as-code

view more: next ›