SQLite introduction

[MalihehMahlouji]

related to #1155

[netlify[bot]]

✅ Deploy Preview for unique-scone-f4eb67 ready!

Name	Link
🔨 Latest commit	052622f453e1654fbf2a0a31bbfb6dde4a57401a
🔍 Latest deploy log	https://app.netlify.com/sites/unique-scone-f4eb67/deploys/662ba93c233c4e00080eb09d
😎 Deploy Preview	https://deploy-preview-1166--unique-scone-f4eb67.netlify.app
📱 Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

---

To edit notification comments on pull requests, go to your Netlify site configuration.

[lachlandeer]

Hi @MalihehMahlouji

This looks like a good intro to using SQLite in R (as opposed to in the terminal/via pandas/ via some GUI)

Can you update the title and intro accordingly.

Then we can also think through future directions for new issues:

• more quick intros to database systems inside R / python etc (duckdb, mongo, etc)
• querying databases with dbplyr/dplyr and or python's pandas
• whether we want a section on SQL databases somewhat independently

i.e. i can see scope for a fully fleshed out set of articles (and I have some starting point we could work from lying around from a previous course I taught). but better to discuss in an issue

Thanks! L

[MalihehMahlouji]

Hi @lachlandeer,

Thanks for your feedback. I have added R in title and intro. Agree with your suggestions. I also mention in the article that for full database functionality it is best not to use SQLite. Therefore, there is a gap to explain e.g. PostgreSQL. Maybe after this we can close all the database issues hanging around and create another more concise one. Would you like me to do this and discuss? I would like to see your suggestion starting point.

Best, Maliheh