https://wiki.roman-halliday.com/ 2026-04-17T12:50:45+00:00 https://wiki.roman-halliday.com/ https://wiki.roman-halliday.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-04-07T09:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=audio_guide&rev=1744017858&do=diff Existing Sample Apps & Projects Open source audio guide - react app * <https://nordicmuseum.github.io/Nordic-Museum-Audio-Guide/> Open Source Audio Guide - static web app * <https://labs.acmi.net.au/an-open-source-static-museum-audio-guide-4c5cd83dbdcb> * <https://github.com/ACMILabs/static-museum-audio-guide> Example in action: * <https://audio.nationalgalleries.org/hill-and-adamson/stops/3/> * <http://www.example.com/static-museum-audio-guide/stops/2/> No Code Solution (limite… text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=big_data_using_the_unix_command_line&rev=1743090145&do=diff Don't believe the hype, big data doesn't need lots of RAM etc... * big data analytics with grep and sed * Command-line Tools can be 235x Faster than your Hadoop Cluster * Make grep faster (in some cases)... <https://blog.x-way.org/Linux/2013/12/15/Make-grep-50x-faster.html> Oh and, lol at this DB name: voldemort text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=building_a_cluster&rev=1743090145&do=diff Temptation is a strange thing. For learning how to develop on a platform, all one needs is Docker (or a stand alone VM). Just get docker, and then download the latest Hadoop Docker Image. More notes from here. Failing that (I'm the person who got a VPS for a blog and wiki): text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=converting_docuwiki_to_mediawiki&rev=1743090145&do=diff This wiki is written in the docuWiki syntax, which is close to but different from mediaWiki (used by Wikipedia and others). Thanks to a little googling, I found: * Migration from Dokuwiki * <https://github.com/tstaerk/mediasyntax/blob/master/tools/dokuwiki2mediawiki..php> * MediaWiki to DokuWiki Converter - The wrong way for me. Sample Steps mkdir dokuwiki2mediawiki cd dokuwiki2mediawiki #Get script (raw format from github) wget https://raw.githubusercontent.com/tstaerk/mediasyntax/ma… text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=create_sample_data_with_python&rev=1743090145&do=diff sample_data Using: * faker text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=creating_date_ranges&rev=1743090145&do=diff SQL Server WITH date_range AS ( SELECT DateAdd(DAY, a.a + (10 * b.a) + (100 * c.a), DateAdd(DAY, DateDiff(DAY, 0, GetDate()), 0) - 365) AS TheDate FROM ( (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS A CROSS JOIN (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UN… text/html 2025-04-08T07:06:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=data_loading_tools&rev=1744096001&do=diff The 'L' in ETL/ELT See some discussion here: <https://www.reddit.com/r/dataengineering/comments/o744oi/fivetan_vs_stitch_vs_singer_vs_airbyte_vs_meltano/> Singer Singer taps are the open source connectivity libraries (commercially used by the core developer |Stitch Data, which is an offshoot of Talend). Singer taps are used by a wide array of projects including: * Meltano Others text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=dates&rev=1743090145&do=diff Dates are a big thing in computing and databases. I'll throw notes here and clean them up some time in the future, probably some time never. SQL Server Pages here: * Creating Date Ranges Other links: * Date Formatting * Date Selecting SELECT GetDate() AS now_date_time, --CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS DATETIME) AS now_date, -- Best method pre 2008 CAST(GetDate() AS DATE) … text/html 2025-05-01T14:28:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=dbt&rev=1746109736&do=diff DBY on Win Python Info: * <https://devguide.python.org/versions/> * <https://github.com/pyenv-win/pyenv-win?tab=readme-ov-file> * <https://stackoverflow.com/questions/65348890/python-was-not-found-run-without-arguments-to-install-from-the-microsoft-store> # Pyenv: https://github.com/pyenv-win/pyenv-win?tab=readme-ov-file Invoke-WebRequest -UseBasicParsing -Uri "https://raw.githubusercontent.com/pyenv-win/pyenv-win/master/pyenv-win/install-pyenv-win.ps1" -OutFile "./install-pyenv-win.p… text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=drugs&rev=1743090145&do=diff Drugs, dirty dancing, and pounding, pounding Techno music Some years ago, I remember dancing to a techno track in a club with the profound lyrics: " drugs, dirty dancing, and pounding, pounding Techno music" Clearly lifted from a news article/announcement scaring parents of the techno music and club scene. Which featured in a number of techno music pieces (was that the presenters intention). text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=filming&rev=1743090145&do=diff Because I always forget something Audio Don't hide lav mics in long hair, you will get noise. Use mics for people, with individual storage. Have a good backup audio recording if you can. For me shotgun mic on camera Mics on other devices are just for audio sync (can be leveraged in post if using backup approach). text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=jukebox&rev=1743090145&do=diff After getting a small obsession with them, researching and wanting to buy myself one. Either an original antique or something new, I've got a lot of notes. Notes are UK centric. Buying A Jukebox New Jukeboxes New, not previously used somewhere. Comes with a good warranty and all the rest. Just not an antique. text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=mst3k&rev=1743090145&do=diff <https://en.m.wikipedia.org/wiki/List_of_Mystery_Science_Theater_3000_episodes> <http://www.club-mst3k.com/> text/html 2025-04-07T15:55:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=osdse&rev=1744041343&do=diff Open Source Data Solution Example (OSDSE) Working example for my Open Source Data Solution Example. Hosted VM with digitalocean.com (if interested see my referral link for an offer benefitting both of us) [https://www.digitalocean.com/?refcode=bb281f2fae53&utm_campaign=Referral_Invite&utm_medium=Referral_Program&utm_source=badge] Check with other notes on Server Configuration - Virtual Host Host Setup Hostname: text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=reddit&rev=1743090145&do=diff Reddit Who doesn't love reddit.com * <https://www.reddit.com/r/csshelp/comments/3cdayn/how_to_add_a_search_by_link_flair_button/> * <https://www.reddit.com/r/AutoModerator/> * <https://www.reddit.com/r/AutoModerator/wiki/index> * <https://www.reddit.com/r/AutoModerator/wiki/library> * <https://www.reddit.com/r/AutoModerator/comments/3ta340/whats_the_difference_between_remove_and_spam_with/> * Reporting spam * <https://www.reddithelp.com/hc/en-us/articles/360043066512> htt… text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=sample_data&rev=1743090145&do=diff sample_data Oracle (MySQL) * Sakila (DVD Rental, MySQL Sample): Sakila Sample Database (licensed under the New BSD license) * Employees Sample Database: Employees Sample Database (licensed under the Creative Commons Attribution-Share Alike 3.0 Unported License) Jaffle shop (dbt sample): * <https://github.com/dbt-labs/jaffle-shop> * <https://github.com/dbt-labs/jaffle-shop-classic> General mixed data: text/html 2025-04-02T09:56:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=server_configuration&rev=1743587787&do=diff Server Configuration - Virtual Host For the hosting of this wiki, my blog Rows Across The Lake and other things, I have a VM web host. Inspired by my migration efforts, I'm documenting the changes and challenges for next time. Some useful notes from the first server are hidden away under text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=start&rev=1743090145&do=diff Introduction This is my notepad, notes for myself (shared with the world). Curated and cleaned up content is on my blog: <http://datablog.roman-halliday.com/> One of many great lecturers I had was known to staff and students alike as “Boggle”, In one early lecture he told us “Boggles first rule of programming text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=techno&rev=1743090145&do=diff After making notes about drugs in a techno track, I've found more... Simon Harris Afte looking at WhoSampled.com for The Power and finding that that striking voice came from Love's Gonna Get You, via some random techno breakbeat LP Beats, Breaks & Scratches Volume 5. I became intrigued as to the story behind it. After some googling, I found this interview: text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=trading&rev=1743090145&do=diff Notes * <https://academy.binance.com/en/articles/a-beginners-guide-to-candlestick-charts> * <https://www.binance.com/en/support/faq/8419126024404348a1c6e4039fbed3fe> * text/html 2025-03-27T15:42:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.roman-halliday.com/doku.php?id=video_editing&rev=1743090145&do=diff Video Editing I love to edit videos of things. Software DaVinci Resolve Free (at least for what I want to do) is a hard price to beat. DaVinci Resolve See specific notes under: * DaVinci Resolve - All things DaVinci Resolve (getting started advice etc....) * DaVinci Resolve Proxy Workflows - Notes on working with proxy media in DaVinci Resolve