UUIDv7 in PostgreSQL

And another UUID function. This one also generates UUIDv7, just like the the one in the previous post

, but this one is designed to work in PostgresSQL, instead of MySQL 
SELECT CONCAT(
	OVERLAY(LPAD(TO_HEX(FLOOR(EXTRACT('EPOCH' FROM NOW()::TIMESTAMP(3)) * 1000)::BIGINT), 12, '0') PLACING '-' FROM 9 FOR 0),
	'-7',
	LPAD(TO_HEX(FLOOR(RANDOM() * 0x1000)::BIGINT), 3, '0'),
	'-',
	TO_HEX(0x8000 | FLOOR(RANDOM() * 0x4000)::BIGINT),
	'-',
	LPAD(TO_HEX(FLOOR(RANDOM() * 0x1000000000000)::BIGINT), 12, '0')
)::UUID AS uuidv7;

As before: either use this inline in your select statement, or convert it to a function.

January 30, 2025 – 12:33 | By Itsacon | Posted in Computers, Web development | Tagged , | Comments (0)

UUIDv7 in MySQL

Similar to my previous post, this code generates a UUID of the new v7 type, which has a Unix-timestamp base. This keeps UUIDs sortable by creation-date, which is useful when using them as database keys, for example You can either use this inline in your select statement, or convert it to a function.

Read More →

April 24, 2023 – 14:45 | By Itsacon | Posted in Computers, Web development | Tagged , | Comments (0)

UUIDv4 in MySQL

Although MySQL has a UUID() function, it returns a version 1 UUID, which is time-based and has mostly been replaced by the completely random version 4. I recently needed a v4 in a query, and adapted this from some different options I found online: You can either use this inline in your select statement, or convert […]

Read More →

March 20, 2023 – 08:43 | By Itsacon | Posted in Computers, Web development | Tagged , | Comments (0)

The Battle for Ducosi

Angel of Redemption, Dark Angels battle barge, 017M41.032.1130. From: Ikhnaton, fourth Company Grand Master, Master of the Fleet To: Azrael, Dark Angels Supreme Grand Master My lord, attached my report on our recent battle against the ancient enemy. We had been deploying our battle-brothers to the main planet of the Lothar system, when Rubicon squadron, send […]

Read More →

February 1, 2017 – 15:08 | By Itsacon | Posted in Background, Battlefleet Gothic | Comments (0)

Orc Blood Bowl team

With the re-release of this old classic last week, it’s time to show another of my Blood Bowl teams: Orcs. Like my human team these were painted according to the ‘How to paint’ leaflet that came with the third edition Blood Bowl set. This meant that they ended up as the Gouged Eye. As with […]

Read More →

November 29, 2016 – 13:39 | By Itsacon | Posted in Blood Bowl | Comments (0)

Librarian on bike

Just a quick one today: My recently completed bike-mounted librarian conversion. As always, Dark Angels. Conversion The bike is mostly the bike from the old bike-mounted chaplain kit. Which in turn was just a normal bike with a few metal bits added on: A fancier front guard, some items on the back and holstered boltgun. […]

Read More →

October 14, 2016 – 08:26 | By Itsacon | Posted in 40k | Comments (0)

Battlefleet Gothic: First ships

As I mentioned earlier, one of my goals for this year is to get a playable fleet ready for Battlefleet Gothic. Over the past month, I’ve done just that: Get started. Coming weekend, I’ll be playing a few games, and to that end I’ve been busy painting up a 1750 point Space Marine fleet. I […]

Read More →

September 28, 2016 – 13:11 | By Itsacon | Posted in Battlefleet Gothic | Comments (0)

Mortis Pattern Dreadnought conversion

A while back I noticed my bit box contained two complete metal Dark Angel Dreadnoughts. The model with a lascannon and a missile launcher. I decided to combine them into a Mortis pattern dreadnought. This is an anti-air version of the dreadnought, which has two identical weapon arms and can gain the Skyfire special rule […]

Read More →

September 22, 2016 – 10:46 | By Itsacon | Posted in 40k | Comments (0)

Human Blood Bowl team

Another one of the old Specialist Games I’m a big fan of is Blood Bowl. I own three teams: My own primary teams is Dwarfs. But I also have the two teams that came with the third edition starter set (Humans and Orcs), which I use when I demonstrate the game to people. There is […]

Read More →

September 6, 2016 – 09:13 | By Itsacon | Posted in Blood Bowl | Comments (1)

Warhammer Quest — Core game pieces

As I said previously, one of my goals for this year is finishing the models for my 1995 Warhammer Quest set. By now, I’ve finished all the core game pieces, i.e., the models you need every game, so have some pictures! About Warhammer Quest For those that don’t know, Warhammer Quest is a co-op game […]

Read More →

August 31, 2016 – 15:09 | By Itsacon | Posted in Warhammer Quest | Comments (0)