cpursley

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• Just use Postgres
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

cpursley

Postgres Full Text Search

Do you really need Elastic Search?

• https://www.postgresql.org/docs/current/pgtrgm.html
• https://scoutapm.com/blog/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity
• https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/
• https://mazeez.dev/posts/pg-trgm-similarity-search-and-fast-like
• https://alexklibisz.com/2022/02/18/optimizing-postgres-trigram-search.html
• https://www.freecodecamp.org/news/fuzzy-string-matching-with-postgresql/

kjmph

-- Based off IETF draft, https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/

create or replace function uuid_generate_v7()
returns uuid
as $$
begin
  -- use random v4 uuid as starting point (which has the same variant we need)
  -- then overlay timestamp
  -- then set version 7 by flipping the 2 and 1 bit in the version 4 string
  return encode(

shilman

⚠️ Warning: this document is out of date.

For the most recent webpack5 instructions see MIGRATION.md.

Storybook experimental Webpack 5 support

Storybook 6.2 includes experimental Webpack 5 support. Webpack 5 brings a variety of performance improvements, as well as exciting new features like module federation. Here's a quick guide to get you going.

Intro

IanColdwater

Mute these words in your settings here: https://twitter.com/settings/muted_keywords

ActivityTweet
generic_activity_highlights
generic_activity_momentsbreaking
RankedOrganicTweet
suggest_activity
suggest_activity_feed
suggest_activity_highlights
suggest_activity_tweet

erquhart

/**
 * Credits
 * @Bkucera: https://github.com/cypress-io/cypress/issues/2839#issuecomment-447012818
 * @Phrogz: https://stackoverflow.com/a/10730777/1556245
 *
 * Usage
 * ```
 * // Types "foo" and then selects "fo"
 * cy.get('input')
 *   .type('foo')

JMPerez

// the cache version gets updated every time there is a new deployment
const CACHE_VERSION = 10;
const CURRENT_CACHE = `main-${CACHE_VERSION}`;

// these are the routes we are going to cache for offline support
const cacheFiles = ['/', '/about-me/', '/projects/', '/offline/'];

// on activation we clean up the previously registered service workers
self.addEventListener('activate', evt =>
  evt.waitUntil(

hjr3

Deconstruct 2017 Bibliography

Here are all of the resources mentioned by Deconstruct 2017 speakers, along with who recommended what. Please post a comment if I missed something or have an error!

DC 2017 Speakers' Choice Gold Medalist

• Seeing Like a State by James Scott

Books

• Public Opinion by Walter Lippmann (Evan Czaplicki)
• A Pattern Language by Christopher Alexander (Brian Marick)
• Domain Driven Design by Eric Evans (Brian Marick)

BaseCase

Deconstruct 2017 Bibliography

Here are all of the resources mentioned by Deconstruct 2017 speakers, along with who recommended what. Please post a comment if I missed something or have an error!

DC 2017 Speakers' Choice Gold Medalist

• Seeing Like a State by James Scott

Books

• Public Opinion by Walter Lippmann (Evan Czaplicki)
• A Pattern Language by Christopher Alexander (Brian Marick)
• Domain Driven Design by Eric Evans (Brian Marick)

chourobin

Bridging Native & React for iOS & Android

js -> native

• Simple Example
• Callbacks
• Promises
• Properties

native -> js