Menu

#Sql

242 posts

Feed·
20 of 242 posts
Reddit - Please wait for verification
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/shredlegend·2 days ago
#T7Z5FVVi

Been working in sql for a long time and i created this tool which has been saving me tons of time and headache at my day to day. Check it out and let me know if you or your company might want a license submitted by /u/shredlegend [link] [comments]

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/TraumaBondage·2 days ago
#3fGkf5hd

Just had an interview with an employer that most people would consider a dream job and am nearly 100% sure I blew it. This is the only interview I've ever studied for. I did not apply to this role. An internal recruiter reached out to me.…

15s
Read More
Reddit - Please wait for verification
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/Nyrien_nml·2 days ago
#oOyzyzC4

Hi! I'm self-taught in programming and have never learned how to handle databases; I'm trying to run a FiveM server from this opensource code: https://github.com/SOZ-Faut-etre-Sub/SOZ-FiveM-Server and followed their explanations to migrate the database,…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/badboyzpwns·2 days ago
#ukMMs5on

For example here is the n+1 problem // 1 query to get all surveys const surveys = await db.query("SELECT * FROM surveys"); // then N queries — one per survey const results = await Promise.all( surveys.map(async (survey) => { const employee = await…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/Content-Berry-2848·2 days ago
#eDn2xC1E

Benchmarked SQLite write performance 11 ways and the result was not what I expected. The database wasn't the bottleneck. The ORM was. Raw sqlite3.executemany hits 88K r/s. SQLAlchemy caps at 3,800.…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/dbforge_dev·2 days ago
#FCtplGyR

Data drift is one of those issues that can look small at first but take much longer to track down than expected. A common case: staging and production schemas look the same, but a few reference tables have changed.…

15s
Read More
Reddit - Please wait for verification
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/debba_·2 days ago
#zqeF4q66

Hi everyone, Working with JSON/JSONB data inside relational databases is often a pain. Most database IDEs treat JSON fields as massive, unformatted text strings, forcing you to copy-paste them into external formatters just to understand what's going on.…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/PaidToSignUp·2 days ago
#jK0BPNap
#sql#reddit#photo#article#video#discussion

I just started learning SQL through an online course at Western Governors University The online course has so much technical jargon that really seems uneccessary but I've been learning the actual coding aspect on Youtube and using other platforms like…

15s
Read More
Reddit - Please wait for verification
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/Far-Special-245·2 days ago
#B4evYRoh

Hey everyone, we’ve been working on pgpulse (https://pgpulse.io), a Supabase-native PostgreSQL observability product, and I wanted to share one part of the thinking behind it and get feedback from people actually running apps on Supabase.…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/profichef·2 days ago
#ZLRLbdvC
#sql#reddit#photo#article#video#discussion

Hi everyone, I'm working on a small online store that sells gadgets - about 5-7 types of devices (smartphones, smartwatches, tablets, etc.). Nothing crazy big, but users need to filter by stuff like: battery life / capacity screen size (inches) display…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/Geno0wl·2 days ago
#wnxpcoAa
#sql#reddit#photo#article#video#discussion

Vendor decided for all newer versions of their software, which we need for compliance reasons, will no longer support MS SQL on-prem servers and everything is migrating to BigQuery.…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/Inventador200_4·2 days ago
#qb5WmKaM

I work part-time as a student on a supply chain analytics team (we use SAP ECC R/3) and my boss wants to stop using TXT/CSV batch jobs. Instead, they want to move SAP tables and Z-transaction data directly into a middle layer in SQL Server for reporting…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/Entire-Law-8495·2 days ago
#ah5KmhFJ

Hi all! I tagged this as oracle since I believe that’s the closest SQL format to PL/SQL. I tried to search this, but I’m not sure how to word it, so I’m not getting any hits. The data I’m looking at shows charges on an account.…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/komal_rajput·2 days ago
#CDO1Gv3m

We're building a data pipeline that processes FEC (Federal Election Commission) financial filing data. Each filing contains a parent record and thousands of itemization rows (individual transactions).…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/JLTDE·2 days ago
#az92Q89R

I have this query in Bigquery: SELECT column1, column2, count(*) FROM table GROUP BY column1, column2 HAVING COUNT(*) > 1 When I run it, I get no data as a result, so no duplicates in the table.…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/aimeos·2 days ago
#iIm2KTBS

MySQL used to be the fast one. Back in the 5.7 days, if you ran a typical website-style workload, MySQL would out-run heavier, fancier databases. Speed was its best reputation. According to our benchmark numbers, that reputation no longer matches reality.…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/AcadiaLow9013·2 days ago
#QUl8BaZY

Hey guys, I'm quite new in SQL, I learnt MySQL in college and we used the workbench. I'm building a DB for a project and since I have GitHub education, I have Jetbrains, so I can get DataGrip.…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/makadulla·2 days ago
#oGBsY8g1

Hey! I know there are options to generate a create script for one database in SSMS, but if I want to recreate a whole db server as close as possible with all databases, tables etc including permissions and so on, how can I do that?…

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/CaseyFoster_8542·2 days ago
#qwd3XqDY

When you're building a new database project, do you find yourself spending more time cleaning and preparing the data, or writing the actual complex queries? 🛠️ submitted by /u/CaseyFoster_8542 [link] [comments]

15s
Read More
📰
0

Reddit - Please wait for verification

News and Notes on the Structured Query Language·/u/Terrible-Review-4761·2 days ago
#kKqD4uIS
#sql#reddit#photo#article#video#discussion

Hi everyone, I recently moved into a Data Developer/Data Engineering role from a software development background, and I'm feeling a bit overwhelmed by the number of new technologies involved .…

15s
Read More