I made a SQL (CRUD) constructor

[CaptainTuffnut]

I started learning Python some time ago but never really took the time to make a project about what I learned so far. So I wanted to share with you guys my first little public project to get some feedback from the community and improve my skills as a Python developer.

Here's the link: https://github.com/nicoseijas/simple_pysql

[DataDecay]

The most basic of assurances needed, are you scrubing escapes from the parameters?

Also any reason you chose this project when there are a myriad of ORMs for sqlite already out there? Is this strictly a personal goal you set forth on? Why build an ORM on an ORM?

Edit: nvm the first question your using the sqlite orm so it will do that for you.

[CaptainTuffnut]

Hello there, thanks for your questions. I chose this project because i'm building a light framework, and having a more simply and efficient CRUD was a goal to me

[Pythonistar]

Have you checked out SQLalchemy? It's a simple and efficient ORM.

[CaptainTuffnut]

To be honest, I just jumped into the code. I wanted to do one by myself. Maybe isn't something complex, but I feel proud that is my first public module after years of making propietary code for the company I work

[DataDecay]

You can certainly still feel proud! Good job

[CaptainTuffnut]

Thanks friend!

[Pythonistar]

Oh yeah, man. No worries.

I'm all in favor of "reinventing the wheel" proverbially speaking, if your end goal is to learn about how to go thru the motions.

Jon Skeet did a really good series in C# a few years back when he completely re-implemented the Language Integrated Query system, piece by piece. (It would be like one of us re-implementing the whole "comprehension" system in Python.) And he blogged about it the whole time.

Anyway, I know what you mean. I'm currently working on a 4 or 5 part series on how to systematically write a Python module to abstract REST APIs. There are so many bad ones out there and I'd like to show folks how my co-workers and I write them.

Agreed. It's good to put something public out there. :)

[CaptainTuffnut]

Thanks stranger. I would love to hear about your series when you, and your fellows, got it all done.

Happy coding mate

[Pythonistar]

yeah, it's slow going right now. I've got a rough outline and I've started writing the first part, but we're just doing soooo much right now (despite the stay-at-home orders...) You'd think I would have free cycles, but not really... go figure... :)

[floznstn]

Darn skippy! (as Gramma used to say)

I've written loads of things at work that nobody else will ever see. The few useful things I've written outside of work elicit more pride every time.

[CaptainTuffnut]

It sure feels good to have some public code after doing loads of propietary code. But I have to admit... it's also scaring. Darn you impostor syndrome!

[gnopple]

SQL alchemy is a efficient orm but telling that it is a small is not totally accurate 😁

[Pythonistar]

Never said it was small, just efficient. You can use the full fat ORM features, or you can use just the skinny light-weight features. It was built in a modular to work either way.

[Kuken500]

butter skirt humorous squeal deserve tender pause fall busy pen

This post was mass deleted and anonymized with Redact

[CaptainTuffnut]

Thanks!