I share I did write up an algorithm for it at some point I think it is lost in a git comment someplace. I’ll put together a pseudo/go code this week.

Super simple:

Making a reply:

1. If yarn has one use that. (Maybe do collision check?)
   
2. Make hash of twt raw no truncation.
   
3. Check local cache for shortest without collision
   
   • in SQL: select len(subject) where head_full_hash like subject || '%'
     

Threading:

1. Get full hash of head twt
   
2. Search for twts
   
   • in SQL: head_full_hash like subject || '%' and created_on > head_timestamp
     

The assumption being replies will be for the most recent head. If replying to an older one it will use a longer hash.

Hiring: Senior Backend Golang | Remote (Brazil) | A new challenge awaits!
What are we looking for?

• 5+ years of experience in software engineering.
  
• Proven experience with Golang and building production-ready services.
  
• Strong knowledge of cloud technologies, specifically AWS.
  
• Experience with SQL databases such as Postgres, DynamoDB, or MongoDB.
  
• Expertise in microservices architecture and design.
  
• Proficiency with containerization tools such as Docker and orchestration tools like Kubernetes.
  
• S … ⌘ Read more

Go 語言與 SQL 數據庫的交互方式
Go 語言作爲一門簡潔高效的語言，在與關係型數據庫交互方面也擁有着豐富的選擇。本文將深入探討 Go 語言中幾種常見的與 SQL 數據庫交互方式，並通過示例代碼、優缺點分析和擴展知識點，幫助你更好地理解和選擇適合你的方案。Go 語言與 SQL 數據庫交互的常見方式———————Go 語言標準庫提供了database/sql包，它是一個基礎的 SQL 數據庫驅動接口，爲各種 ⌘ Read more

https://www.teotimepacreau.fr/blog/modelisation-base-de-donnees/ #sql

你是如何用 Go 語言 配置高性能 sql-DB 的？
配置高性能的 sql.DB 是 Go 應用程序開發中一個重要的環節，特別是在需要處理大量數據庫查詢的情況下。以下是一些最佳實踐和配置建議：1. 數據庫連接池的配置Go 的 database/sql 包提供了連接池的功能，您可以通過設置最大空閒連接、最大打開連接數和連接的最大生命週期來優化連接池。db, err := sql.Open(“mysql”, ”user:password@tcp(127. ⌘ Read more

Golang - range 迭代器揭祕
簡介我們正在使用 Go 語言編寫 Dolt[1] ，這是世界上第一個版本控制的 SQL 數據庫。像大多數大型 Go 代碼庫一樣，我們有很多需要迭代的集合類型。 Go 1.23 的新特性 [2] 中，你現在可以使用 range 關鍵字來迭代自定義集合類型。這是如何工作的? 這是個好主意嗎? 讓我們深入探討一下。如果你想運行本教程中的任何代碼，你需要 安裝 Go 1.23 發佈候選版 [3] ，或者在 ⌘ Read more

SQL simplifies TSDB – how to migrate from InfluxQL to SQL
Member post originally published on Greptime’s blog by tison This article introduced the differences between InfluxQL, Flux, and SQL as query languages. SQL is a more common and general language for querying time series data, making migrating from… ⌘ Read more

Golang 編寫範型集合，官方文檔未提及的訣竅
引言–Go 的泛型功能在 Go 1.18 版本中發佈, 至今已有兩年多了。我們正在使用 Go 開發 Dolt[1] , 這是世界上第一個支持版本控制的 SQL 數據庫。儘管我們有數十萬行 Go 代碼, 但我們並沒有大量使用泛型。我們在一些地方使用泛型 來加速代碼中的高流量部分 [2] , 但總的來說, 除了 slices[3] 和 maps[4] 包中的一些有用的庫方法外, 我們還沒有找到使用泛 ⌘ Read more

https://drawdb.vercel.app/ database design tool and SQL generator

Go 語言主流 ORM 框架對比：GORM vs- Ent
GORM 和 Ent 是 Go 語言中使用廣泛的兩種 ORM（對象關係映射）框架。它們都有助於將數據庫操作從底層 SQL 抽象出來，簡化數據庫交互，但它們的設計理念和使用方式有顯著的不同。本文將詳細介紹 GORM 和 Ent 的不同特點、使用示例，並比較它們在不同場景下的優劣。GORM 簡介——-GORM 是一個易於使用的 ORM 庫，旨在提供簡單、乾淨的 API。它通過反射機制動態處理數 ⌘ Read more

Gorm 源碼解析
我們先通過一張圖來看 Gorm 核心主流程。gorm 主流程1. 初始化 DB 連接—————-使用 database.sql 初始化連接。我們平時所說的數據庫驅動其實就是每個數據庫對 DSN 不同的解析方式，最終底層都是使用的 TCP 建立起數據庫連接。type Connector interface { Connect(context.Context) (Conn, err ⌘ Read more

sqlx: 功能強大的數據庫訪問庫
sqlx[1] 是一個用於擴展標準庫 database/sql 的庫，它提供了一些額外的功能，使得在 Go 中使用 sql 更加方便。sqlx 的目標是保持 database/sql 的簡單性，同時提供更多的功能。sqlx 爲 Go 的標準 database/sql 庫提供了一組擴展。sqlx 中的 sql.Conn、sql.DB、sql.TX、sql.Stmt、sql.Rows、sql.Row ⌘ Read more

Golang 如何實現自定義 CDC 工具？
CDC變更數據捕獲（CDC）是一種跟蹤數據庫更改的技術，允許開發人員捕獲應用於行的插入、更新和刪除。它是數據集成和實時處理任務的重要組成部分。在本文中，我們將討論如何在 Golang 中爲 PostgreSQL、Oracle、MySQL、MongoDB 和 SQL Server 等多個數據庫開發自定義 CDC 工具。通常在 CDC 領域或者說大數據領域都是 java 的生態比較繁榮，比如 Flin ⌘ Read more

Goose：Go 語言漸進式的數據庫遷移工具
數據庫遷移是軟件開發過程中重要的一部分，隨着業務的發展和需求的變化，數據庫結構經常需要做出調整。Goose 是一個出色的數據庫遷移工具，它通過 SQL 腳本和 Go 函數支持漸進式的數據庫變化。下面是一篇詳細的文章，它將深入介紹 Goose 的用法，並提供豐富的示例幫助你開始使用 Goose。Goose 簡介——–Goose 是一款能夠管理數據庫架構變更的工具，提供了一系列命令來幫助開發 ⌘ Read more

Golang: 打造一個交互式命令行
Go 非常適合於構建命令行應用程序。我們構建了一個名爲 Dolt 的應用, 它是世界上第一個支持版本控制的 SQL 數據庫。我們爲處理 Dolt 的所有子命令和參數編寫了自己的命令行解析器, 但也許我們不應該這樣做。現在有很多很棒的工具可以替代我們自己編寫的解析器, 如果我們今天開始這個項目, 我們可能會選擇使用它們:spf13/cobra 提供了從簡單的文本命令格式生成代碼的強大支持, 並且可以 ⌘ Read more

ProcessOne: ejabberd 23.04
This new ejabberd 23.04 release includes many improvements and bug fixes, as well as some new features.

Image

• Many SQL database improvements
  
• mod_mam support for XEP-0425: Message Moderation
  
• Newmod_muc_rtbl, Real-Time Block List for MUC rooms
  
• Binaries useErlang/OTP 25.3, and changes in containers
  

A more detailed explanatio … ⌘ Read more

收到請求數據的常用安全驗證方案，go 語言，gin 框架
在使用 Gin 框架處理前端請求數據時，必須關注安全性問題，以防範常見的攻擊。本文將探討 Gin 框架中常見的安全問題，並提供相應的處理方法，以確保應用程序的穩健性和安全性。第一章：概述———-1.1 安全性的重要性處理前端請求數據時，確保應用程序的安全性是至關重要的。常見的攻擊方式包括 SQL 注入、跨站腳本攻擊（XSS）、跨站請求僞造（CSRF）等。下面我們將逐一探討這些問題及其處 ⌘ Read more

💻 Issue 400 - ScalaSql: a New SQL Database Query Library for the com-lihaoyi Scala Ecosystem ⌘ Read more

ProcessOne: ejabberd 22.10
This ejabberd 22.10 release includes six months of work, over 140 commits, including relevant improvements in MIX, MUC, SQL, and installers, and bug fixes as usual.

Image

This version brings support for latest MIX protocol version, and significantly improves detection and recovery of SQL connection issues.

There are no breaking changes in SQL schem … ⌘ Read more

ProcessOne: ejabberd 23.04
This new ejabberd 23.04 release includes many improvements and bug fixes, as well as some new features.

Image

• Many SQL database improvements
  
• mod_mam support for XEP-0425: Message Moderation
  
• Newmod_muc_rtbl, Real-Time Block List for MUC rooms
  
• Binaries useErlang/OTP 25.3, and changes in containers
  

A more detailed explanatio … ⌘ Read more

ProcessOne: ejabberd 23.04
This new ejabberd 23.04 release includes many improvements and bug fixes, as well as some new features.

Image

• Many SQL database improvements
  
• mod_mam support for XEP-0425: Message Moderation
  
• Newmod_muc_rtbl, Real-Time Block List for MUC rooms
  
• Binaries useErlang/OTP 25.3, and changes in containers
  

A more detailed explanatio … ⌘ Read more

Prosodical Thoughts: Prosody 0.12.3 released
We are pleased to announce a new minor release from our stable branch.

This is a bugfix release for our stable 0.12 series. Most notably, it fixes a
regression for SQL users introduced in 0.12.2, and a separate long-standing
compatibility issue with archive stores on certain MySQL/MariaDB versions.

It also fixes an issue with websockets discovered by the Jitsi team, some
issues with our internal HTTP client API, and we’ve improved the accuracy of
‘prosodyctl check dns’ in … ⌘ Read more

The CIA invests in these Tech companies
Video games. Search engines. Social Media. Open Source. Even SQL databases. Seriously. ⌘ Read more

Bitwarden Unified
Bitwarden (my favorite and recommended password manager) is offering a “new deployment option”. This new option combines all microservices into a single Docker container and doesn’t require 11 different containers anymore. And it supports PostgreSQL and MariaDB in addition to MS SQL. ⌘ Read more

it uses the queries you define for add/del/set/keys. which corrispond to something like INSERT INTO <table> (key, value) VALUES ($key, $value), DELETE ..., or UPDATE ...

the commands are issued by using the maddycli but not the running maddy daemon.

see https://maddy.email/reference/table/sql_query/

the best way to locate in source is anything that implements the MutableTable interface… https://github.com/foxcpp/maddy/blob/master/framework/module/table.go#L38

ProcessOne: ejabberd 22.10
This ejabberd 22.10 release includes six months of work, over 140 commits, including relevant improvements in MIX, MUC, SQL, and installers, and bug fixes as usual.

Image

This version brings support for latest MIX protocol version, and significantly improves detection and recovery of SQL connection issues.

There are no breaking changes in SQL schem … ⌘ Read more

ProcessOne: ejabberd 22.10
This ejabberd 22.10 release includes five months of work, over 120 commits, including relevant improvements in MIX, MUC, SQL, and installers, and bug fixes as usual.

Image

This version bring support for latest MIX protocol version, and significantly improves detection and recovery of SQL connection issues.

There are no breaking changes in SQL schem … ⌘ Read more

Thanks for the feedback! This site was designed to look perfect on good old 800x600 monitors (I even left a comment next to the meta tag). Maybe I’ll add a mobile-friendly version someday :-) P.S. Nice try with SQL injection, haha. Do you have any plans for XSS attacks? :D

ProcessOne: ejabberd 22.05
A new ejabberd release is finally here! ejabberd 22.05 includes five months of work, 200 commits, including many improvements (MQTT, MUC, PubSub, …) and bug fixes.

Image

– Improved MQTT, MUC, and ConverseJS integration

– New installers and container

– Support Erlang/OTP 25

When upgrading from the previous version please notice: there are minor changes in SQL schemas, the included rebar and reba … ⌘ Read more

ProcessOne: ejabberd 22.05
A new ejabberd release is finally here! ejabberd 22.05 includes five months of work, 200 commits, including many improvements (MQTT, MUC, PubSub, …) and bug fixes.

Image

– Improved MQTT, MUC, and ConverseJS integration

– New installers and container

– Support Erlang/OTP 25

When upgrading from the previous version please notice: there are minor changes in SQL schemas, the included rebar and reba … ⌘ Read more

sqlite3 fiddle
With all my SQL and SQLite posts, this link is probably also quite interesting: sqlite3 fiddle. ⌘ Read more

“Common Table Expressions in SQL”
I’m currently working in a project that involves a lot of data processing and therefore databases. This means that we often come into contact with SQL at work and have to write an SQL query at least once a day. ⌘ Read more

ProcessOne: ejabberd 22.05
A new ejabberd release is finally here! ejabberd 22.05 includes five months of work, 200 commits, including many improvements (MQTT, MUC, PubSub, …) and bug fixes.

• Improved MQTT, MUC, and ConverseJS integration
  
• New installers and container
  
• Support Erlang/OTP 25
  

When upgrading from the previous version please notice: there are minor changes in SQL schemas, the included rebar and rebar3 binaries require Erlang/OTP 22 or higher, and make rel uses different paths. There are no break … ⌘ Read more

** My programming language odyssey **
While I wouldn’t say I’m wicked adept at any one language, I’ve dipped my toes into many different languages. Here, I try to roughly recreate my programming language journey.

The web. A marvel, a terror. I started here, more out of ease of access than necessity, but was able to get far enough to make a career out of web dev. I should also add SQL to this list.

[Elm](https://elm-lang … ⌘ Read more

“Friendlier SQL with DuckDB”
I come into contact with SQL almost every day, be it at work (Oracle Database) or while developing my blog software (SQLite). I don’t find SQL as bad as some others might, but sometimes SQL could be better. ⌘ Read more

Thinking beyond SQL injection: OWASP tips for secure database access
When it comes to secure database access, there’s more to consider than SQL injections. OWASP Top 10 Proactive Control C3 offers guidance. ⌘ Read more

Prosodical Thoughts: Prosody 0.11.13 released
We are pleased to announce a new minor release from our stable branch.

This is a(nother!) release for our stable branch to fix a memory leak caused
by the security fix. Deployments using websockets, SQL storage and possibly
other configurations may have noticed increasing memory usage after upgrading
to 0.11.12. This is resolved by this new release.

A summary of changes in this release:

• util.xml: Break reference to help the GC (fixes[#1711](https://i … ⌘ Read more

开源走向世界（下）：从数据库技术演进看开源力量丨 BDTC 2021
本文内容根据 PingCAP 高级副总裁范若晗在 BDTC 2021 的主题演讲：“开源走向世界” 整理而成，从协作方式和技术演进两个角度，分享了 “开源” 和 “全球化” 之间相互关联，密不可分的关系，分为上下两篇，上篇介绍了开源如何构建全球化的舞台，本篇主题为：从数据库技术演进看开源力量

我们认为，数据技术演进的驱动力总结起来，主要包括三个方面：理论基础推动软件创新、基础设施保障软件能力的实现、业务需求真正打磨了技术的不断工程化、产品化，是产品真正的 “用武之地”。

数据库演进历史——基础理论驱动

按照时间和功能维度，我们将数据生态做了划分，大致包括 SQL 生态，大数据生态，NoSQL 生态，NewSQL 生态，以及 SQL 的云化生态。每个生态的演进，离不开基础理论的发展。
1970 年 IBM 的关系型数据库理论 Relational Model 包括 System R 原型产品的问世，为 Oracle、DB2、MicroSoft SQL Server 这些商业数据库的诞生奠定了基础。而后 MySQL、PostgreSQL 以开源这一形态获得快速发展和全球最广泛的应用。
200 … ⌘ Read more

备份的 “算子下推”：BR 简介丨 TiDB 工具分享
BR 选择了在 Transaction KV 层面进行扫描来实现备份。这样，备份的核心便是分布在多个 TiKV 节点上的 MVCC Scan：简单，粗暴，但是有效，它生来就继承了 TiKV 的诸多优势：分布式、利于横向拓展、灵活（可以备份任意范围、未 GC 的任意版本的数据）等等优点。

相较于从前只能使用 mydumper 进行 SQL 层的备份，BR 能够更加高效地备份和恢复：它取消了 SQL 层的开销 … ⌘ Read more

[WIP] Query any data source using SQL, building Presto or AWS Athena alternative
xyr is a very lightweight, simple, and powerful data ETL platform that helps you to query available data sources using SQL.

• Simple Presto Alternative.
  
• Simple AWS Athena Alternative.
  
• Convert your JSON documents into a SQL DB.
  
• Query your CSV files easily and join them with other data.
  

internaly xyr utilizes SQLite as an embeded sql datastore (it may be changed in future and we c … ⌘ Read more

I will never understand this obsession with “scaling”. Modern web dev seriously over-complicates so many things, it’s not even funny anymore. How we built a serverless SQL database | Hacker News

https://pgexercises.com/ BDD postgreSQL sql tuto

https://www.linuxtricks.fr/wiki/sqlite-l-essentiel-sur-cette-base-de-donnees-cli-sql-php BDD sqlite

http://datatrucmuche.com/memo-sql-pour-la-data-science/ data_science sql

https://sql.sh/ DB documentation sql sqlite

https://github.com/kristijanhusak/vim-dadbod-ui DB sql vim

https://dev.to/wsvincent/database-design-tutorial-for-beginners-33p2 DB sql sqlite

https://github.com/tpope/vim-dadbod DB sql vim

SQL(ite) and zettelkastens as a medium for non-linear story telling. #halfbaked

user-defined order in SQL [[https://begriffs.com/posts/2018-03-20-user-defined-order.html]] #sql #links maybe something that can be adapted to !sqlite?