Knowledge / Stack Overflow · hot matching “sql”

4 shown · updated 9s ago · read only

Prisma (ORM) migration command hangs open indefinitely on port 6543 instead of finishing (stackoverflow.com)stack

27 points by Ryadh Own in stackoverflow.com · 29m 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 open…
filed under postgresql prisma
Improving the SELECT query performance on a large table in SQL Server (stackoverflow.com)stack

7 points by HOY in stackoverflow.com · 13y ago · stack

Q: How can I improve the performance of my queries ? Details: I have one table with 200k records (Sales) and one function getView_sls(@TON_orNPS) Below query takes 10-12 seconds SELECT * FROM Sales Below query takes 32-34 seconds SELECT * FROM getView_sls('TON') Below is my sale…
filed under sql performance t-sql sql-server-2005 query-performance
How to convert the Long value to String using sql (stackoverflow.com)stack

6 points by vijayboli in stackoverflow.com · 13y ago · stack

I am doing a long to string conversion using java in following way. Long longValue = 367L; String str = Long.toString(longValue, 36).toUpperCase(); this is returning me as value A7. how can achieve this in doing oracle sql. UPDATED: Hi, I have analyzed how java code is working t…
filed under plsql
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