Skip to main content
Advanced Search
Search Terms
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

40 total results found

Photos

Organize Your Photos Using exiftool

Photos

Find all photos without date information $ exiftool -filename -filemodifydate -createdate -r -if '(not $datetimeoriginal) and $filetype eq "JPEG"' . Set last created and modified to a specific date $ find . -name \"*.jpg\" | while read filename; exiftool \"-A...

Postgres

2018-2019 Buying an used car

Cars

bought Mazda 6 2.0i 2010

PostgreSQL on macOS

Postgres

Install PostgreSQL using brew brew install postgresql List services maintained by brew $ brew services list Name Status User Plist postgresql started lr ... If you don't want it running as service you can manually start it with postgres -D /usr/loca...

Privacy

Backslash commands

Postgres

  command Toggle expanded display \x Toggle tuples only \t Connect to database \c db_name List databases \l Display table definition \d table_name Display triggers \dft

Cars

IT

Cheatsheet

Postgres

Truncate/empty all tables SELECT 'TRUNCATE TABLE ' || tablename || ' CASCADE;' FROM pg_tables WHERE tableowner='acovix_devl'; Show process / query list SELECT * FROM pg_stat_activity; -- active queries SELECT pid, age(query_start, clock_timestamp()), usenam...

Queries with IPs

Postgres

Top networks CREATE TABLE ip ( id serial NOT NULL, addr cidr NOT NULL, hostname character varying(25) NOT NULL ); SELECT * FROM ip WHERE NOT EXISTS (SELECT addr FROM net n WHERE n.addr >> net.addr); Bigint to IP create function bigint_to_inet(bigin...

Music Production

Dump / Restore

Postgres

Dump All Functions (to a file) SELECT pg_get_functiondef(f.oid) FROM pg_catalog.pg_proc f INNER JOIN pg_catalog.pg_namespace n ON (f.pronamespace = n.oid) WHERE n.nspname = 'public'; run \o functions.sql first to save the output to a file or use \copy (...) t...

DJing

Android Settings

Privacy

Google Ads Personalization Seetings > Googs > Ads > Opt Out Ads Personalisation Google Search History turn off Google Location History turn off Youtube Search History turn off Youtube Watched Videos leave on if you want relevant suggestions Play Prot...

Angular

Searching a naturally aspirated engine

Cars 2018-2019 Buying an used car

gasoline direct injection (GDI), also known as petrol direct injection, direct petrol injection, spark-ignited direct injection (SIDI) and fuel-stratified injection (FSI). variable valve timing (VVT) is the process of altering the timing of a valve lift event,...

Mazda

Cars 2018-2019 Buying an used car

Mazda 6 GH Initial release 2008 sequenzielle elektronisch geregelte Saugrohreinspritzung abgasnorm EURO 4 1.8i 88 kW 2.0i 108 kW 2.5i 125 kW 2010 Facelift 1.8i 88 kW - unchanged KFZ Steuer 524E (44E/mo) 2.0i 114 kW - DISI = Direct Injection Spark Ignition Ben...

Citroen

Cars 2018-2019 Buying an used car

C4 First Generation Facelift 2008 - 2010 1.6 seem to be very rare in AT Second Generation 2010 - 2014 2015 Facelift does not have VTi engines anymore 1.6 VTi 120 PS (88 kW) C4 Picasso First Generation 2008-2012 1.6 VTi 88 kW

Ford

Cars 2018-2019 Buying an used car

Focus Mk2 and C-MAX 2008 Facelift - 2010 1.6 Duratec Ti-VCT 115 PS, 74 kW 1.8 and 2.0 Duratec HE - developed by Mazda (LF model of MZR series) Focus Mk3 no engine with indirect injection, all engines are Ti-VCT GDI - Duratec HE GDI C-MAX Mk3 1.6 Ti-VCT 77 kW 1...