ideas

  • SQLAlchemy VS Pandas VS Pyspark VS SQL comparison

plan for my “Learn in public, JUST DO IT!”

I try to learn every day and write it down. It will be my journey if you are interested on my advanteger you are more then wolcome.. I will write every day, writing as a habit FCK every day!!!

  • TODO: post creation process

  • WIP: socials:
    • TODO: dev.to + medium, write Hello POST about pycon,
    • WIP: continue with linkedin
    • HOLD: x.com & threads, stop, don’t do too much
  • WIP: topics: python - basics, pandas, pyspark, numpy, sklearn, code review for ds, ml- summary

  • DONE: simplest, cheapest tools: github + markdown, markdown template for blog post, generate it- 2023-01-12-title.md every day

articles

https://www.swyx.io/learn-in-public https://dev.to/blackgirlbytes/how-to-learn-in-public-1coh

challlenges:

Communication is the key <3

communication is the key

achievements

  • Wrote about Pycon on Linkedin. At least!!! People have been waiting for it since NOVEMBER XD
  • Did my post on blog <3
  • create account on dev.to

learning

[PROGRAMMING] START USING DOCS NOT GOOOLE IT !!!! DOCS <3

  • Pandas
  • SQLAlchemy

[SQLAlchemy] What is the difference between .one() and .first() and what is .one_or_none()?

https://stackoverflow.com/questions/29161730/what-is-the-difference-between-one-and-first

[SQLAlchemy] What is the difference between .filter .where and what is filter_by?

A synonym for Query.filter(). https://stackoverflow.com/a/31560897/7092449

[SQLAlchemy] start using select not query

https://stackoverflow.com/questions/72828293/difference-between-sqlalchemy-select-and-query-api “This page contains the Python generated documentation for the Query construct, which for many years was the sole SQL interface when working with the SQLAlchemy ORM. As of version 2.0, an all new way of working is now the standard approach, where the same select() construct that works for Core works just as well for the ORM, providing a consistent interface for building queries.

For any application that is built on the SQLAlchemy ORM prior to the 2.0 API, the Query API will usually represents the vast majority of database access code within an application, and as such the majority of the Query API is not being removed from SQLAlchemy. The Query object behind the scenes now translates itself into a 2.0 style select() object when the Query object is executed, so it now is just a very thin adapter API. “

inspiration:

[SOCIALS]

  • Piotr Skalski for his social skillset
  • and of course shout out to Tiangolo for his socials skillset

<
Previous Post
YML Python Fullstack Developer
>
Next Post
STEP TWO