背景 pgxman这个项目尝试做成一个共享项目, 大家可以根据模板写出yaml文件, 把PG插件的编译脚本集中后, 由pgxman来管理插件. 参考: - https://github.com/pgxman/pgxman - https://pgxman.com/ With pgxman, we’ve streamlined the installation process to one simple step: run pgxman install [extension name]. pgxman integrates with the system package manager, ensuring the correct versions are installed without extra packages from any shared dependencies between extensions. pgxman’s automated build system creates APT packages for each Postgres version, platform, and OS supported by the extension. [阅读全文]

背景 以2023 12月16日杭州 国产数据库共话未来趋势 活动回放观看链接为例子： 公开课-国产数据库共话未来趋势 - （上午场）回放观看地址：https://live.csdn.net/room/wl5875/owIpOavL 国产数据库共话未来趋势 - （下午场）回放观看地址：https://live.csdn.net/room/wl5875/JCVcH6E4 参考方法 超简单！- 用m3u8下载网页视频，直接保存为mp4 - https://www.bilibili.com/video/av379250963/?vd_source=99924f14467ad349bc135d24f48790cf 下载利器: - 猫抓：https://github.com/xifangczy/cat-catch/releases - 特殊书签：https://nilaoda.github.io/N_m3u8DL-CLI/GetM3u8.html - m3u8下载器：https://github.com/nilaoda/N_m3u8DL-CLI/releases - m3u8下载网站：http://blog.luckly-mjw.cn/tool-show/m3u8-downloader/index.html - Downie 4 - 《macOS 破解dmg下载利器: appstorrent , 视频流媒体下载利器: Downie 4》 第一步, 使用chrome 浏览器获得xhr链接 1、使用chrome打开回放观看地址链接 - https://live.csdn.net/room/wl5875/owIpOavL 2、打开chrome的菜单: 更多工具 - 开发者工具 3、在开发者工具中点击: 网络/Network 搜索: m3u8 过滤选择: Fetch/XHR 4、ctrl+R 刷新当前页面 5、选中过滤出来的xhr, 右键点击: 复制 - 链接地址 出现了2个xhr. 5.1、一个是mp4文件的下载地址: - https://vlive-bj.csdnimg.cn/e09d83589bc471eeaf9e4531948c0202/03733aad9ff1458bb76415e90f1ccf72.m3u8 拷贝以上链接到 Downie 4, 下载. [阅读全文]

背景 https://github.com/dolthub/doltgresql DoltgreSQL - Version Controlled PostgreSQL 一款兼容PostgreSQL协议, 支持数据库版本管理(类似给数据库的schema打快照, 有版本变更记录)的数据库. 支持的PostgreSQL语法、类型还比较有限. DoltgreSQL is Dolt for Postgres! From the creators of Dolt, the world’s first version controlled SQL database, DoltgreSQL (aka Doltgres) is a Postgres-flavored version of Dolt. Doltgres offers all the Git-style log, diff, branch, and merge functionality of Dolt on your Postgres database schema and data. Instead of connecting with a MySQL client and using MySQL SQL, you connect to Doltgres with a Postgres client and [阅读全文]

背景 https://github.com/PostgREST/postgrest REST API for any Postgres database https://supabase.com/blog/postgrest-12 PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch. Sponsors Big thanks to our sponsors! [阅读全文]

背景 https://github.com/sunng87/pgwire PostgreSQL wire protocol implemented as a rust library. 适合需要编写兼容PostgreSQL交互协议的服务的场景. 例如cockroach数据库的交互协议. pgwire Build Postgres compatible access layer for your data service. This library implements PostgreSQL Wire Protocol, and provide essential APIs to write PostgreSQL comptible servers and clients. This library is a work in progress and in its relatively early stage. There is no guarantee for API stability. I’m constantly introducing break changes during [阅读全文]

背景 https://github.com/supabase/supavisor A cloud-native, multi-tenant Postgres connection pooler. Supavisor - Postgres connection pooler Overview Motivation Architecture Docs Features Future work Acknowledgements Benchmarks Inspiration Overview Supavisor is a scalable, cloud-native Postgres connection pooler. A Supavisor cluster is capable of proxying millions of Postgres end-client connections into a stateful pool of native Postgres database connections. For database managers, Supavisor simplifies the task of managing Postgres clusters by providing easy configuration of highly available Postgres clusters (todo). [阅读全文]

背景 https://github.com/shayonj/pg_easy_replicate Easily setup logical replication and switchover to new database with minimal downtime pg_easy_replicate pg_easy_replicate is a CLI orchestrator tool that simplifies the process of setting up logical replication between two PostgreSQL databases. pg_easy_replicate also supports switchover. After the source (primary database) is fully replicated, pg_easy_replicate puts it into read-only mode and via logical replication flushes all data to the new target database. [阅读全文]

背景 https://supabase.com/blog/pg-graphql-postgres-functions Postgres functions Consider a function addNums for a basic arithmetic operation: create function "addNums"(a int, b int default 1) returns int immutable language sql as $$ select a + b; $$; when reflected in the GraphQL schema, the function is exposed as: type Query { addNums(a: Int!, b: Int): Int } To use this entry point, you could run: query { addNums(a: 2, b: 3) } which returns the JSON payload: [阅读全文]

背景 某音，我不得不把你卸载, 因为你知道我太多秘密. 大家都知道抖音的算法牛掰, 看过什么就推荐你什么. 让你越看越依赖, 越用越久, 他的广告费却赚得盆满钵满, 你说气不气人, 该不该卸载. 比如我看过王祖贤, 刘亦菲的小视频, 你就不断给我推, 咋地, 怕全天下不知道我喜欢王祖贤, 刘亦菲拍的倩女幽魂啊? 家里领导一发现, 一吃醋, 榴莲都不够用, 关键榴莲还要我买, 吃确没我的份. 所以把某音卸载还不解恨, 我还要掀桌子. 你的推荐算法不是牛吗, 你不是很丝滑吗? 我让你算法牛, 让你懂我, 让你丝滑. 今天, 我要把你的核心推荐算法按在地上摩擦, 把这个算法的门槛降低到地板难度. 让所有人都能用上, 让天下冒出无数个某音的友商, 卷死你. 算法的核心 1、给视频贴标签. 简单, 阿里云就有类似的视频服务, 可以完成涉黄赌毒、暴力、zz敏感等的识别过滤, 以及根据特征打标. 并给出视频标签s, 以及每个标签对应的权重. 2、刷新视频的推荐指数. 简单, 根据 浏览量 * 各标签的权重 计算出视频的各标签的推荐分数. 3、视频的地域池设计. 简单, 要让本地的好视频可以有上升到全国推荐的池子, 同时要让付费的广告主的视频有VIP通道(推荐特权): 设计三个池: 本地视频池(geohash, table_suffix. 或者以邮编, 或电话区号为后缀.)、全国流量池、付费推荐视频池 - 说白了就是视频浏览量越多, 就把视频放到更大的池子里. 池子的个数, 级别可以根据业务需求自由设计. 4、用户喜好和权重计算. 简单, 1方面是注册的时候勾选喜好, 另一方面是根据用户浏览的视频的(主、副标签及权重, 算出用户每个标签的喜好). [阅读全文]

背景 昨天佛爷在数据库群里起哄, 怎么用SQL解决24点问题, 当然先问AI, 结果ChatGPT看了都摇头. 挑起了数据库风雅之士的兴趣, 真的是江山代有才人出, 各领风骚数百年. 首先出场的是德哥, 果然是风流倜傥七步杀一人, 1分钟内解决战斗: - 使用PG plpython一个函数搞定. 如下, 非常简单. 可以使用我的地表最强PostgreSQL学习镜像来体验. U-4G77XXWF-1921:~ digoal$ docker run -d -it -P --cap-add=SYS_PTRACE --cap-add SYS_ADMIN --privileged=true --name pg --shm-size=1g registry.cn-hangzhou.aliyuncs.com/digoal/opensource_database:pg14_with_exts_arm64 0af92301ec9d7355155f737336bae23acb12dac43d2f11de4aeeaec201b7323d U-4G77XXWF-1921:~ digoal$ docker exec -ti pg bash root@0af92301ec9d:~# psql psql (14.10 (Debian 14.10-1.pgdg110+1)) Type "help" for help. postgres=# create language plpython3u; CREATE EXTENSION postgres=# CREATE OR REPLACE FUNCTION solve_24_game(num1 INTEGER, num2 INTEGER, num3 INTEGER, num4 INTEGER) RETURNS SETOF TEXT AS $$ import itertools def solve_24_game(num1, num2, num3, num4): nums = [num1, num2, num3, num4] operators = ['+', '-', '*', '/'] perms = itertools. [阅读全文]