惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

D
DataBreaches.Net
F
Fortinet All Blogs
D
Docker
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
WordPress大学
WordPress大学
罗磊的独立博客
Y
Y Combinator Blog
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
J
Java Code Geeks
T
The Blog of Author Tim Ferriss
U
Unit 42
N
Netflix TechBlog - Medium
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
V
V2EX
云风的 BLOG
云风的 BLOG
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
T
Tailwind CSS Blog
Hugging Face - Blog
Hugging Face - Blog
Stack Overflow Blog
Stack Overflow Blog
爱范儿
爱范儿
酷 壳 – CoolShell
酷 壳 – CoolShell
P
Proofpoint News Feed
G
Google Developers Blog
H
Help Net Security

Hacker News - Newest: "AI"

AI can't read an investor deck AI as an attorney? Student uses ChatGPT, Gemini to sue UW over alleged racial discrimination Hacking MCP Servers in AI Systems – The Rug Pull: Tool Changes After Approval GitHub - MeepCastana/KubeezCut: Free Web based video editor Can AI judge journalism? A Thiel-backed startup says yes, even if it risks chilling whistleblowers Coming soon: 10 Things That Matter in AI Right Now DARPA built an AI to fact-check enemy weapons claims What explains heterogeneity in AI adoption? When AI Meets Muscle: Context-Aware Electrical Stimulation Promises a New Way to Guide Human Movements - Department of Computer Science AI Changed How We Build. It Did Not Change What Matters. Linux rules on using AI-generated code - Copilot is OK, but humans must take 'full responsibility for the… Meta spins up AI version of Mark Zuckerberg to engage with employees Code Mode: Let Your AI Write Programs, Not Just Call Tools | TanStack Blog GitHub - Delavalom/graft: Go framework for building AI agents. Type-safe tools, multi-provider (OpenAI, Anthropic, Gemini, Bedrock), zero vendor SDKs. India's TCS tops estimates, says new AI models did not dent services demand Gen Z's fading AI hype Strong feeling: we are in a folded AI reality GitHub - machinarii/total-recall-catalog: A reference catalog of latest knowledge retrieval, memory & RAG systems GitHub - mensfeld/code-on-incus: Give each AI agent its own isolated machine with root, Docker, and systemd. Active defense detects and stops threats automatically.. Quantization, LoRA, and the 8% Problem: Benchmarking Local LLMs for Production AI Iran war: We spoke to the man making Lego-style AI videos that experts say are powerful propaganda Powell, Bessent discussed Anthropic's Mythos AI cyber threat with major U.S. banks GitHub - immartian/bellamem: Persistent belief-graph memory for AI agents. Retrieves decisive context by importance — not recency, not RAG, not /compact. recursive-mode: The Repo-Native Operating System for AI Engineering After the attack on Sam Altman's home, will AI CEO's go on the offensive? The biggest advance in AI since the LLM Opus 4.6 vs GPT 5.4 One Prompt Unity World Generation Test “AI polls” are fake polls Client Challenge Can AI be a 'child of God'? Inside Anthropic's meeting with Christian leaders
SQL + AI on Your Database
itrummer · 2026-06-20 · via Hacker News - Newest: "AI"

samtSQL

Semantic Analytics on Multimodal Tables

Run SQL with AI on your cloud database.

samtSQL lets you write SQL with AI operators over text, images, audio, and tables stored in your existing PostgreSQL database.

Example Average price of modern, roomy houses that visibly have a pool

HouseAds Illustrative rows

id city year br price photo

1 Oshawa, ON 2008 4 $565,000 Brick two-story suburban home with a double garage on an autumn street

2 Marbella, ES 2015 4 $875,000 Modern white villa with sliding glass doors and a narrow blue swimming pool in the foreground

3 Yellow Springs, OH 1942 2 $310,000 White clapboard cottage with a covered front porch and autumn trees

4 Alicante, ES 2018 5 $1,120,000 Contemporary two-story villa with a large rectangular swimming pool in front

5 Marblehead, MA 1908 5 $780,000 Traditional gray-shingle coastal home with a wraparound porch and manicured lawn

SELECT AVG(price)
FROM HouseAds
WHERE year_built > 1980
  AND bedrooms >= 3
  AND AIFILTER(photo, 'the house has a pool');

Result $997,500 avg. over rows 2 and 4

How it works

Connect and query

Step 1

Connect your existing PostgreSQL database.

Step 2

Upload CSV or ZIP files containing images, audio, or text data.

Step 3

Run SQL with AI operators using REST API or visual interface.

Data support

Supported data types

Ingest and analyze mixed data workloads in one environment.

Tables

Standard SQL data types including text, integers, floating-point values, and Booleans.

Images

AI analysis over common image formats such as JPEG and PNG.

Text

Document and free-text analysis stored directly in relational tables.

Sound

Analyze audio files such as MP3 and WAV with AI operators.

Query intelligence

Supported AI operators

Express analytical intent in natural language while staying in SQL.

AIFILTER

Filter multimodal data with natural-language conditions.

AICLASSIFY

Classify records with label names only.

AISCORE

Assign scores based on natural-language criteria.

AIMAP

Transform or extract information with natural-language instructions.

AIJOIN

Join datasets using semantic matching rules defined in natural language.

File formats

Supported file formats

Each uploaded format is available as a first-class input for SQL + AI workflows.

CSV

Structured tabular uploads for relational analysis.

ZIP

Archive container for mixed multimodal assets.

JPG

Compressed image format for visual analysis tasks.

PNG

Lossless image format with high visual fidelity.

GIF

Image format supported for uploaded media datasets.

WEBP

Modern web image format for compact storage.

MP3

Compressed audio format for speech and sound data.

WAV

Uncompressed audio format for detailed signal quality.

Pricing

AI Credits + daily compute time

Every plan unlocks the full SQL + AI operator set on PostgreSQL. Each plan bundles a monthly allotment of AI Credits for LLM usage and a per-day allowance of query compute time.

View Full Plan Details

Basic

$9 / month

  • 3 AI credits per month
  • 30 minutes compute per day*
  • Best for occasional exploration

Choose Basic

$29 / month

  • 15 AI credits per month
  • 120 minutes compute per day*
  • Best for regular analytics workflows

Choose Standard

Professional

$99 / month

  • 75 AI credits per month
  • 480 minutes compute per day*
  • Best for heavier workloads

Choose Professional

*Daily compute time resets at 00:00 UTC.

Examples

SQL + AI use cases

Switch between representative use cases and inspect each SQL pattern with syntax highlighting.

Finding complaints in survey comments

Count customers who mention pricing concerns in free-text responses.

SELECT COUNT(*)
FROM SurveyResults
WHERE AIFILTER(Comments, 'the customer complains about the price');

Classifying image collections

Tag uploaded holiday images with semantic classes in one query.

SELECT AICLASSIFY(pic, 'beach picture', 'city visit', 'other')
FROM HolidayImages;

Transcribing uploaded audio

Turn MP3 clips stored in your tables into plain-text transcripts with one query.

SELECT AIMAP(content, 'Transcribe this audio into plain text.') AS transcript
FROM AudioClips
WHERE filename LIKE '%.mp3';

Ranking sentiment in reviews

Sort comments by positivity score to prioritize outreach.

SELECT *
FROM SurveyResults
ORDER BY AISCORE(Comments, 1, 10, 'Positivity');

Summarizing customer-support tickets

Condense long tickets into short summaries for triage.

SELECT AIMAP(ticket_body, 'Summarize the customer issue in two sentences')
FROM SupportTickets;

Entity matching across product catalogs

Match equivalent products from independent datasets with semantic joins.

SELECT *
FROM ProductDB1 P1, ProductDB2 P2
WHERE AIJOIN(P1.productName, P2.productName, 'this is the same product');

Documentation and guided tutorials

Read endpoint-by-endpoint API docs, operator specs, and practical tutorials for both the visual interface and Python REST clients.