Querying SQLite databases with DuckDB

In this video, we'll learn how to query the European Soccer SQLite database with DuckDB.

#sqlite3 #duckdb

[hansdietrich]

Thanks for your videos. I had discovered duckdb lately. First thing to do was some data import from mysql, which turned out more annoying than I expected. In the end I used pandas, converted every single table from the mysqldb into a parquet file and then used duckdb on it. If you know a smarter and faster way, I'd be glad to hear.

[kwesikwaa]

thanks for the video. i just came to know about duckdb today. would you say it can be used as the main database? and what advantages would that have.
also can be play the role redis plays in the sense of instead of hitting the main db on every request, requests hit the duckdb instead?

[gw]

Hi Mark, Can you explain why querying sqlite from duckdb? I feel your tutorial focused more on how less on why. Would help if you tell us the use-case, Thank you

[ravishmahajan]

But the question is why would anyone do that? Why would query from DuckDB if i can directly query from SQLite😊
Do we have a strong use case?
Second question is i don't get it what is the need to have DuckDB at first place? Is is another database like Snowflake or Redshift?
I am asking these questions so that i can convince my clients. 😊