All Projects → xwiki-labs → Synapse_scripts

xwiki-labs / Synapse_scripts

Tools for maintaining a matrix synapse chat server // SEEKING MAINTAINERS

Labels

Projects that are alternatives of or similar to Synapse scripts

Sqlgenerate
Generates SQL when given an AST from the Codeschool/sqlite-parser
Stars: ✭ 14 (-75.86%)
Mutual labels:  plpgsql
Spring Batch Admin Backend
Spring Batch Admin 是一个后端采用spring boot 2, spring security , oauth2, Spring data jpa 作为基础框架,集成了quartz 提供调度能力,集成了Spring batch 提供批处理能力的管理系统。系统旨在提供更底层数据展示以及常见批处理的配置以及运行能力。
Stars: ✭ 41 (-29.31%)
Mutual labels:  plpgsql
Fias2pgsql
Скрипты для импорта ФИАС в Postgresql
Stars: ✭ 54 (-6.9%)
Mutual labels:  plpgsql
Globalregion
全球国家/地区下拉级联,包含中英文国际化,国家/省份(直辖市)/城市(区)/县
Stars: ✭ 28 (-51.72%)
Mutual labels:  plpgsql
Mingyuyue
古诗词取名后台
Stars: ✭ 37 (-36.21%)
Mutual labels:  plpgsql
Pg Emoji
😍🐘 PostgreSQL emoji encode/decode extension
Stars: ✭ 48 (-17.24%)
Mutual labels:  plpgsql
Medrianchor
The (Me)tadata (Dr)iven (Anchor) Model
Stars: ✭ 9 (-84.48%)
Mutual labels:  plpgsql
Pgformatter
A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI. On-line demo site at http://sqlformat.darold.net/
Stars: ✭ 1,085 (+1770.69%)
Mutual labels:  plpgsql
Aquameta
Web development platform built entirely in PostgreSQL
Stars: ✭ 987 (+1601.72%)
Mutual labels:  plpgsql
Postgresql Functions
Custom PostgreSQL functions and extensions
Stars: ✭ 50 (-13.79%)
Mutual labels:  plpgsql
Pgwatch2
PostgreSQL metrics monitor/dashboard
Stars: ✭ 960 (+1555.17%)
Mutual labels:  plpgsql
Google Analytics Bigquery Data Export
Export Google Analytics data from BigQuery using Standard or Legacy SQL.
Stars: ✭ 34 (-41.38%)
Mutual labels:  plpgsql
Pgsql Tweaks
Contains PostgreSQL functions which I regularly needed.
Stars: ✭ 48 (-17.24%)
Mutual labels:  plpgsql
Sat Api Pg
A Postgres backed STAC API.
Stars: ✭ 20 (-65.52%)
Mutual labels:  plpgsql
Ms Sql Server Group Concat Sqlclr
SQL Server CLR user-defined aggregates that collectively offer similar functionality to the MySQL GROUP_CONCAT function. Specialized functions ensure the best performance based on required functionality. Aggregates implemented using C#; requires .NET Framework 3.5.
Stars: ✭ 54 (-6.9%)
Mutual labels:  plpgsql
Basketball Data Scraper
A scraping library that gets you basketball data for the NBA and WNBA
Stars: ✭ 13 (-77.59%)
Mutual labels:  plpgsql
Graphpostgresql
GraphQL for Postgres
Stars: ✭ 1,020 (+1658.62%)
Mutual labels:  plpgsql
Pgulid
Universally Unique Lexicographically Sortable Identifier (ULID) for PostgreSQL
Stars: ✭ 56 (-3.45%)
Mutual labels:  plpgsql
Pg partman
Partition management extension for PostgreSQL
Stars: ✭ 1,085 (+1770.69%)
Mutual labels:  plpgsql
Postgres Full Text Search
Stars: ✭ 50 (-13.79%)
Mutual labels:  plpgsql

UNMAINTAINED AND DANGEROUS

These script aren't maintained and the synapse team had problems with people who used this, where it broke their server. The synapse team advises against using these scripts.

Synapse Scripts

synapse_janitor.sql

Cleans a synapse Postgres database of deleted messages and abandoned rooms.

Deleted Messages

If a message was sent in matrix and is then deleted (or redacted in technical parlance) it is not displayed but it is not removed from the server either. This script removes it.

Abandoned Rooms

If a room has been joined by someone on your homeserver but currently nobody on your homeserver is using it, this script will remove all traces of that room. NOTE: It will cause the room to disappear from people's "historical" section of old rooms. This can improve performance significantly.

Using this script

This script should be run from the command line while synapse server is stopped.

psql -Umatrix synapse < synapse_janitor.sql

synapse_dumper.sh

Allows easy backup of a matrix postgres database by dumping it to a compressed file.

synapse_startloop.sh

Script which starts up synapse if it is not running. NOTE: This is configured for a matrix server which has the synchrotron worker enabled, if you do not use the synchrotron, just comment the block at the bottom.

Using these scripts

The startloop and the dumper are appropriate for use in crontab:

* * * * * /home/matrix/synapse_scripts/synapse_startloop.sh 2>&1 >>/home/matrix/synapse_startloop.log
0 3 * * * /home/matrix/synapse_scripts/synapse_dumper.sh 2>&1 >>/home/matrix/synapse_dumper.log
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].