Advanced Search
Search Results
37 total results found
IT
Photos
Postgres
Privacy
Cars
Music Production
DJing
Angular
macOS
2018-2019 Buying an used car
bought Mazda 6 2.0i 2010
Organize Your Photos Using exiftool
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...
PostgreSQL on macOS
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...
Backslash commands
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
Cheatsheet
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
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...
Dump / Restore
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...
Android Settings
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...
Searching a naturally aspirated engine
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
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
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
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...
Mercedes-Benz
B Class T245 all petrol engines are with indirect injection Motor codes M 166 E xx (E = Saugrohreinspritzung, xx = engine size in deciliter) C Class W204 MPI engines use a Kompressor, while GDI engines a turbocharger C 180 Kompressor BlueEFFICIENCY 2008 - 201...
BMW
BMW 3 Series E9x E9x series with petrol engines, especially L4 N43, are known to have problems with oil leaks, water pump, cooling.. inline 6 cylinder engines (325i) seems to be the best for car enthusiasts, but quite expesive to own N43 and N53 use direct inj...
Audi
A3 Second Generation (2003-2012) FSI engines facelift 2008 1.6 -> 2010 - 102 PS (75 kW)
Skoda
Octavia Second Generation (2005-2013) facelift 2009 same platform with Golf Mk5 and Audi A3 Mk2 no interesting engine. Only option is 1.4, but it has only 80 PS
Hyundai / KIA
i30 Second Generationa (GD) 2012-2017 GDI models and T-GDI are engines with direct injection, T stand for turbo CVVT and MPI are engines with indirect injection 1.4 CVVT 73 kW (99 PS) EURO 5 1.4 CVVT 74 kW (101 PS) EURO 6
Notes
check Chuck - music programming language Ideas of setup for session view Launchpad (Quneo) should be enough for arrangement view keyboard and/or pads checkout launchpad95 script Arturia seems to make pretty cool devices fairly priced. Most have VC/Gate output...
Serato
Keyboard Shortcuts See also https://serato.com/latest/blog/17257/pro-tips-serato-dj-keyboard-shortcuts Deck 1 / LEFT Basically first row of letters plus half of the numeric keys. KEY Action + alt Left Q Reverse Prev Track W Play/Pause Next Track E / R Pitch ...
Mazda 6 GH1 2.0i Sport TE (2010)
Service Georg 0650 2418551 - Werkstatt Gänserndorf Notes Drehmomentschlüssel Alufelgen & Stahlfelgen: 110 Nm Regelmäßig Getriebeölwechsel: alle 100.000? km oder 5 Jahren Bujii: normale 40k, iridium 60k Cd = 0.27 Felgen 7Jx17 ET60 LK 5x114,3 Reifen 215/50R17 ...
Runtime configuration
Runtime environment configuration with Angular