generatedata VS sakila

Since you will almost certainly need data to work on, I recommend generatedata.com.

Like this one I just found randomly. https://generatedata.com/

To play around with data generation and make a custom dataset I can recommend using — https://generatedata.com/. I’ve used it to generate 1🍋 records of the data. At the moment of writing this article, the basic yearly plan costs 25$ and you would not regret it.

good morning, I should populate my db with fake data and I tried generatedata.com and mockaroo.com but they both have limits on the number of rows (500 and 1000 respectively). Do you know of any site/software that allows me to produce fake data of 5000/10000 rows at a time? Thanks in advance

When im doing basic test I usually use https://www.mockaroo.com/ or https://generatedata.com/ they are a bit general bit they are awesome when you need to test queries, load performance.

You could create a list with one of the random data generators. Like https://generatedata.com/

It's done all the time in demonstrations, training, prototyping... There's entire websites for it

If you need something to anonymize the data, go here.

FROM yugabytedb/yugabyte:latest # get Sakila DDL and DML scripts ADD https://github.com/jOOQ/sakila/raw/main/yugabytedb-sakila-db/yugabytedb-sakila-schema.sql . ADD https://github.com/jOOQ/sakila/raw/main/yugabytedb-sakila-db/yugabytedb-sakila-insert-data.sql . # Start YugabyteDB to run the scripts RUN yugabyted start \ && until ysqlsh -h $(hostname) -c "create database sakila" ; do sleep 1 ; done | uniq \ && ysqlsh -h $(hostname) -d sakila -f yugabytedb-sakila-schema.sql \ && ysqlsh -h $(hostname) -d sakila -f yugabytedb-sakila-insert-data.sql \ && yugabyted stop \ && rm -f /root/var/data/yb-data/*/wals/table-*/tablet-*/index.* # starting a container can re-start YugabyteDB ENTRYPOINT yugabyted start --background=false

The script only contains INSERT statements, you apparently did not create the table and sequences before you ran that script. You need to run the script to create the schema first: https://github.com/jOOQ/sakila/blob/main/postgres-sakila-db/postgres-sakila-schema.sql

Then downloading the database https://github.com/jOOQ/sakila (has a ERD to help you write your queries as well)