jump to:all–mastodon–bluesky–lemmy–lobsters–dev–stack–wiki–rss–hn

Tech / Stack Overflow · hot matching “sql”

3 shown · updated 12s ago · read only

How to create an AND expression with SqlAlchemy ORM select? (stackoverflow.com)stack

28 points by Helping1908 in stackoverflow.com · 9m ago · stack

I have a SQL Alchemy ORM model called Customer class Customer(BaseModel): __tablename__ = "customer" id: Mapped[str] = mapped_column(String(64), default=str_uuid, primary_key=True) name: Mapped[str] = mapped_column(String(128)) email: Mapped[str] = mapped_column(String(64)) dele…
filed under python sqlalchemy
What is the difference between .one() and .scalar() (stackoverflow.com)stack

5 points by Syed mohamed aladeen in stackoverflow.com · 7y ago · stack

What is the main difference between .one() and .scalar() in SQLAlchemy, as both doing the same jobs. I saw some sites like tutorialpoint.com but that explanation is not enough for me to understand clearly
filed under python sqlalchemy flask-sqlalchemy
What is the recommended way to encrypt user passwords in a database? (stackoverflow.com)stack

1 points by szabgab in stackoverflow.com · 16y ago · stack

In a web application written in Perl and using PostgreSQL the users have username and password. What would be the recommended way to store the passwords? Encrypting them using the crypt() function of Perl and a random salt? That would limit the useful length of passswords to 8 c…
filed under perl security postgresql