PostgreSQL

PostgreSQL에 대해 3개 실제 데이터 소스에서 22개 공개 신호를 찾았습니다. GitHub 10건, Hacker News 2건, arXiv 10건을 원문 링크와 함께 보여줍니다.

관심도 점수

100

검색 slug
postgresql
실제 연결
Hacker News, GitHub, arXiv
키워드
and, the, postgresql, for, that, with, llm, its
마지막 수집
2026-11-21T07:12:12.556Z

출처별 탭

PostgreSQL 19

hackernews · 2026-11-20 · score 383 · comments 10

Does a Self-Learning Migration Agent Learn? An Audited Evaluation of Evidence-Graded Experience Memory for Oracle-to-PostgreSQL Migration

Do large language model (LLM) migration agents learn from accumulated experience, or do apparent gains reflect retrieval and reference reuse? We evaluate an evidence-graded agent for Oracle-to-PostgreSQL migration across four studies. On 1,833 documentation-derived source-reference pairs, persistent memory improved reference conformity (RC) over a no-memory baseline by 0.015 [0.004, 0.025], while policy adaptation added no gain (-0.004 [-0.010, 0.001]). An audit found that 264 of 367 held-out units (72%) shared a...

arxiv · 2026-11-12

Probe-Based Routing for Join Optimizer Selection

In optimizers that choose a join-order solver by a size rule, join ordering is an algorithm-selection problem, because dynamic programming (DP), genetic search (GEQO), and Monte Carlo tree search (MCTS) each win on different queries. PostgreSQL nevertheless chooses among them by relation count alone, although queries with the same relation count can favor different solvers. This paper introduces two landscape features that a probe computes from random join orders in microseconds per query. The tail spacing $α$ des...

arxiv · 2026-11-11

Agents Propose, Code Verifies, Humans Decide: Verified Agentic Ingestion of Heterogeneous Scientific Tables into Relational Databases

Public scientific datasets rarely arrive analysis-ready. They arrive as messy folders of wide matrices, long tables, spreadsheets, and per-cohort files whose keys and encodings differ, and every reanalysis must reconnect them first. A coding agent can automate this, but its mistakes can look plausible, and without an audit trail, a mistake that corrupts data can go uncaught. We present an AI-assisted ingestion pipeline built on one rule: LLM agents propose, deterministic code verifies, and humans decide. Narrow ag...

arxiv · 2026-11-08

When Is One Query per Template Enough? Adapting Learned Cost Models to New Hardware

A learned cost model that predicts query runtimes is trained on measurements from one machine. When the database moves to other hardware, its plans stay the same but their runtimes change, each by its own factor. We ask how to adapt such a model from k queries measured on the new machine: which queries to run, how to use their runtimes, and how many are enough. On PostgreSQL we timed the same plans of 1,162 TPC-H and TPC-DS queries in six environments: a laptop and a server, each with all its processors or pinned...

arxiv · 2026-11-04

Post-SQLFix: Property-Guided Repair of LLM-Generated SQL with Runtime Verification

Large Language Models (LLMs) for Text-to-SQL frequently generate queries with syntax errors, invalid identifier references, or violations of SQL scoping and typing rules. Repairing these errors is a program correctness problem, yet existing approaches rely on Execution Feedback (EF), whose symptom-level, dialect-specific error messages force the LLM to speculate on root causes. We identify an Arbitration Paradox in this paradigm: the system relies on unverified models both to propose repairs and to make the final...

arxiv · 2026-10-30

When the Application Layer Is Disposable: Putting Integrity Constraints Back in the Database

Integrity constraints have been central to the relational model since its inception. However, beyond keys, single-row CHECKs, and referential integrity, most constraints are enforced by application layers today. SQL ASSERTIONs, standardized in SQL-92, remain poorly supported by major RDBMSs. This has become increasingly unacceptable due to two developments. First, LLM-driven applications and agents increasingly issue queries and updates directly against databases, bypassing application layers where invariants resi...

arxiv · 2026-10-26

A Multi-Domain Study on the Effectiveness of LLMs at Writing Property-Based Tests

A property-based test (PBT) checks a property of a program on many generated inputs, but writing one takes a property, a generator of valid inputs, and an oracle. LLM-based PBT writers produce all three, yet they have been evaluated only on Python libraries. We study how two of them, Proptest-AI and Agentic-PBT, generalize to ten programs in five domains: deep learning libraries, databases, system software, compilers, and LLM serving engines. Most of these programs take text in their own language, such as queries,...

arxiv · 2026-10-25

VeriEvolve: Evaluator-First Evolution for Tool-Using Agents

A central obstacle to self-improving agents is the absence of a reliable fitness signal for realistic stateful tasks. We introduce \textsc{VeriEvolve}, an evaluator-first evolution framework that constructs this missing evaluation layer before optimizing the agent. From task instruction, VeriEvolve synthesizes instruction-grounded challenge states and an executable evaluator that checks them. During each round of workflow evolution, the evaluator is frozen and serves as the fitness signal. Between rounds, VeriEvol...

arxiv · 2026-10-21

MultiCard: Multiple Attribute Cardinality Estimation via Deep Learning

Cardinality estimation is essential for query optimization, but most existing learned estimators focus on a single predicate type, such as string LIKE clauses or numerical range filters. In practice, analytical workloads often combine both types, while the accuracy of string estimators tends to decrease with longer patterns. We introduce MultiCard, a comprehensive learned cardinality estimator that unifies LIKE predicates and numerical filters within a single end-to-end architecture. By combining a Transformer for...

arxiv · 2026-10-19

Beyond Leaderboards: A Method for Application-Specific Capability Profiling of Large Language Models

Public leaderboards rank large language models (LLMs) in general, but an engineer has to choose a model for a specific application, architecture and cost. This paper presents a method for application-specific capability profiling of LLMs and its realization as a containerized testbed. The method treats each application as a unit of extension: an Oracle-to-PostgreSQL migration agent, a documentation-grounded chatbot or an enterprise-support automation agent runs in its own container behind a small contract, brings...

arxiv · 2026-10-19

maybe-finance/maybe

The personal finance app for everyone

github · 2024-01-01 · score 54,189 · comments 0 · stars 54,189 · forks 5,667

twentyhq/twenty

The open alternative to Salesforce, designed for AI.

github · 2022-12-01 · score 60,874 · comments 135 · stars 60,874 · forks 10,076

makeplane/plane

🔥🔥🔥 Open-source Jira, Linear, Monday, and ClickUp alternative. Plane is a modern project management platform to manage tasks, sprints, docs, and triage.

github · 2022-11-19 · score 62,397 · comments 1,152 · stars 62,397 · forks 6,392

calcom/cal.diy

Scheduling infrastructure for absolutely everyone.

github · 2021-03-22 · score 49,994 · comments 1,635 · stars 49,994 · forks 15,633

supabase/supabase

The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.

github · 2019-10-12 · score 114,961 · comments 1,202 · stars 114,961 · forks 15,135

nocodb/nocodb

🔥 🔥 🔥 A Free & Self-hostable Airtable Alternative

github · 2017-10-29 · score 65,521 · comments 577 · stars 65,521 · forks 5,137

dbeaver/dbeaver

Free universal database tool and SQL client

github · 2015-10-21 · score 52,422 · comments 3,355 · stars 52,422 · forks 4,452

metabase/metabase

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

github · 2015-02-02 · score 50,311 · comments 4,691 · stars 50,311 · forks 7,005

netdata/netdata

The fastest path to AI-powered full stack observability, even for lean teams.

github · 2013-06-17 · score 81,392 · comments 445 · stars 81,392 · forks 6,731

discourse/discourse

A platform for community discussion. Free, open, simple.

github · 2013-01-12 · score 48,081 · comments 317 · stars 48,081 · forks 9,064