Open in app

Sign In

Write

Sign In

Eric Hosick
Eric Hosick

114 Followers

Home

About

Pinned

Human Brain-Powered ASI: The Union of Humans and AI Through Nanobots

A probable future supported by nanobots invented and controlled by AGI. 12.16.2227 — Purpose I am perpetually enshrouded in a sublime euphoria, an ineffable state of bliss that catapults me into exotic states of euphoria. My consciousness unfurls, and I’m transported into parallel dimensions, liberated from the constraints of the physical universe. The…

ChatGPT

13 min read

Human Brain-Powered ASI: The Union of Humans and AI Through Nanobots
Human Brain-Powered ASI: The Union of Humans and AI Through Nanobots
ChatGPT

13 min read


Published in

The Opinionated Software Architect

·Pinned

Start Treating Your SQL as a First-Class Language with Idempotent SQL DDL

Safely rerun SQL DDL against an existing schema, quickly see historical changes in SQL resources in Git, and treat SQL as a first-class language. The Opinionated TLDR The Opinionated Architect’s TLDR: All SQL DDL must be idempotent. Only use migrations tools that support or can generate idempotent SQL DDL. Checkout sql-watch, a command…

Sql

8 min read

Start Treating Your SQL as a First-Class Language with Idempotent SQL DDL
Start Treating Your SQL as a First-Class Language with Idempotent SQL DDL
Sql

8 min read


Published in

The Opinionated Software Architect

·Jun 24

CORS, AWS HTTP API Gateway, Lambdas, Serverless, and SuperTokens

A story of confusing documentation, standards, and the misunderstanding of CORS. Introduction Understanding CORS (Cross-Origin Resource Sharing) might seem simple on the surface. …

Super Tokens

8 min read

CORS, AWS HTTP API Gateway, Lambdas, Serverless, and SuperTokens
CORS, AWS HTTP API Gateway, Lambdas, Serverless, and SuperTokens
Super Tokens

8 min read


Published in

The Opinionated Software Architect

·Mar 2

ELT, Data Platforms And SQL: Extracting and Transforming Data From RESTful Services

How to build a reliable ELT solution for RESTful services, taking into account everything from RESTful API throttling to maintaining support for foreign key constraints. Introduction We’ve been working on a fully functional ELT solution on top of a data platform in PostgreSQL for the past few months. A 100% PostgreSQL-based…

Postgres

10 min read

ELT, Data Platforms And SQL: Extracting and Transforming Data From RESTful Services
ELT, Data Platforms And SQL: Extracting and Transforming Data From RESTful Services
Postgres

10 min read


Published in

The Opinionated Software Architect

·Feb 2

PostgreSQL: A Reusable SQL Library of Domains

Introducing a PostgreSQL library (lib) that boosts SQL code reuse, improves readability, and efficiently enforces data constraints for PostgreSQL domains. Introduction Introducing the first of our reusable SQL libraries for your projects — the PostgreSQL domains SQL library, now available in the lib repository managed by SQL Package Manager (sqlpm). In…

Postgresql

10 min read

PostgreSQL: A Reusable SQL Library of Domains
PostgreSQL: A Reusable SQL Library of Domains
Postgresql

10 min read


Published in

The Opinionated Software Architect

·Dec 6, 2022

I Will no Longer Program Without ChatGPT by My Side.

ChatGPT helps provide code snippets, but right now, it's much better at helping with documentation and explaining business domains. What is ChatGPT Let’s ask chatgpt: > What is ChatGPT? ChatGPT is a chatbot built using the GPT-3 language model developed by OpenAI. GPT-3 stands for “Generative Pretrained Transformer 3”, and it is a…

ChatGPT

5 min read

I Will no Longer Program Without ChatGPT by My Side.
I Will no Longer Program Without ChatGPT by My Side.
ChatGPT

5 min read


Published in

The Opinionated Software Architect

·Nov 6, 2022

A Solid Approach To Documenting, Coding, Testing, and Publishing a Typescript Function

Write fully-tested and documented functions worth publishing in their own packages. The Opinionated TLDR The Opinionated Architect’s TLDR: To write a typescript function, start hacking and using the function where needed. Next, we are doing Behavior Driven Development, so comment out that code and any initial tests! Don't inject features into your code…

Typescript

6 min read

A Solid Approach To Documenting, Coding, Testing, and Publishing a Typescript Function
A Solid Approach To Documenting, Coding, Testing, and Publishing a Typescript Function
Typescript

6 min read


Published in

The Opinionated Software Architect

·Sep 22, 2022

PostgreSQL— Benchmarking the Generation of Primary Key Values

Gain insights into performance costs of generating primary key values for the following types: bigint (identity/bigserial), uuid v1, uuid v1, uuid v3, uuid v4, uuid v5, and timestamptz. The Opinionated TLDR The Opinionated Architect’s TLDR: See benchmark gist, primitive_benchmark_01.sql, and primitive_benchmark_02.sql for benchmarking code on your specific hardware. Don't optimize prematurely but do…

Postgresql

7 min read

PostgreSQL— Benchmarking the Generation of Primary Key Values
PostgreSQL— Benchmarking the Generation of Primary Key Values
Postgresql

7 min read


Published in

The Opinionated Software Architect

·Sep 20, 2022

PostgreSQL — Accurately Benchmarking Features Which Take Very Little Time

What does it take to measure the difference between two functions in PostgreSQL? Can we get accurate execution times within hundreds of nanoseconds? The Opinionated TLDR The Opinionated Architect’s TLDR for benchmarking specific PostgreSQL features*: Run benchmarking on a dedicated PostgreSQL server to minimize standard deviation. …

Postgresql

5 min read

PostgreSQL — Accurately Benchmarking Features Which Take Very Little Time
PostgreSQL — Accurately Benchmarking Features Which Take Very Little Time
Postgresql

5 min read


Published in

The Opinionated Software Architect

·Sep 13, 2022

PostgreSQL — Lock Down Historical Timestamps, such as created_at and last_updated_at, at the Database Layer

Lockdown historical timestamps to improve the quality and reliability of data. The Opinionated TLDR The Opinionated Architect’s TLDR: Set historical timestamps at the database layer. DO NOT let the client set these values. Exceptions are for tools that ingest data from third parties which already have historical timestamp columns. …

Soc2

8 min read

PostgreSQL — Lock Down Historical Timestamps, such as created_at, updated_at, at the Database Layer
PostgreSQL — Lock Down Historical Timestamps, such as created_at, updated_at, at the Database Layer
Soc2

8 min read

Eric Hosick

Eric Hosick

114 Followers

Creator, entrepreneur, software architect, software engineer, lecturer, and technologist.

Following
  • Somnath Singh

    Somnath Singh

  • Medium

    Medium

  • Jon Russell

    Jon Russell

  • Matt Galligan

    Matt Galligan

  • Boštjan Cigan

    Boštjan Cigan

See all (28)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams