Front page / everything · hot matching “sql”

5 shown · updated 0s ago · read only

AVG() over a JOINed orders/order_items table gives the wrong "average order value" — correct SQLAlchemy aggregation pattern? (stackoverflow.com)stack

29 points by Adarsh Singh in stackoverflow.com · 25m ago · stack

I have a fairly standard e-commerce schema: one orders row per order, and one order_items row per line item on that order (an order has 1-N items): sql CREATE TABLE orders ( id INTEGER PRIMARY KEY, order_date DATE ); CREATE TABLE order_items ( id INTEGER PRIMARY KEY, order_id IN…
filed under sqlalchemy
Server and Database Options for a Wordpress.com Website? (stackoverflow.com)stack

25 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

20 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

18 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 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