I am curious to know how SQLLite is used in corporate settings where data resides (in many cases it has to reside) in data lakes/warehouses cloud or otherwise. Is it more for personal learning purposes that SQLLite is used? Or, is it when consulting a client where data is sometimes shared as large files.
I haven't heard of SQLite to be used in corporate. It's not quite suitable for large companies due to it's limited database size and syntax.
I was using SQLite more as a "hack" solution to make it work when you have little time to solve a SQL challenge. But this was almost 3 years ago. Online SQL tools evolved a lot over the last years. TBH I wouldn't use it now. Here is my refreshed guide on the best ways to practice SQL - https://dataanalysis.substack.com/p/a-selection-of-sql-tutorials-issue-4dc
I am curious to know how SQLLite is used in corporate settings where data resides (in many cases it has to reside) in data lakes/warehouses cloud or otherwise. Is it more for personal learning purposes that SQLLite is used? Or, is it when consulting a client where data is sometimes shared as large files.
I haven't heard of SQLite to be used in corporate. It's not quite suitable for large companies due to it's limited database size and syntax.
I was using SQLite more as a "hack" solution to make it work when you have little time to solve a SQL challenge. But this was almost 3 years ago. Online SQL tools evolved a lot over the last years. TBH I wouldn't use it now. Here is my refreshed guide on the best ways to practice SQL - https://dataanalysis.substack.com/p/a-selection-of-sql-tutorials-issue-4dc