Pesky's Blog

Like many cities, Barcelona started with a horse-drawn tram network, which then grew and was electrified before being decommissioned in favour of buses, private vehicles and the metro. Having not turned out so great, Barcelona then returned to the tram. I wrote about this same pattern in Luxembourg and Berlin, now it’s time for Barcelona. The first tram network The horse-drawn tram A monument to Christopher Columbus was constructed in 1888 near the Drassanes shipyards. Read more...

It’s always fun looking back at things I’ve done in the past, especially if they’re neatly logged or visualised in some way. Robert Birming commented on the same feeling he gets when looking at his blog calendar, or pins on a map based on completed house inspections he’s done. Reading his post inspired me to finally write this one. The front page of my website has the recent activity from some of these logs: blogs I’ve written, anime I’ve watched and beer I’ve checked in. Their main goal is to have a quick view of what’s been going on in the last few weeks, but behind each panel is a history of data I can view to see how far I’ve come. Robert calls this being nowstalgic. Read more...

Travelski, a subsidiary of Compagnie des Alpes, will begin offering a night train from Amsterdam, through Brussels, to the French Alps starting this December. This is in addition to the service launched last ski season in December 2025 that went from Paris - Gare de Lyon to Moûtiers, Aime and Bourg-Saint-Maurice. Starting Friday, 18 December 2026, Travelski will run a train from Amsterdam Centraal to Bourg-Saint-Maurice. The trail will travel through Rotterdam Centraal, Antwerpen Centraal, Brussels Zuid, Moûtiers and Aime-la-Plagne along the way. The departure from Amsterdam is scheduled to be at 18:00, according to the booking details on the Travelski site, with an arrival at 08:30 in Bourg-Saint-Maurice, giving a total travel time of 14 hours and 30 minutes. Currently, a one-way ticket for a single adult goes for 168 euros. Read more...

DuckDB has the ability to query S3 Tables, when this was first announced in beta I was unable to get it to work and subsequently gave up. A little over a year later I decided to give this a go again and now that it’s generally available, to my surprise, it just works. There’s still guides on how to set this up with nightly releases and other feature flags but nothing that shows the generally available path, so here’s my steps to get started. Read more...

SQLite can be used as a data source for Grafana using a community plugin maintained by fr-ser. Out of the box the plugin has support for time formatted columns, which work on visuals like time series, and time range macros, which use the dashboards datetime picker. This post has a few of my notes. Unix epoch numbers (e.g. 1773149763) and RFC3339 strings (e.g. 2026-03-10T15:36:03+01:00) work natively for time formatted columns. The documentation has an example of how to fix malformed RFC3339 strings to work with the plugin. You may use the concatenate operator (||), replace() and other functions to fix your timestamps. Read more...

I’ve been exploring AWS analytics services again so it’s time for another TIL. This post goes over accessing and querying S3 tables from QuickSight, via Athena, as S3 tables don’t natively work with QuickSight. Here’s the TL;DR on what you need to do: Create your S3 Tables bucket, namespace and table. Ensure that your S3 Tables bucket has AWS analytics service integration enabled. Grant your QuickSight user permission to the S3 table via LakeFormation and your QuickSight service role permisisons through IAM. Add Athena as a data source in QuickSight. Add a dataset from the previously created data source and use custom SQL to query your S3 Tables. Verify you can use your table dataset from an analysis. Those are a lot of steps and here are some AWS resources that explain them: Read more...

There are scripts that are designed only be run a handful of times, or maybe even once under rare circumstances. They are usually tested a lot of more times than they are intended to be executed, or when they are executed, their actions could be detrimental, this is where --no-dry-run option comes in. In my career, I seem to have worked on a lot of system, or application migrations. I’m not sure if this is very common outside of the places I’ve worked at or if I’m just a harbinger of change. Depending on the migration the approach changes but there usually comes a time when a cut over to the new solution needs to be done. The steps leading up to, during and after the migration are typically crucial with rollback procedures in place in case something goes wrong. These steps would have been tested thoroughly before hand by mocking the system in various states. But here’s the thing, the actual cutover happens once. To prevent prematurely executing the script it’s nice to have a second layer of acknowledgement, the --no-dry-run option. Read more...

Micah Blachman, a seventh-grader, candidly writes about the educational technology used at his school. Reading his insights brought back some memories of when technology like this was first introduced at my school. Now it’s been a while, almost two decades, actually, but I remember thinking surely things would get better in the future. It does not. I wanted to add some commentary from my dated perspective in secondary school. I don’t think it’s particularly in-depth, and my memory is foggy at best, but it does provide a good comparison. I’d recommend reading Micah’s post first. Read more...

On 8 December 2025, GoVolta announced its intercity service from Amsterdam to Berlin and Hamburg, starting 19 March 2026 and 20 March 2026, respectively; at first, three times a week each, before increasing to daily in December. The service will alternate between Berlin and to Hamburg, with services to Berlin on Tuesday, Thursday and Sunday, and Hamburg on Monday, Wednesday and Friday. Founded by Hessel Winkelman and Maarten Bastian, GoVolta aims to provide budget international train services from the Netherlands. The duo started their first business in 2010 called Flywise, where they sold bundled budget flights and hotels. From 2021 they branched into bundling night train and hotel reservations under the brand Green City Trips, where the trains were chartered from Train Charter Services (TCS). In 2025, Green City Trips was acquired by European Sleeper. With their experience selling night trains under Green City Trip, it will be interesting to see how GoVolta does with regular trains during the day. Read more...

If you’ve worked with AWS thorugh the CLI, you’ll be familair with aws sts get-caller-identity, essentially the whoami and uname of the cloud. While working with one or more accounts, getting the caller identity allows you to identify what role or user you are authenticated as and on which AWS account. There’s only one thing that I miss while using the API call, a human-readable account name. There are two types of names AWS has per account, the first which is set when creating the account itself, and the second which is the IAM alias, which is also visible when using multiple sessions in the console. Read more...

On 19 November 2025, the Dutch Railway, NS, announced the purchase of 36 new sprinter trains called the NS Flirt Flex. This will be the 5th generation of sprinter trains used by NS. The tender for these trains began in July 2022 with a request for information (RFI) from European manufacturers. Given sprinter services stop at all stations, the train needed to have quick acceleration and deceleration with a top speed of 160km/h. There was also, interestingly, a requirement that the train could also be used for intercity services. I’ve noted a number of times NS using sprinter trains for intercity services but this was the first time it’s explicitly called out in the tender. The reasoning for this requirement was to meet flexible passenger growth and demand. I guess this is where the flex in the name comes from. Read more...

When working on an AWS account it’s sometimes useful to have CLI access to run commands that automate repetitive tasks or to get to pesky resources that don’t show up on the console. If you federate into an AWS account through Identity Center you could simply get the credentials through the portal when selecting an account. If you get console access through other means those credentials are not always available. Read more...

Amazon S3 provides multiple storage classes depending on your object’s access patterns and requirements for retrieval speeds. S3 Standard, Infrequent Access and Glacier Instance Retrieval all provide millisecond first-byte latency for object retrievals but charge different rates per GB of data stored and retrieved. Generally speaking, the colder a storage tier is, the cheaper it is to store data, but the more expensive it gets to retrieve. For this example, I’ll only be comparing three storage classes that offer millisecond first-byte data retrieval. Read more...

I was not expecting a large amount of press coverage on bicycle gutters at train stations, but it makes sense given that this is the Netherlands. ProRail, in a weird move, based on their internal investigation and reports, has a new policy where no bicycle gutters will be installed at staircases in new or renovated stations. These gutters are channels at the side of staircases designed to fit bicycle wheels, allowing you to push your bicycle up and down the stairs. They can be found at many stations in the Netherlands, except for the recently renovated Ede-Wageningen and Groningen stations, where ProRail advises cyclists to rely on the elevator or ramps, where available. Read more...

Recently, I updated a Stack Overflow answer to include some information on Lake Formation that was new to me: resource links. The answer also covered a few other methods to query data cataloged in Glue across accounts and regions. Here’s the setup: you have a Glue Data Catalog and a S3 bucket in an AWS account called Owner Account, and there are users in different AWS accounts and regions that would like access to this data. For the sake of explanation, we’ll focus on one account that needs access in a different region; this account will be called Query Account. Read more...

TL;DR: There may come a time when you need to build a ZFS pool in a temporarily degraded state. Reddit user u/mercenary_sysadmin describes how this is done, and this post provides additional commentary. The approach uses a temporary file in place of the disk, then taking it offline resulting in a degraded pool. When the physical disk is available, the file can be replaced with the actual disk in the pool. My desktop sits idle most of the time as I’ve switched to using my laptop for day-to-day tasks, which seemed like a waste of hardware. Meanwhile, my NAS, running off an 8TB WD Elements drive connected via USB to a ThinkCentre M93p, could use an upgrade. The plan was to set up my desktop as the new NAS with four 8TB WD drives in RAID-Z1. I already have the drives, plus one spare, lying around, so I thought it would be an easy installation, but two of the drives were dead. This left me with three good drives plus the WD Elements, which I then had to shuck. A backup of all critical data was already in place but the restore would have taken too much time, so I made the decision to set up a degraded ZFS pool with the three drives, copy the data over from the WD Elements, shuck it, and then introduce it to the pool. Read more...

A few weeks ago, I stumbled upon Excalidraw, which is a whiteboarding/diagramming tool that has a certain aesthetic. I liked the design of the diagrams I saw, so I decided to give it a try. Coming from drawio, I was immediately impressed with how intuitive it felt. After playing around with Excalidraw for an hour, I decided it was worth actually using for work, and so I hosted it locally on my machine. The setup was pretty easy to do; clone the repository, install the alarmingly many dependencies1, build the app, and then grab the static files from excalidraw-app/build and shove them behind a web server. Read more...

AWS Backup is a service that helps orchestrate, audit, and restore backups within and across AWS accounts. The content of this post are my personal notes on backup plans, and do not reflect the views of my employer. A core component of the AWS Backup service is the backup plan. The AWS documentation describes a backup plan as: […] a policy expression that defines when and how you want to back up your AWS resources. Read more...

May 5 is Liberation Day in the Netherlands, commemorating the country’s liberation from the Nazis in 1945. The day proceeds Remembrance Day, which honours those who died during the Second World War. Every five years Liberation Day is a public holiday in the Netherlands, and 2025 is was one of those years. I decided to use the day off and visit Keverdijk, a strip of road that sits on the Nieuwe Keverdijksche Polder, the road features a protected level crossing on the railway arch that connects the Flevolijn to the Gooilijn called the Gooiboog. Joining Almere to Hilversum, the Gooilijn itself also goes through Weesp to Amsterdam. I didn’t have a particular need to go there, other than that I’d been there a few months prior and thought it was a good place to watch and film trains. Read more...

In my foray into becoming more active on StackOverflow I came across a question from 7 years ago asking how to use Grafana with Amazon Cognito. I’m sure they either figured something out or no longer need an answer but I gave a stab at answering it anyways. This post will be a step-by-step guide on setting up authentication for self-hosted Grafana through Amazon Cognito using the generic OAuth method. I assume a Cognito user pool is already created and a Grafana instance sits behind a domain with TLS.1 The first section will go over creating an app client in Cognito, then configuring Grafana with the values you got from Cognito, and in the last section I will cover some errors and provide troubelshooting tips. Read more...

I’ve been spending more time browsing StackOverflow recently and came across a question asking if it was possible to find duplicate objects within an S3 bucket. One way would be to hash the object prior to upload and store the value in a local or remote data store. If that’s not possible or too much overhead, I figured I could use S3 Metadata and Athena to solve this, services I’ve covered on this blog not too long ago. Athena alone has come up a few times this year, just because I’ve been finding interesting use cases for it. While I am an AWS employee, everything I’ve written, and will write, on this blog has always been out of personal interest. There are no sponsored posts here and all opinions are all my own. Read more...

In 1994, Deutsche Bahn (DB) placed an order for 13 ICE 3M trains. These were the international variants of the 50 ICE 3 trains that would enter service in 1998. The “M” in 3M stands for mehrsystemfähig, as the trainsets would be able to operate under different power supplies, initially for Germany and the Netherlands and later in Switzerland, Belgium, and France. To supplement DB’s order, the Dutch Railway (NS) purchased an additional four ICE 3M trains in 1995. The trains were built by Siemens and Bombardier and are closely related to the modern Siemens Velaro family of trains. Read more...

Amazon S3 Intelligent-Tiering moves your data to the most cost-effective S3 storage tier based on the object’s access pattern for the price of $0.0025 per 1,000 objects it monitors. Since the movement is done by the service you don’t know, or need to know, the access tier the object is currently in as all objects can be retrieved asychronously. If you opt-in for asynchronous archive tiers, you can find out if an object is in one of these tiers by requesting the HEAD of an object. This only works for these opt-in tiers, if you’d like to find out if the object is in the Frequent Access, Infrequent Access or Archive Instance Access tiers you will need to refer to the Amazon S3 Inventory. The S3 Inventory provides a snapshot of your object’s metadata at a daily or weekly frequency, this snapshot also includes S3 Intelligent-Tiering access tier, the key we are interested in. Read more...

Last month, my homelab experienced an incident that resulted in service disruption for 3 hours and 8 minutes, and because I like to cosplay as a sysadmin in my free time this is a post-incident analysis. The effects of the disruption were mostly external, mainly affecting the main site and ytrss, internal systems remained unaffected. A virtual machine hosted on Linode needed to be moved between physical hosts for urgent and unplanned maintenance. A similar situation has happened in the past both as planned and unplanned events, so I had opportunities to prepare, but this still resulted in a failure to automatically recover this time. Several improvements were made to my infrastructure and deployment strategy, which resulted in this disruption being shorter than most but still longer than expected. Read more...

Ben Welsh and Katlyn Alo have created a course that walks through running your first Athena query, complete with sample data. I’ve written about Athena a few times on this blog and the course works as a great primer. This post will act as an addendum to the guide, specifically step 4, where you create an Athena database and table. A database, in Athena, holds one or more tables, and the table points to the data and what schema it’s in. The creation of these resources in the guide follows a pattern I’ve seen a lot where the database and table are created using SQL through Athena. It’s simple, and does the job, but I’d like to document how to create a table and database using AWS Glue, an extract-transform-load data service, and highlight some comparisons between the two methods. Read more...

On 5 March 2025, the Dutch Railways (NS) presented a model of their interior for the Dubbeldekker Nieuwe Generatie (Double-Decker New Generation), or DDNG for short. This train will be introduced in 2029 to replace the ageing DDZ and provide additional capacity to intercity services. I was going to write an overview of the DDNG and realised the train did not have an English Wikipedia page yet, so I created that instead. I’ll use this post to cover the most important details with my commentary. Read more...

Recently, Simon Willison shared how he uses S3 event notifications with Lambda and DynamoDB to list recently uploaded files from an S3 bucket. The first thought that occurred to me was to use S3 inventory which provides a daily catalog of objects within a bucket queriable through Athena. The second idea involved doing the same with the recently announced S3 metadata feature. Both methods, I discovered, were already commented on by others. In this post, I want to explore the S3 metadata method to get my feet wet with the service. Read more...

Last month, AWS announced multi-session support natively in the AWS console; previously I’d relied on Firefox containers to separate logins between accounts. This can be easily enabled from the account drop-down in the top right of the console. Multi-session support enabled and the usual account ID and IAM role is visible in the top right. Read more...

While trying to test recovery of a service from a backup, as everyone should, I discovered a container image was no longer available from Docker Hub anymore. I was greeted by the following error: ERROR: The image for the service you're trying to recreate has been removed. If you continue, volume data could be lost. Consider backing up your data before continuing. Continue with the new image? [yN] Since I had a perfectly healthy and running instance of the service on my homelab which I could use to save the image from that I could then include in my backup copy. Read more...

The New Jersey Transit Corporation (NJ Transit) operates bus, light rail, and commuter rail services for the population of New Jersey. For the purposes of this post, we’ll be looking at the River LINE, one of three light rail systems operated by NJ Transit. This is part of an ongoing series to explore Stadler rolling stock deployments in the United States, and New Jersey Transit was the first, in the US, to purchase from Stadler in the early 2000s. Read more...

Earlier this month Google announced a software update to the Pixel 4a, under the Pixel 4a Battery Performance Program. This comes after going without any software update since 2023. For users of the Pixel 4a, this update claimed to “improve the stability of their battery’s performance”. However, for some devices, this update would have negative effects which “reduced available battery capacity and impacts charging performance”. For devices that are negatively impacted, Google would offer a battery replacement or monetary compensation where a replacement is not possible. The press coverage on the announcement was met with skepticism and so was the general opinion on social media and forums. I, on the other hand, was hopeful. After all, the announcement says the update will mean the battery performance would be the same as before, and if not, your phone is an “Impacted Device” which Google is already aware of and would offer a replacement for. Read more...

Data sources are used to retrieve information outside of Terraform, in this case default VPC, subnets, security group and internet gateway resources provisioned in a region within an AWS account. Each opted-in region within an AWS account comes with default network resources, with can be used to provision resources within a default subnet, use the default internet gateway or security group for provisoned resources and more. Retrieve the default VPC The default VPC can be retrieved using the aws_vpc data source and the default argument. We will use the default VPC ID to retrieve all other default network resources. Read more...

AWS Identity Center is a service that allows you to manage and control user access to AWS accounts or applications. The user identities and groups can be provisioned from an external Identity Provider, like Okta or Keycloak, or managed directly within IAM Identity Center. Disclaimer: Do not take the information here as a good or best practice. The purpose of this site is to post my learnings in somewhat real-time. For the purposes of this post we will only care about managing access to existing AWS accounts, and assume the users and/or groups are already present. This will serve as a reminder for me on what order of operations to each perform tasks. Read more...

Over the last two years, I have been blogging consistently here; this was something I last achieved in the early 2010s. Around 2011, I had a blog where I posted commentary on consumer technology news and the occasional tutorial/guide, which was used on and off until 2014 and is now lost to the internet. In 2016, I pieced together a portfolio website to have somewhere to link to when applying for jobs. I wanted to include a blog on the site, but I couldn’t muster up the creativity to write anything. Nothing I wanted to say was novel or worth sharing, so that part of the site was left empty for a while. Read more...

Schedules, events and alarms can be shared using the iCalendar data format regardless of the Calendar service or application like Google Calendar or Outlook. This format is defined in RFC 5545. Creating iCalendar files can be done in Python using the icalendar package. I’ve outlined a few example scenarios below. The package documentation has more details on usage. Installing the package pip install icalendar Other methods are available in the official documentation. Read more...

Does IKEA have no shelf space for slower-moving items in the self-service furniture area? My wife and I hadn’t seen this before, but a few items just say “Place your order for this product at the search and order kiosk or ask a co-worker”1 instead of the usual row and shelf numbers. Product tag with article number asking to place the order at a search and order kiosk or to ask a co-worker Read more...

On 5 September 1964, the last tram ran in the city of Luxembourg from the district of Beggen. First introduced in 1875 in the form of horse-drawn carriages on rails, trams helped transport passengers to and from the central train station in the country’s capital to the north of the city. The construction was funded by the city and the company SATL, Société Anonyme du Tramway Luxembourgeois, was created to operate the trams. Read more...

sqlite3 CLI Using the sqlite3 CLI allows you to import CSV files into a new or existing database file. The following multi-line command will import the CSV file, disruptions.csv into the disruptions table. All columns will be of type TEXT if created by the import command. sqlite3 data.db <<EOS .mode csv .import disruptions.csv disruptions EOS The command infers the input file type by the output mode (.mode csv), otherwise use --csv in the import command. Read more...

The Dutch Railway, NS, has not been having a good week, in fact, this Monday NS reported the lowest punctuality score this year with 72.3% of passengers arriving to their destination with less than a five-minute delay, the average is around 90%. This week has been difficult due to several different factors. There were a few very unfortunate incidents between trains and passengers on the track on Monday. From Monday, no trains ran between Groningen and Groningen Europapark because of a land subsidence the day before after work on a bicycle tunnel, this would take a few days to fix. On Tuesday morning a car crashed into a train while part of a police chase near Oss, affecting the Nijmegen-’s-Hertogenbosch line. There is a overarching problem with international passenger and freight trains to Germany as works just across the border have begun. The list goes on. Read more...

It’s an open secret that you can follow YouTube channels through RSS, it’s also something I’ve covered on this blog before. What I wasn’t aware of until recently was how difficult it could be to find the RSS feed for a YouTube channel. I mistakenly thought any RSS service could discover the feed URL from a YouTube channel, but after chatting with Andreas (82Mhz) on Mastodon we discovered this wasn’t the case. It was just a feature of Miniflux which is the RSS service and client that I used. Read more...

In my last post, I praised the NS International app, while it’s user-friendly and frankly better than some of the other apps or websites I’ve used there is still room for improvement. I’ll use a recent trip to Leuven from the Netherlands as an example. The roughly 3-hour trip was booked over a month in advance and I was able to get a cheaper price through the Early Bird discount. Unlike the usual Flex fare ticket, you must take the same Intercity Brussels train as stated on your travel itinerary unless any previous train you were on is delayed.1 I was meant to take the train to Schiphol Airport where I would catch the Intercity Brussels train to Mechelen and transfer to Leuven. Read more...

Train for Metz-Ville at Luxembourg station. This month I had to travel to Metz and decided to book the trip by train from Utrecht. The other option was to fly from the Netherlands to Luxembourg and take the train across the border to Metz, France. I’m happy to say the 7-hour journey by train went great. There were a few minutes of delay in places but the transfer times between trains were enough of a buffer. Read more...

At the time of writing this, the 50:HERTZ Club Train should be returning to Amsterdam Centraal after its final trip for the weekend. The Amsterdam Dance Event (ADE) is held every October with conferences and festivals for professionals in the industry and festivalgoers. This year 50:HERTZ organised the “Club Train” consisting of eight separate 4-ish hour trips all starting and ending at Amsterdam Centraal. The trips were between Friday 18th October and Sunday 20th October each with their line-up of DJs with stages (or clubs) per train ride. The line-up and times can be found on the ADE website but I’ll also summarise the list here: Read more...

Tucked away in the fields of Bussnang, Switzerland is the headquarters of one of the world’s largest railway equipment manufacturers, Stadler Rail. Well-known for its configurable high-speed, intercity, and regional trains such as the SMILE, KISS, FLIRT, and GTW, Stadler also manufactures trams, locomotives, and other custom equipment such as rack railway rolling stock. You can find their equipment being used in many countries, including the Netherlands, Germany, Hungary, Norway, Turkey, the UK, Saudi Arabia, Azerbaijan, and the US. Read more...

FFmpeg has the ability to stabilise a video using a 2 pass approach. I first learnt about this from a post on Paul Irish’s website and later also shared the link. Their post also includes a useful single command to stabilise and create a comparison video to see the before and after. The purpose of my entry is to add some references and commands that I’ve found useful mostly for me to look up later. Read more...

The Netherlands has a fairly large and busy railway network with close to 400 passenger stations on 3000 line kilometres and with its largest operator, NS, transporting over 1 million passengers per day. Where rail meets road there are over 2000 crossings throughout the country. That comes out to a crossing every 1.3 kilometres on average.1 Given the high density of rail traffic and the number of level crossings, the safety of road and rail users is important. The Dutch Safety Board has said taking into account the volume of traffic on both rail and road, number of level crossings and casualties the Netherlands fairs well compared to 25 other European countries. That being said there’s always room for improvement and efforts have been made to reduce the number of casualties most notably in the form of two programs, the LVO and NABO. Read more...

After years of delays, the drielandentrein finally started operating at the end of June this year. However, despite all the planning and waiting, the train connection between the three countries is not without its hiccups. Earlier this week, Rover, the public transport traveller’s association, expressed their disappointment with the reliability of the drielandentrein. For starters, Arriva still has staff shortages which started during the pandemic and shortages in train equipment. In an interview with L1 News, Arriva responded by saying they are actively recruiting and training drivers and take immediate action to repair any issues on the trains. It would be interesting to understand the nature of these equipment failures and if they were also observed during the tests. Read more...

Grafana has the ability to use Amazon Athena as a data source allowing you to run SQL queries to visualize data. The Athena table data types are conveniently inherited in Grafana to be used in dashboard panels. If the data types in Athena are not exactly how you’d like them in Grafana you can still apply conversion functions. In this case the timestamp column in Athena is formatted as a string, and I do not have the ability to adjust the table in Athena (which is normally what you’d want to do). If your Athena table doesn’t have a column in a DATE, TIMESTAMP or TIME format you will not be able to natively use a panel that relies on a timestamp. You can parse the timestamp string using the parse_datetime() function that expects the string, and the format the string is in. This columns will now appear as a timestamp to Grafana. Read more...

The Dutch Railway, NS, runs a few long train routes in the Netherlands and at times these routes may seem a bit “illogical”. An example of this in the July 2024 edition of the NS Panel news brief is the route from Dordrecht to Venlo through Schiphol. This train starts in the south, travels north to Schiphol and heads south again to Venlo. Even with all the major stops listed on the platform departure screen, this route may still confuse some passengers, especially if other quicker train connections exist between the two cities exist. Read more...

Exporting the results of a query can be useful to import it into other tools for data preparation or visualisation particularly as a CSV file. sqlite3 CLI Using the SQLite3 CLI allows you to set the query result mode to CSV and output that result to a file. A number of different output formats, including custom separators can be set as well. Read more...