Jeremy Foran jeremyforan

There are only two times I enjoy coding....coding for work or coding any time, outside of work.

jeremyforan / bf-www-blog-cloud-migration-json.json

Created January 3, 2023 21:47

jeremyforan / bf-www-blog-cloud-migration.sql

Created January 3, 2023 21:39

	update dbo.earth set node =
	case
	when node = '\' then '0'
	else '0' \|\| replace(left(node, length(node) - 1 ),'\', '.')
	end;

	alter table dbo.earth
	alter column node type ltree using node::ltree;

jeremyforan / bf-blog-post-create_postgres_sql.sql

Created January 3, 2023 21:32

	create schema dbo;

	create extension ltree schema public;

	create table dbo.earth (
	id serial primary key,
	node character varying(20),
	name character varying(20)
	);

jeremyforan / create_database.sql

Created January 3, 2023 21:16

	create database migrationdemo;
	GO

	use migrationdemo
	GO

	create table earth (
	id int identity(1,1) primary key,
	node hierarchyid,
	name varchar(20)

jeremyforan / main.go

Created December 30, 2020 02:00

Batching with timer