HISTORY近 30 天历史柱高表示当天去重热搜数量
52029459305183148801342022403631045740556506627075300864109620105751151512522136321462815650165741754718514195252058821615226102368224627256292634127
08/29—09/27 有历史数据
- 01Oracle SQL: SQL Statement Classifications1. SQL Statement Classifications SQL statements are categorized based on their functional purpose within the database architecture: Data Manipulation Language (DML): Retrieves data from the database, enters new rows, changes existing rows, and removes unwanted rows from tables in the database. Commands: SELECT , INSERT , UPDATE , DELETE , MERGE NOTE: While SELECT is frequently categorized under DML in training curricula (including Oracle University), it is formally classified as Data Query LanguSANDEEP KUMAR
- 02Oracle SQL: Essential Environment CommandsSET DEFINE OFF Purpose: Controls whether SQL*Plus and SQL Developer interpret the ampersand ( & ) as a substitution variable prefix or as a literal character. Interview Insight: Critical for script automation and data migration—failing to toggle this off in automated deployment scripts will cause pipeline execution to hang indefinitely while waiting for user input on strings containing & (e.g., 'AT&T' or URL parameter strings). SET DEFINE OFF ; UPDATE endpoints SET url = 'https://example.com/apiSANDEEP KUMAR
- 03pg_restore finished fine. One of my tables wasn't there.A restore test on a real 105-table Supabase database failed a few weeks ago. The tool doing it restores in a strict mode, so it stopped on the first error: a function with a parameter defaulting to auth.uid() . Fixing that was quick. The interesting part came when I reproduced it locally with plain pg_restore , the way most people test a backup by hand. There it didn't stop at all. It ran to the end, and one table simply wasn't there. Here's why, how to reproduce it in two minutes, and the few lSuperLede
- 04PDF Toolkit Where Your Files Can't Leave the Browser (and the CSP Enforces It)Think about the last time you merged two PDFs online. You dragged a bank statement, a lease or a scan of your passport into a website, it "processed" the file, and you downloaded the result. Where did the file go in between? Usually it went to someone else's server, and all you have is their word that they deleted it. I wanted a tool where that question has a boring answer, so I built Dokwise : 16 PDF and image tools (merge, split, compress, OCR, protect, compare, scan-to-PDF, e-signature and moGaurang
- 05Building VirgoFash: A Lightning-Fast, Zero-Dependency Async Python Search & RAG EngineAs developers building AI applications, retrieval-augmented generation (RAG) pipelines, and intelligent agents, we often face a frustrating trade-off: we either rely on heavy, bloated scraping frameworks that slow down our event loops, or we write brittle, custom HTTP parsing code from scratch. That exact frustration led to the creation of VirgoFash—a lightweight, zero-dependency asynchronous search and answer engine built entirely in pure Python. In this article, we’ll explore why VirgoFash wasAbdullah Jahangir
- 06Claude tự chạy regression test app Flutter của mình trong lúc mình ngủHồi trước mình làm ở một công ty ví điện tử màu hồng ở Việt Nam. Ở đó anh leader giới thiệu cho mình một tool viết automation test khá hay tên là Maestro. Ảnh chỉ mình cách xài, và đó là lần đầu mình biết code automation test cho mobile app, rồi test e2e trông như thế nào. Phải nói là Maestro làm quá tốt. Cài đặt dễ, inspect element dễ, viết flow cũng đơn giản hơn hẳn mấy công cụ team QC đang dùng lúc đó. Mình thật sự ấn tượng. Nhưng môi trường product thì việc ai nấy làm. Mình gần như không cóDangNguyen
- 07
When Redis goes down, does your app die?The Problem: The App Dies There was an incident that caused our application to fail because our Redis cache went down. It was in the middle of moving to a larger compute instance to handle a higher load, and since we only had one replica at the time, the cache became completely unavailable. The issue is that Laravel, by default, assumes your cache is always there. If Redis dies, the standard Cache::remember throws an exception and crashes the request with a 500 Internal Server Error. While it'sjantolentino - 08Using fstab instead of autofs for a samba shareA few weeks ago, I borrowed a Raspberry Pi 4B from a friend. Since it wasn't going to be used for a while, I decided to set up a network storage for our home network. It seemed like the most practical use for the Pi. The Problemo Everything was working great until today. After a quick look at the service status, here's what I was dealing with: Sep 14 03:06:13 homeserver systemd[1]: Starting smb.service - Samba SMB Daemon... Sep 14 03:06:14 homeserver systemd[1]: Started smb.service - Samba SMB Djantolentino
- 09
Uptime Kuma on Fedora with Podman QuadletOver the weekend, I decided to set up Uptime Kuma on my mini-server. I needed a quick way to monitor some important work services, and Uptime Kuma’s Slack notifications make it easy to get alerts directly in our channel whenever something goes down. While I was at it, I figured it was the perfect time to learn Podman Quadlet . I have recently learned as a neat way to manage containers using declarative files (similar to Kubernetes YAML) that automatically generate systemd services so your apps sjantolentino - 10Testing scheduled jobs using faketimeRecently, I was tasked with testing some scheduled exports to investigate a defect. Unit tests should have caught it, but something else was going on. I had to simulate a real execution in a container by faking its internal clock. This is where I utilized faketime . faketime is a tool that manipulates system time for a specific program without changing the system's actual time. It works by intercepting the system calls a program makes to get the current date and time, allowing you to run programjantolentino
- 11Suspend, Background, DisownI'm currently working on a hobby project, using crawlers to download media files for a dataset. Some of these are large files that also need preprocessing. Instead of building a whole system to manage this, I'm just creating simple scripts to handle them one at a time. Given the volume of data I'm working with, I realized the scripts were going to take a long time to run on my mini-server. So, I needed to run them as background processes. In the past, I've always relied on nohup or tmux for thisjantolentino
- 12
PostgreSQL Generated Column vs Trigger: Which to Use for a Derived ColumnDisclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Use a generated column when the value comes from other columns in the same row through immutable functions, because the database guarantees it and nobody can write to it. Use a trigger only when the value needs another table, the current time, or a function PostgreSQL does not call immutable. On PostgreSQL 18 a generated column is virtual unless you write STORED , and a virtual oneSon Tran