GitHub - hand-dot/supabase-rls-checker: Supabase RLS Checker is a Chrome extension that automatically verifies Row Level Security (RLS) settings for Supabase databases used by websites. It detects tables with disabled RLS settings that should be protectin
With the growing popularity of vibe coding, more people are now able to participate in service development. However, over the past few months, I've discovered and reported vulnerabilities across more than five websites, leading to the exposure of over 10,000 pieces of personal information, such as email addresses. During this process, it became clear that many services are being released without s
pg_duckdb - PostgreSQL プãƒã‚»ã‚¹ä¸Šã® DuckDB 㧠OLAP ワークãƒãƒ¼ãƒ‰ã‚’処ç†ã™ã‚‹
本記事ã®æ¦‚è¦ pg_duckdb ã¯ã€PostgreSQL ã®ãƒ—ãƒã‚»ã‚¹ä¸Šã§ã‚¤ãƒ³ãƒ—ãƒã‚»ã‚¹ OLAP クエリエンジンã§ã‚ã‚‹ DuckDB を実行ã™ã‚‹ãŸã‚ã®æ‹¡å¼µã§ã™ã€‚ DuckDB を利用ã™ã‚‹ã“ã¨ã§ã€ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚Šã¾ã™ã€‚ PostgreSQL ã®ãƒã‚¤ãƒ†ã‚£ãƒ–クエリエンジンã¨æ¯”ã¹ã€OLAP ワークãƒãƒ¼ãƒ‰ã‚’より高速ã«å‡¦ç†ã§ãる。 DuckDB ã®æ‹¡å¼µã‚’利用ã—〠Iceberg ã‚„ Delta lake ã¨ã„ã£ãŸã‚ªãƒ¼ãƒ—ンテーブルフォーマットã§ã‚ªãƒ–ジェクトストレージ上ã«æ§‹ç¯‰ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ¬ã‚¤ã‚¯ã®ãƒ‡ãƒ¼ã‚¿ã‚’分æžã§ãる。 本記事ã§ã¯ã€ PostgreSQL 拡張㮠pg_duckdb ã®æ¦‚è¦ã€ç§ãŒ pg_duckgb ã«æ³¨ç›®ã—ãŸèƒŒæ™¯ã€ãŠã‚ˆã³ç°¡å˜ãªä½¿ã„æ–¹ãªã©ã‚’紹介ã—ã¾ã™ã€‚ pg_duckdb ã®æ¦‚è¦ pg_duckdb ã¯ã€ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—ã® Hydraã€DuckDB 開発元㮠DuckDB Labsã€Sa
Prisma Postgres®: Building a Modern PostgreSQL Service Using Unikernels & MicroVMs
At Prisma, we believe that deploying a database should be as simple as adding a new page in Notion. Today, we are excited to share the first milestone towards this vision: Prisma Postgres® gives developers an always-on database with pay-as-you-go pricing — thanks to our unique architecture design. Try it now! TL;DR We are excited to announce Prisma Postgres, a managed PostgreSQL service that gives
å„SQLサーãƒã§OSコマンドを実行ã™ã‚‹æ–¹æ³•
sql-execute-os-command.md Defending new vectors: Threat actors attempt SQL Server to cloud lateral movement | Microsoft Security Blog SQLサーãƒã‹ã‚‰åˆ¥ã®ã¨ã“ã‚ã«ä¾µå…¥ã™ã‚‹ãƒ‘ターンã§ã€SQLサーãƒä¸Šã§OSã®ã‚³ãƒžãƒ³ãƒ‰ã‚’利用ã—ã¦ã‚‹ã‚±ãƒ¼ã‚¹ãŒå¢—ãˆã¦ã„る。 å„SQLサーãƒã§OSコマンドを実行ã™ã‚‹æ–¹æ³•ã‚’知りãŸã„。 Type How To Status SQL Server xp_cmdshell Disable by Default MySQL system (\!) Enable in Terminal PostgreSQL COPY Require pg_execute_server_program role Related Exploiting PostgreSQL
Postgres WASM by Snaplet and Supabase
And open a browser at localhost:3000. Features# Our demo version has a few neat features! Postgres 14.5, psql, pg_dump, etc. Save & restore state to/from a file. Save & restore Postgres state to/from the browser storage (IndexedDB). Quick start from a state file or fully reboot the emulator. Memory configuration options from 128MB to 1024MB. Adjust the font size for the terminal. Upload files to t
PgTyped - Node.jsã§åž‹å®‰å…¨ã«SQLを管ç†ã™ã‚‹ã«ã¯ | HiCustomer Lab - HiCustomer Developer's Blog
弊社HiCustomerã¯ã€2021å¹´ã®ã™ã”ã„ベンãƒãƒ£ãƒ¼100ã«é¸ã°ã‚Œã¾ã—ãŸã€‚å°ç”°ã§ã™ã€‚皆様今年もよã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ç›´è¿‘ã®å ±å‘Šã§ã™ãŒã€ç§ã¯ã¡ã‚‡ãã¡ã‚‡ãKafkaJSã¨éŠã‚“ã§ãŠã‚Šã¾ã™ã€‚ã‚‚ã†AWS SQSã‚„Cloud Pub/Subã«ã¯æˆ»ã‚Œãªã„身体ã«ãªã‚Šãã†ã§ã€ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’ã¿ã¦Confluent社ã®æ ªã‚’è²·ã£ã¡ã‚ƒã„ãã†ã§ã™ã€‚ギャンブラーã¨ã—ã¦All-inã—ã¡ã‚ƒãŠã†ã‹ãªðŸ˜œ 最近ã®Node.jsã®ORM事情ã«ã¤ã„㦠本題ã§ã™ãŒã€æœ€è¿‘SaaSã®æ–°è¦æ¡ˆä»¶ã‚’始ã‚る関係ã§ORM周りライブラリã®æŠ€è¡“調査をã—ã¦ã„ã¾ã™ã€‚ã¡ãªã¿ã«ç’°å¢ƒã¨è¦ä»¶ã¯ä»¥ä¸‹ã§ã™ã€‚ 環境ã¯ä»¥ä¸‹: データストアã¯PostgreSQL 言語ã¯TypeScript ラインタイムã¯Node.js è¦ä»¶ã¯ä»¥ä¸‹: スã‚ーマファーストã§å®Ÿè£…ã§ãã‚‹ å¯èƒ½ã§ã‚ã‚Œã°ã‚¹ã‚ーマを書ã„ã¦åž‹ã¨ã‚³ãƒ¼ãƒ‰ãŒç”Ÿæˆã§ãã‚‹ クエリã«å¯¾å¿œã™ã‚‹é–¢æ•°ã‚’ã„ã„æ„Ÿã˜ã«åž‹ä»˜ã‘ã§ãã‚‹ 複雑
GitHub - kysely-org/kysely: A type-safe TypeScript SQL query builder
Kysely (pronounce “Key-Seh-Leeâ€) is a type-safe and autocompletion-friendly TypeScript SQL query builder. Inspired by Knex.js. Mainly developed for Node.js but also runs on all other JavaScript environments like Deno, Bun, Cloudflare Workers and web browsers. Kysely makes sure you only refer to tables and columns that are visible to the part of the query you're writing. The result type only has th
Vercelã‹ã‚‰MySQL/PostgreSQLã«æŽ¥ç¶šã—ãŸã„å ´åˆã«ã©ã†ã„ã†ã‚¢ãƒ¼ã‚テクãƒãƒ£ã«ã™ã‚‹ã®ãŒæœ€é©ã‹
Issue Vercelã¸ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‹ã‚‰Serverless Functions ãŒå®Ÿè¡Œã•ã‚Œã‚‹ã¨æ–°è¦ã«DBã«æŽ¥ç¶šã—ã€çµ‚了時ã«ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’切æ–ã™ã‚‹ 一般的ãªã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ールを使ã£ãŸã‚¢ãƒ¼ã‚テクãƒãƒ£ã‚ˆã‚ŠDB接続コストã®å½±éŸ¿ã‚’å—ã‘ã‚‹ Amazon RDS Proxyã‚„Cloud SQL Proxyã®ã‚ˆã†ãªãƒ—ラットフォームãŒæ示ã™ã‚‹è§£æ±ºç–ãŒã¾ã ãªã„
ランã‚ング
ランã‚ング
メンテナンス
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
postgres.new: In-browser Postgres with an AI interface
GitHub - electric-sql/pglite: Embeddable Postgres with real-time, reactive bindings.
Goodbye to sequential integers, hello UUIDv7!
GitHub - sbdchd/squawk: 😠Linter for Postgres migrations & SQL
GitHub - supabase-community/postgres-language-server: A Language Server for Postgres
Snaplet
GitHub - kristiandupont/kanel: Generate Typescript types from Postgres
Validating PostgreSQL results & inferring query static types by Gajus Kuizinas
GitHub - oguimbal/pg-mem: An in memory postgres DB instance for your unit tests
[RFC] Decorators · Issue #14298 · sequelize/sequelize
GitHub - amacneil/dbmate: 🚀 A lightweight, framework-agnostic database migration tool.
GitHub - FerretDB/FerretDB: A truly Open Source MongoDB alternative
{{#tags}}- {{label}}
{{/tags}}