Independent Development Resources Database Series

spike
NameCategoryRemarks
GoNaviData ManagementOpen-source management tool
AliSQLhtapMySQL integrated with DuckDB, open-sourced by Alibaba, this project is amazing, super awesome!
tursoLightweight DatabaseFile database, cloud-upgraded version of SQLite
databasusBackupFree and open-source, self-hosted, supports MySQL, PostgreSQL, MongoDB
neonpgOnline PostgreSQL service, free initially, easy to scale later
pgliteBrowser DatabaseRuns in the browser via WebAssembly, lightweight 3MB, full PostgreSQL functionality, single-user
dbsyncerSynchronizationSynchronization tool for various databases, annual fee 999 yuan
postgres_for_everythingpgDetailed learning of PostgreSQL features and capabilities
kottsterData ManagementDeveloped with Node.js, can be deployed via Docker, directly manages table data
sqliteonlineTestingOnline testing for various databases: SQLite, MySQL, PostgreSQL, DuckDB, etc.
pigpgPigsty command-line tool, one-click PostgreSQL configuration on Linux
VictoriaMetricsTime-Series DatabasePowerful time-series database, written in Go
pineconeVector DatabaseCloud-hosted, suitable for small to medium-scale data, millions to tens of millions
planetscalemysqlCheapest plan starts at $39 per month
mycliOperationsMySQL terminal operations tool, auto-completion, Python-based
airbytehq/airbyteData Transfer, SynchronizationETL tool
MySQL explain, Extra AnalysisSQL OptimizationBasics
diagramplusOnline Database Design
bytebaseManagement ToolPowerful management tool
E-book Database IntroductionTutorialOnline GitHub e-book
mysql单表最高容量是多少Tutorial16k page data format and single table growth limit
KeyDBCache Databasesuperset of redis
ape-dtsData MigrationEspecially suitable for migrating self-built MySQL databases to other MySQL environments (such as cloud MySQL, KubeBlocks MySQL)
PyWxDumpWeChatLocal WeChat database reading and decryption script tool
ibd2sqlmysqlDatabase disaster recovery tool
planetscaleDatabaseProvides free database services
airbyteDatabaseHundreds of different database synchronization tools
《DDIA 逐章精读》小册DatabaseIntensive reading
mss2sqlDatabasemssql to mysql
AreaCity-JsSpider-StatsGovDatabaseUseful provincial, city, and district data
dbeaverDatabaseManagement tool, free
dbforge studiodbDatabase single-step debugging
navicatdbDatabase debugging tool
seatunnelDatabaseData synchronization tool
beekeerperDatabase ManagementOpen source
binlog2sqlDatabasebinlog parsing SQL for data flashback
ape-dtsDatabase MigrationDatabase migration project written in Rust, supports multiple databases
webdbWeb Database ManagementDeploy using Docker on the intranet as a database management tool
gobackupBackupLarge file splitting, partial storage to S3, webhook notification

pg

Reset the maximum value of id


SELECT setval(pg_get_serial_sequence('public.read_article_category', 'id'),  COALESCE((SELECT MAX(id) FROM public.read_article_category), 0) + 1);
Life Materials