This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE test_data ( | |
housenumber text | |
); | |
INSERT INTO test_data VALUES | |
('123;456'), | |
('789;'), | |
(';'), | |
('abc;def'), | |
(''); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
version: "3.8" | |
# Updated from immich v1.91.4 | |
# Before you start it, replace immich.domain.com to your domain and your@email.com to your email. | |
# | |
# Traefik web-admin is available on server at port 8080. | |
# To connect it, forward 8080 port to your machine `ssh -L 8080:127.0.0.1:8080 user@server`, then open http://localhost:8080 | |
name: immich |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BookmarkIcon(color: .blue, icon: .icon_star), // 0 | |
BookmarkIcon(color: .green, icon: .icon_bank), // 1 | |
BookmarkIcon(color: .gray, icon: .icon_car_service), // 2 | |
BookmarkIcon(color: .turquoise, icon: .icon_theater), // 3 | |
BookmarkIcon(color: .green, icon: .icon_education), // 4 | |
BookmarkIcon(color: .turquoise, icon: .icon_cinema), // 5 | |
BookmarkIcon(color: .blue, newColor: .orange, icon: .icon_restaurant), // 6 | |
BookmarkIcon(color: .red, icon: .icon_health), // 7 | |
BookmarkIcon(color: .green, icon: .icon_police_station), // 8 | |
BookmarkIcon(color: .green, icon: .icon_residence), // 9 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package db | |
import ( | |
"fmt" | |
"userspace_back/db/model" | |
"gorm.io/driver/postgres" | |
"gorm.io/gorm" | |
"gorm.io/gorm/schema" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WARNING: --num-threads is deprecated, use --threads instead | |
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) | |
Running the test with following options: | |
Number of threads: 8 | |
Initializing random number generator from current time | |
Prime numbers limit: 10000 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- since it uses dblink it should be enabled in the database. | |
-- CREATE EXTENSION dblink; | |
-- And you'll may need to grant permissions to use it to your user. | |
-- GRANT EXECUTE ON FUNCTION dblink_connect_u(text) TO user; | |
-- GRANT EXECUTE ON FUNCTION dblink_connect_u(text, text) TO user; | |
-- Usage example: | |
-- select g_parsel('insert into osm_polygon_extra select osm_id, st_pointonsurface( st_collect( geom ) ) from osm_polygons group by osm_id;', 'osm_polygons', 12); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
* { | |
details-text:eval(tag('name')); | |
details-description:eval(tag('description')); | |
} | |
line { | |
width:3pt; | |
color:#0062CC; | |
linejoin:round; | |
linecap:round; | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// We have a parent just to pass face control in JSONSerialization | |
@objc class SortedDictionary: NSDictionary { | |
let _values: NSMutableArray = [] | |
let _keys: NSMutableOrderedSet = [] | |
override var count: Int { | |
return _keys.count | |
} | |
override func keyEnumerator() -> NSEnumerator { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- Befor using it you should enable dblink extension in database and allow user to run dblink_connect_u | |
-- You may need to change 'dbname=osm' to your db connection options in line 34. | |
-- CREATE EXTENSION dblink; | |
-- GRANT EXECUTE ON FUNCTION dblink_connect_u(text) TO user; | |
-- GRANT EXECUTE ON FUNCTION dblink_connect_u(text, text) TO user; | |
-- | |
DROP FUNCTION IF EXISTS public.g_parsel(query text, table_to_chunk text, num_chunks integer); | |
CREATE OR REPLACE FUNCTION public.g_parsel(query text, table_to_chunk text, num_chunks integer default 2) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
include 'postgresql_orig.conf' | |
# Generated by PGConfig 2.0 beta | |
## http://pgconfig.org | |
# Memory Configuration | |
shared_buffers = 6GB | |
effective_cache_size = 18GB | |
work_mem = 819MB | |
maintenance_work_mem = 2GB |
NewerOlder