Need a database to practise queries optimizing

[patent hornet]

Hi guys! I would like to practice optimizing SQL queries, and I need a database on which to practice. Maybe someone has scripts to create and populate a database with a big amount of data or dump of a postgresql database.

[quartz raptor]

<@&987246584574140416> please have a look, thanks.

[minor hazel]

https://www.databasetestdata.com/

[magic kite]

Or

why not just create a db yourself?

well it depends of what you want to put inside

[patent hornet]

I need a large amount of data in the db. I will have to spend a lot of time to generate it by myself

[patent hornet]

good

[patent hornet]

but i don't see the functionality for creating relationships between tables ☹️

[magic kite]

Depends of what you want

if you want random data

you can easily generate it yourself in minutes

[agile forum]

I generally just set up datafaker to create fake entities in bulk.

[patent hornet]

At most random data. But good to have relationships between tables. Do you know the way how to do this?

[magic kite]

Your requirement are vague

Why not just do it

it should take just 30min

[patent hornet]

Yes 😊 I just counting on someone who have complete scripts or db and share it with me. But apparently I have to create it myself.

[magic kite]

you have to understand what you are asking

you are asking to create a tool to create tables

and then insert records in them

you are literally asking for sql

[onyx delta]

Dang, I wish I had my tool more ready so you could use it but this is literally what I built it for. You define the database schema in yaml format and then you can generate fake data (uses datafaker under the hood). Literally built for this purpose. +1 for datafaker though. If you want lots of fake data to insert into a database, datafaker can definitely help

[quartz raptor]

@patent hornet

Your question has been closed due to inactivity.

If it was not resolved yet, feel free to just post a message below
to reopen it, or create a new thread.

Note that usually the reason for nobody calling back is that your
question may have been not well asked and hence no one felt confident
enough answering.

When you reopen the thread, try to use your time to improve the quality
of the question by elaborating, providing details, context, all relevant code
snippets, any errors you are getting, concrete examples and perhaps also some
screenshots. Share your attempt, explain the expected results and compare
them to the current results.

Also try to make the information easily accessible by sharing code
or assignment descriptions directly on Discord, not behind a link or
PDF-file; provide some guidance for long code snippets and ensure
the code is well formatted and has syntax highlighting. Kindly read through
https://stackoverflow.com/help/how-to-ask for more.

With enough info, someone knows the answer for sure 👍