Tech / everything · hot matching “sql”

5 shown · updated 1s ago · read only

Server and Database Options for a Wordpress.com Website? (stackoverflow.com)stack

27 points by First Last in stackoverflow.com · 47m ago · stack

I made a website with Wordpress, hosted by Wordpress. I need my website to be able to access and use data from a database and I have tried multiple options and there have been issues with each one. Wordpress Default MySQL Server- The database access is locked in a higher tier an…
filed under php mysql wordpress azure mariadb
How to create an AND expression with SqlAlchemy ORM select? (stackoverflow.com)stack

22 points by Helping1908 in stackoverflow.com · 1h 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
Prisma (ORM) migration command hangs open indefinitely on port 6543 instead of finishing (stackoverflow.com)stack

17 points by Ryadh Own in stackoverflow.com · 3h ago · stack

I am runing Prisma migrations for a NestJS application connected to a Supabase PostgreSQL database. When I run npx prisma migrate dev --name init (or deploy) using the connection string with port 6543, the command doesn't fail, throw an error, or time out; instead, it hangs inde…
filed under postgresql prisma
What is the difference between .one() and .scalar() (stackoverflow.com)stack

7 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