News

DEV Community
dev. to > cihanbir7 > im-building-osquil-a-schema-aware-query-workbench-for-osquery-4o8i

I'm building Osquil, a schema-aware query workbench for osquery

1+ hour, 28+ min ago  (589+ words) I've been working on Osquil, a schema-aware workbench for osquery. The first version is close, and before I publish it I want feedback from people who actually use osquery. osquery itself is great. Turning the OS into a queryable database…...

DEV Community
dev. to > juhi_singhal_7d7fb8634472 > 5-sql-interview-questions-that-trip-up-beginners-5cmi

5 SQL Interview Questions That Trip Up Beginners

1+ hour, 26+ min ago  (326+ words) If you're prepping for a tech interview, SQL usually feels "easy" until you're actually in the room. Here are 5 questions that look simple on paper but catch people off guard " plus quick explanations so you don't get caught out. The…...

DEV Community
dev. to > jungalung > tracking-tableau-viewership-with-postgresql-2l7c

Tracking Tableau Viewership with Postgre SQL

1+ hour, 43+ min ago  (922+ words) Tableau's native "Who has seen this view?" panel is a flat list " no trends, no way to tell if usage is real or just the publisher checking their own work. With direct access to the Tableau Postgre SQL repository, you…...

Symbols: otc:aalyf
DEV Community
dev. to > aman179102 > building-an-enterprise-grade-real-time-analytics-pipeline-with-fastapi-and-timescaledb-57al

Building an Enterprise-Grade Real-Time Analytics Pipeline with Fast API and Timescale DB

2+ hour, 26+ min ago  (102+ words) I just released v1. 0. 0 of an open-source, production-ready real-time analytics pipeline built with Python. Here's what it does and why you might care. Every Saa S product needs analytics " event tracking, real-time dashboards, time-series aggregations. Most teams either pay for Segment…...

Symbols: btc-usd
DEV Community
dev. to > datadriven > data-engineer-leetcode-what-to-grind-and-what-to-skip-4emk

Data Engineer Leet Code: What to Grind and What to Skip

4+ hour, 8+ min ago  (628+ words) I bombed it. Not because I wasn't prepared. Because I prepared for the wrong test. Let me save you some time. Here's the math that should make you angry: there are over 3, 000 problems on Leet Code. The vast majority test…...

Symbols: btc-usd
DEV Community
dev. to > maskdatabases > reading-your-data-layer-at-2-am-glass-box-vs-black-box-queries-57d1

Reading Your Data Layer at 2 AM: Glass Box vs. Black Box Queries

4+ hour, 12+ min ago  (234+ words) Debugging production issues often feels like a race against the clock, especially when it's 2 AM and a critical system is down. In these moments, the clarity of your codebase becomes paramount. This is particularly true for the data access layer,…...

Symbols: nasdaq:ddog
DEV Community
dev. to > albertomontagnese > text-to-sql-is-still-brittle-snowflakes-cortex-sense-is-a-new-take-2ahj

Text-to-SQL is still brittle. Snowflake's Cortex Sense is a new take.

6+ hour, 16+ min ago  (332+ words) The core problem with text-to-SQL is context, not syntax. Large language models are perfectly capable of writing SQL. What they lack is the deep, implicit knowledge of your business encoded in your database schema: which user_id joins to which account_id, what a…...

Symbols: nyse:snow
DEV Community
dev. to > martin_palopoli > typed-orm-with-automatic-migrations-fitz-vs-sqlalchemy-alembic-pydantic-3k1d

Typed ORM with automatic migrations: Fitz vs SQLAlchemy + Alembic + Pydantic

10+ hour, 19+ min ago  (608+ words) For a typed ORM with automatic migrations in Python you need to maintain 3 sources of truth (SQLAlchemy + Pydantic + Alembic). In Fitz it's ONE type with decorators. Plus 8" RPS and 5" less memory than SQLAlchemy in a reproducible benchmark. For each entity…...

Symbols: nasdaq:amzn,nasdaq:msft,nasdaq:googl
DEV Community
dev. to > martin_palopoli > orm-tipado-con-migraciones-automaticas-fitz-vs-sqlalchemy-alembic-pydantic-2lie

ORM tipado con migraciones autom'ticas: Fitz vs SQLAlchemy + Alembic + Pydantic

10+ hour, 19+ min ago  (624+ words) Para tener un ORM tipado con migraciones autom'ticas en Python necesit's mantener 3 fuentes de verdad (SQLAlchemy + Pydantic + Alembic). En Fitz es UN type con decoradores. Plus 8" RPS y 5" menos memoria que SQLAlchemy en bench reproducible. Para cada entidad de tu…...

Symbols: btc-usd,nyse:orcl,nasdaq:amzn,nasdaq:msft,nasdaq:googl
Cyber Security News
cybersecuritynews. com > north-korea-linked-hackers-hide-javascript-loaders

North Korea-Linked Hackers Hide Java Script Loaders in Open Source Repositories

12+ hour, 58+ min ago  (614+ words) A new wave of supply chain attacks is spreading across the open source world, and this time the target is developers themselves. Security researchers have uncovered a campaign called Polin Rider that hides malicious Java Script loaders inside trusted code…...

Symbols: index.js