Coding Test Review: Sentia
A long SQL query in a database far, far away….
Paul Fioravanti
code / languages 
/ mech 
/ Learning stenography
Posts by Tag
- ruby 8
- elixir 8
- elm 7
- japanese 7
- 日本語 7
- phoenix 6
- mechanical-keyboards 6
- stenography 6
- italian 5
- italiano 5
- ergodox 5
- keyboards 5
- clang 4
- i18n 4
- plover 4
- jekyll 3
- qmk 3
- liveview 3
- bitcoin 2
- exercism 2
- api 2
- live-components 2
- javascript 2
- html 2
- meetups 2
- public-speaking 2
- georgi 2
- python 1
- presentations 1
- guard 1
- rubocop 1
- tmux 1
- tmuxinator 1
- rest 1
- graphql 1
- refactoring 1
- architecture 1
- graphs 1
- shadowing 1
- upgrade 1
- elm-0.18 1
- elm-0.19 1
- pdf 1
- prawn 1
- resume 1
- remote-working 1
- live-layout 1
- google-sheets 1
- jlpt 1
- anki 1
- css 1
- plaid 1
- postman 1
- jet-programme 1
- kochi 1
- japan 1
- mobile-phones 1
- feature-phones 1
- chtml 1
- i-mode 1
- 日本 1
- 高知県 1
- ガラケー 1
- beginner 1
- learning 1
- java 1
- c-plus-plus 1
- cpp 1
- rspec 1
- minitest 1
- testing 1
- synthwave 1
- retrowave 1
- 80s 1
- functional-programming 1
- soundcloud 1
- giphy 1
- rails 1
- coding-test 1
- star-wars 1
- data-parsing 1
- tailwind 1
- enum 1
- draper 1
- kaminari 1
- tachyons 1
- pattern-matching 1
- lateral-join 1
- preloading 1
- court-reporting 1
- q-and-a 1
- cosplay 1
ruby
Test-Driven Fairy Tale
Will the Big Bad Wolf thwart The Three Little Pigs from getting a passing test suite?
Resume as Code
Bring some fun back into the document that sells you to the world.
Build a CI/CD pipeline for your Jekyll site
Confidently test your Jekyll site, and bypass the Github Pages gem to publish the site that you want to production.
The Curious Incident of the Shadow in the Run-Time
Coding in Ruby is full of sweetness and light, but where there is light, shadows are cast.
Tmuxinator for Exercism
Creating a template for all your exercises, in any language.
Setting up a Ruby development environment for Exercism
Test-drive your exercises with Guard.
Setting up a Jekyll Blog
Setting up this blog, and creating a development environment that I was happy with, took longer than I expected.
elixir
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
Internationalisation with Phoenix LiveComponents
Draw the responsibility demarcation lines between your LiveView-managed state, markup, and events with LiveComponents.
Internationalisation with Phoenix LiveView
Change your application locale without a full-page reload or having to write (much) Javascript.
Connecting Elm to Phoenix 1.4 with webpack
Phoenix 1.4 has changed its front end configuration framework from Brunch to webpack.
Migrating a Phoenix and Elm app from REST to GraphQL
Change your API from set menu to à la carte.
Connecting Elm to Phoenix 1.3
Configuring Elm for use in a Phoenix 1.3 app using Brunch.
Using C++ Bitcoin libraries in Elixir
Pass messages from Elixir to C++ with Cure.
Using Python’s Bitcoin libraries in Elixir
Leverage Elixir ports to talk to Python with Export.
elm
░▒▓ＥＬＭＳＴＨＥＴＩＣＳ▓▒░
Tech moves pretty fast. If you don’t stop and do a side project once in a while, you could miss it.
Elm 0.18 to 0.19 upgrade notes
Quite a lot has changed in the Elm ecosystem between version 0.18 and 0.19, so here are some notes I jotted down while upgrading a few small apps.
Connecting Elm to Phoenix 1.4 with webpack
Phoenix 1.4 has changed its front end configuration framework from Brunch to webpack.
Runtime Language Switching in Elm
Internationalisation would seem to be a deceptively complex problem using Elm.
Graph-driven Refactoring in Elm
Visually explore package and module dependencies in an Elm project to help architect your app.
Migrating a Phoenix and Elm app from REST to GraphQL
Change your API from set menu to à la carte.
Connecting Elm to Phoenix 1.3
Configuring Elm for use in a Phoenix 1.3 app using Brunch.
japanese
My JLPT N1 Study Guide
Level N1 of The Japanese Language Proficiency Test is a tough nut to crack, but these study methods got me over the line.
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
Internationalisation with Phoenix LiveComponents
Draw the responsibility demarcation lines between your LiveView-managed state, markup, and events with LiveComponents.
Internationalisation with Phoenix LiveView
Change your application locale without a full-page reload or having to write (much) Javascript.
Resume as Code
Bring some fun back into the document that sells you to the world.
Escape the defaults and Control your keyboard with QMK
Getting a keyboard with programmable firmware can enable you to uniquely personalise how you use your keyboard.
Runtime Language Switching in Elm
Internationalisation would seem to be a deceptively complex problem using Elm.
日本語
My JLPT N1 Study Guide
Level N1 of The Japanese Language Proficiency Test is a tough nut to crack, but these study methods got me over the line.
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
Internationalisation with Phoenix LiveComponents
Draw the responsibility demarcation lines between your LiveView-managed state, markup, and events with LiveComponents.
Internationalisation with Phoenix LiveView
Change your application locale without a full-page reload or having to write (much) Javascript.
Resume as Code
Bring some fun back into the document that sells you to the world.
Escape the defaults and Control your keyboard with QMK
Getting a keyboard with programmable firmware can enable you to uniquely personalise how you use your keyboard.
Runtime Language Switching in Elm
Internationalisation would seem to be a deceptively complex problem using Elm.
phoenix
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
Internationalisation with Phoenix LiveComponents
Draw the responsibility demarcation lines between your LiveView-managed state, markup, and events with LiveComponents.
Internationalisation with Phoenix LiveView
Change your application locale without a full-page reload or having to write (much) Javascript.
Connecting Elm to Phoenix 1.4 with webpack
Phoenix 1.4 has changed its front end configuration framework from Brunch to webpack.
Migrating a Phoenix and Elm app from REST to GraphQL
Change your API from set menu to à la carte.
Connecting Elm to Phoenix 1.3
Configuring Elm for use in a Phoenix 1.3 app using Brunch.
mechanical-keyboards
Stenography Numbers on a Georgi
Adapt your steno habits from using a number bar to a set of thumb cluster number keys.
All I want is a Timestamp
Google Sheets can insert the current date and time in your spreadsheet, if you know where to look.
I Completed Typey Type
So, am I a stenographer now, or what?
Chording QWERTY with QMK Combos
Why let stenographers have all the fun? Get more keyboard output using less keys.
Starting Stenography with an Ergodox
QMK and Plover can get your Ergodox singing steno chords.
Escape the defaults and Control your keyboard with QMK
Getting a keyboard with programmable firmware can enable you to uniquely personalise how you use your keyboard.
stenography
Plover For the Record
Want to try recording legal testimony with just your computer keyboard? With Plover, court is in session.
Going Platinum
New to stenography and wondering if you should do the Platinum Steno theory courses? Here’s how they can fit into your learning mix.
Stenography Numbers on a Georgi
Adapt your steno habits from using a number bar to a set of thumb cluster number keys.
I Completed Typey Type
So, am I a stenographer now, or what?
Chording QWERTY with QMK Combos
Why let stenographers have all the fun? Get more keyboard output using less keys.
Starting Stenography with an Ergodox
QMK and Plover can get your Ergodox singing steno chords.
italian
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
Internationalisation with Phoenix LiveComponents
Draw the responsibility demarcation lines between your LiveView-managed state, markup, and events with LiveComponents.
Internationalisation with Phoenix LiveView
Change your application locale without a full-page reload or having to write (much) Javascript.
Resume as Code
Bring some fun back into the document that sells you to the world.
Runtime Language Switching in Elm
Internationalisation would seem to be a deceptively complex problem using Elm.
italiano
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
Internationalisation with Phoenix LiveComponents
Draw the responsibility demarcation lines between your LiveView-managed state, markup, and events with LiveComponents.
Internationalisation with Phoenix LiveView
Change your application locale without a full-page reload or having to write (much) Javascript.
Resume as Code
Bring some fun back into the document that sells you to the world.
Runtime Language Switching in Elm
Internationalisation would seem to be a deceptively complex problem using Elm.
ergodox
All I want is a Timestamp
Google Sheets can insert the current date and time in your spreadsheet, if you know where to look.
I Completed Typey Type
So, am I a stenographer now, or what?
Chording QWERTY with QMK Combos
Why let stenographers have all the fun? Get more keyboard output using less keys.
Starting Stenography with an Ergodox
QMK and Plover can get your Ergodox singing steno chords.
Escape the defaults and Control your keyboard with QMK
Getting a keyboard with programmable firmware can enable you to uniquely personalise how you use your keyboard.
keyboards
All I want is a Timestamp
Google Sheets can insert the current date and time in your spreadsheet, if you know where to look.
I Completed Typey Type
So, am I a stenographer now, or what?
Chording QWERTY with QMK Combos
Why let stenographers have all the fun? Get more keyboard output using less keys.
Starting Stenography with an Ergodox
QMK and Plover can get your Ergodox singing steno chords.
Escape the defaults and Control your keyboard with QMK
Getting a keyboard with programmable firmware can enable you to uniquely personalise how you use your keyboard.
clang
Chording QWERTY with QMK Combos
Why let stenographers have all the fun? Get more keyboard output using less keys.
Starting Stenography with an Ergodox
QMK and Plover can get your Ergodox singing steno chords.
Escape the defaults and Control your keyboard with QMK
Getting a keyboard with programmable firmware can enable you to uniquely personalise how you use your keyboard.
Using C++ Bitcoin libraries in Elixir
Pass messages from Elixir to C++ with Cure.
i18n
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
Internationalisation with Phoenix LiveComponents
Draw the responsibility demarcation lines between your LiveView-managed state, markup, and events with LiveComponents.
Internationalisation with Phoenix LiveView
Change your application locale without a full-page reload or having to write (much) Javascript.
Runtime Language Switching in Elm
Internationalisation would seem to be a deceptively complex problem using Elm.
plover
Plover For the Record
Want to try recording legal testimony with just your computer keyboard? With Plover, court is in session.
Going Platinum
New to stenography and wondering if you should do the Platinum Steno theory courses? Here’s how they can fit into your learning mix.
I Completed Typey Type
So, am I a stenographer now, or what?
Starting Stenography with an Ergodox
QMK and Plover can get your Ergodox singing steno chords.
jekyll
Build a CI/CD pipeline for your Jekyll site
Confidently test your Jekyll site, and bypass the Github Pages gem to publish the site that you want to production.
Setting up a Jekyll Blog
Setting up this blog, and creating a development environment that I was happy with, took longer than I expected.
Hello Blog!
Time to attempt to start another blog.
qmk
Chording QWERTY with QMK Combos
Why let stenographers have all the fun? Get more keyboard output using less keys.
Starting Stenography with an Ergodox
QMK and Plover can get your Ergodox singing steno chords.
Escape the defaults and Control your keyboard with QMK
Getting a keyboard with programmable firmware can enable you to uniquely personalise how you use your keyboard.
liveview
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
Internationalisation with Phoenix LiveComponents
Draw the responsibility demarcation lines between your LiveView-managed state, markup, and events with LiveComponents.
Internationalisation with Phoenix LiveView
Change your application locale without a full-page reload or having to write (much) Javascript.
bitcoin
Using C++ Bitcoin libraries in Elixir
Pass messages from Elixir to C++ with Cure.
Using Python’s Bitcoin libraries in Elixir
Leverage Elixir ports to talk to Python with Export.
exercism
Tmuxinator for Exercism
Creating a template for all your exercises, in any language.
Setting up a Ruby development environment for Exercism
Test-drive your exercises with Guard.
api
Playing in Plaid’s Sandbox
Making API calls to Plaid’s Sandbox Environment: The Missing Manual
Migrating a Phoenix and Elm app from REST to GraphQL
Change your API from set menu to à la carte.
live-components
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
Internationalisation with Phoenix LiveComponents
Draw the responsibility demarcation lines between your LiveView-managed state, markup, and events with LiveComponents.
javascript
My JLPT N1 Study Guide
Level N1 of The Japanese Language Proficiency Test is a tough nut to crack, but these study methods got me over the line.
All I want is a Timestamp
Google Sheets can insert the current date and time in your spreadsheet, if you know where to look.
html
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
My JLPT N1 Study Guide
Level N1 of The Japanese Language Proficiency Test is a tough nut to crack, but these study methods got me over the line.
meetups
Organise a Meetup
Looking to take your love of meetups to the next level? Try organising!
Speak at a Meetup
Worked on a project or learned something new that others might not know about? Share your knowledge with your peers at a local meetup!
public-speaking
Organise a Meetup
Looking to take your love of meetups to the next level? Try organising!
Speak at a Meetup
Worked on a project or learned something new that others might not know about? Share your knowledge with your peers at a local meetup!
georgi
Plover For the Record
Want to try recording legal testimony with just your computer keyboard? With Plover, court is in session.
Stenography Numbers on a Georgi
Adapt your steno habits from using a number bar to a set of thumb cluster number keys.
python
Using Python’s Bitcoin libraries in Elixir
Leverage Elixir ports to talk to Python with Export.
presentations
Wii Remote is Best Presentation Remote
Give new life to your old controllers.
guard
Setting up a Ruby development environment for Exercism
Test-drive your exercises with Guard.
rubocop
Setting up a Ruby development environment for Exercism
Test-drive your exercises with Guard.
tmux
Tmuxinator for Exercism
Creating a template for all your exercises, in any language.
tmuxinator
Tmuxinator for Exercism
Creating a template for all your exercises, in any language.
rest
Migrating a Phoenix and Elm app from REST to GraphQL
Change your API from set menu to à la carte.
graphql
Migrating a Phoenix and Elm app from REST to GraphQL
Change your API from set menu to à la carte.
refactoring
Graph-driven Refactoring in Elm
Visually explore package and module dependencies in an Elm project to help architect your app.
architecture
Graph-driven Refactoring in Elm
Visually explore package and module dependencies in an Elm project to help architect your app.
graphs
Graph-driven Refactoring in Elm
Visually explore package and module dependencies in an Elm project to help architect your app.
shadowing
The Curious Incident of the Shadow in the Run-Time
Coding in Ruby is full of sweetness and light, but where there is light, shadows are cast.
upgrade
Elm 0.18 to 0.19 upgrade notes
Quite a lot has changed in the Elm ecosystem between version 0.18 and 0.19, so here are some notes I jotted down while upgrading a few small apps.
elm-0.18
Elm 0.18 to 0.19 upgrade notes
Quite a lot has changed in the Elm ecosystem between version 0.18 and 0.19, so here are some notes I jotted down while upgrading a few small apps.
elm-0.19
Elm 0.18 to 0.19 upgrade notes
Quite a lot has changed in the Elm ecosystem between version 0.18 and 0.19, so here are some notes I jotted down while upgrading a few small apps.
Resume as Code
Bring some fun back into the document that sells you to the world.
prawn
Resume as Code
Bring some fun back into the document that sells you to the world.
resume
Resume as Code
Bring some fun back into the document that sells you to the world.
remote-working
Employee Sans Office
Small thoughts on remote working.
live-layout
Internationalisation with Phoenix Live Layouts
Phoenix layouts are now live-powered, giving LiveViews more flexibility and control over a template’s surrounding content.
google-sheets
All I want is a Timestamp
Google Sheets can insert the current date and time in your spreadsheet, if you know where to look.
jlpt
My JLPT N1 Study Guide
Level N1 of The Japanese Language Proficiency Test is a tough nut to crack, but these study methods got me over the line.
anki
My JLPT N1 Study Guide
Level N1 of The Japanese Language Proficiency Test is a tough nut to crack, but these study methods got me over the line.
css
My JLPT N1 Study Guide
Level N1 of The Japanese Language Proficiency Test is a tough nut to crack, but these study methods got me over the line.
plaid
Playing in Plaid’s Sandbox
Making API calls to Plaid’s Sandbox Environment: The Missing Manual
postman
Playing in Plaid’s Sandbox
Making API calls to Plaid’s Sandbox Environment: The Missing Manual
jet-programme
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
kochi
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
japan
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
mobile-phones
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
feature-phones
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
chtml
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
i-mode
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
日本
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
高知県
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
ガラケー
Oi! Kochi: Japanese Feature Phone-Driven Development
During Japan’s mobile web infancy, I wanted my little community newsletter to ride the wave of the future.
beginner
Your Code: Episode I - The Phantom Repository
Every Developer Learns To Program. Every Journey Has A First Step. Every Coding Saga Has A Beginning.
learning
Your Code: Episode I - The Phantom Repository
Every Developer Learns To Program. Every Journey Has A First Step. Every Coding Saga Has A Beginning.
java
Your Code: Episode I - The Phantom Repository
Every Developer Learns To Program. Every Journey Has A First Step. Every Coding Saga Has A Beginning.
c-plus-plus
Your Code: Episode I - The Phantom Repository
Every Developer Learns To Program. Every Journey Has A First Step. Every Coding Saga Has A Beginning.
cpp
Your Code: Episode I - The Phantom Repository
Every Developer Learns To Program. Every Journey Has A First Step. Every Coding Saga Has A Beginning.
rspec
Test-Driven Fairy Tale
Will the Big Bad Wolf thwart The Three Little Pigs from getting a passing test suite?
minitest
Test-Driven Fairy Tale
Will the Big Bad Wolf thwart The Three Little Pigs from getting a passing test suite?
testing
Test-Driven Fairy Tale
Will the Big Bad Wolf thwart The Three Little Pigs from getting a passing test suite?
synthwave
░▒▓ＥＬＭＳＴＨＥＴＩＣＳ▓▒░
Tech moves pretty fast. If you don’t stop and do a side project once in a while, you could miss it.
retrowave
░▒▓ＥＬＭＳＴＨＥＴＩＣＳ▓▒░
Tech moves pretty fast. If you don’t stop and do a side project once in a while, you could miss it.
80s
░▒▓ＥＬＭＳＴＨＥＴＩＣＳ▓▒░
Tech moves pretty fast. If you don’t stop and do a side project once in a while, you could miss it.
functional-programming
░▒▓ＥＬＭＳＴＨＥＴＩＣＳ▓▒░
Tech moves pretty fast. If you don’t stop and do a side project once in a while, you could miss it.
soundcloud
░▒▓ＥＬＭＳＴＨＥＴＩＣＳ▓▒░
Tech moves pretty fast. If you don’t stop and do a side project once in a while, you could miss it.
giphy
░▒▓ＥＬＭＳＴＨＥＴＩＣＳ▓▒░
Tech moves pretty fast. If you don’t stop and do a side project once in a while, you could miss it.
rails
Coding Test Review: Sentia
A long SQL query in a database far, far away….
coding-test
Coding Test Review: Sentia
A long SQL query in a database far, far away….
star-wars
Coding Test Review: Sentia
A long SQL query in a database far, far away….
data-parsing
Coding Test Review: Sentia
A long SQL query in a database far, far away….
tailwind
Coding Test Review: Sentia
A long SQL query in a database far, far away….
enum
Coding Test Review: Sentia
A long SQL query in a database far, far away….
draper
Coding Test Review: Sentia
A long SQL query in a database far, far away….
kaminari
Coding Test Review: Sentia
A long SQL query in a database far, far away….
tachyons
Coding Test Review: Sentia
A long SQL query in a database far, far away….
pattern-matching
Coding Test Review: Sentia
A long SQL query in a database far, far away….
lateral-join
Coding Test Review: Sentia
A long SQL query in a database far, far away….
preloading
Coding Test Review: Sentia
A long SQL query in a database far, far away….
court-reporting
Plover For the Record
Want to try recording legal testimony with just your computer keyboard? With Plover, court is in session.
q-and-a
Plover For the Record
Want to try recording legal testimony with just your computer keyboard? With Plover, court is in session.
cosplay
Plover For the Record
Want to try recording legal testimony with just your computer keyboard? With Plover, court is in session.