Hi Bryan, your videos are really good. I would like to know if there is a way to get the .db file and send it to the database with all the tables (SQL Server or Postgres)
Noticed when 'Huang' was changed to 'Jones' and marital status changed from 'Single' to 'Married' that the 'ETLlastupdate' was NOT modified to current. ?
True. ETLLastUpdate will be assigned a value on insert or must be explicitly assigned a value on Update. The Insert/Replace statement should delete and re-insert the row on an update which will give it a new date/time value. Good observation.
Thanks for the video. Maybe I missed it but I couldn’t find the follow up video explaining the use of UPSERT in SQLite. Could you please point me to the video where it’s covered? Thanks
YW. Hmmm... Not sure. But I cover it nicely as part of this recent video, i.e. when storing the API results to SQLite. th-cam.com/video/PLeusjAj5RE/w-d-xo.html
@@BryanCafferky Brilliant! Thanks Bryan. Two notes. 1. It’d be interesting to see an explanation of when to use and when not to use the “connection.cursor “in SQLite. I’m not sure when it’s needed if the inserts can be done with just “sqlite3.connection”. 2. Let me know if you’re shopping for ideas on future videos. I got a real life scenario for a potential data pipeline that would involve technologies like Prefect/Airbyte, dbt, SQLite and Clickhouse. I don’t want to impose so if you’re interested to make an educational video about it, I’d be happy to expand on details and the use case
@@kuatroka Using pandas lets you get away without the cursor sometimes. Here's a blog on using SQLite cursor. Your project sounds interesting but I try to keep my videos general enough to be of interest to a fairly broad audience. Data engineers limit my audience a lot as it is but I may do some of those technologies.
This year I saw so many video. yours is the best one. really thank you!
can't wait for read your book!!
@@a225855305 Thank you!
I've been needing to really grok sqlite for a while, good choice of topic!
It's such a great tool to have in Python but it has some nuances.
Can't wait to read your book Bryan!
Thanks and if you like it. Please leave a review on Amazon!
Hi Bryan, your videos are really good. I would like to know if there is a way to get the .db file and send it to the database with all the tables (SQL Server or Postgres)
Noticed when 'Huang' was changed to 'Jones' and marital status changed from 'Single' to 'Married' that the 'ETLlastupdate' was NOT modified to current. ?
True. ETLLastUpdate will be assigned a value on insert or must be explicitly assigned a value on Update. The Insert/Replace statement should delete and re-insert the row on an update which will give it a new date/time value. Good observation.
Thanks for the video. Maybe I missed it but I couldn’t find the follow up video explaining the use of UPSERT in SQLite. Could you please point me to the video where it’s covered? Thanks
YW. Hmmm... Not sure. But I cover it nicely as part of this recent video, i.e. when storing the API results to SQLite. th-cam.com/video/PLeusjAj5RE/w-d-xo.html
@@BryanCafferky Brilliant! Thanks Bryan. Two notes. 1. It’d be interesting to see an explanation of when to use and when not to use the “connection.cursor “in SQLite. I’m not sure when it’s needed if the inserts can be done with just “sqlite3.connection”.
2. Let me know if you’re shopping for ideas on future videos. I got a real life scenario for a potential data pipeline that would involve technologies like Prefect/Airbyte, dbt, SQLite and Clickhouse. I don’t want to impose so if you’re interested to make an educational video about it, I’d be happy to expand on details and the use case
@@kuatroka Using pandas lets you get away without the cursor sometimes. Here's a blog on using SQLite cursor.
Your project sounds interesting but I try to keep my videos general enough to be of interest to a fairly broad audience. Data engineers limit my audience a lot as it is but I may do some of those technologies.
@@BryanCafferky thanks Bryan