Lalit Kapoor lalitkapoor

The experience of using Node.JS with TypeScript, ts-node, and ESM is horrible.

There are countless guides of how to integrate them, but none of them seem to work.

Here's what worked for me.

Just add the following files and run npm run dev. You'll be good to go!

`package.json`

https://lmu.lge.com/ExternalService/lgscreenmanager/mac/FW/22MD4KA_MP7/FWLatestVersion.txt https://lmu.lge.com/ExternalService/lgscreenmanager/mac/FW/27MD5KA_MP4/FWLatestVersion.txt https://lmu.lge.com/ExternalService/lgscreenmanager/mac/FW/27MD5KL_TBT_PD/FWLatestVersion.txt https://lmu.lge.com/ExternalService/lgscreenmanager/mac/FW/24MD4KL_TBT_PD/FWLatestVersion.txt

https://lmu.lge.com/ExternalService/lgscreenmanager/mac/FW/22MD4KA_MP7/ https://lmu.lge.com/ExternalService/lgscreenmanager/mac/FW/27MD5KA_MP4/ https://lmu.lge.com/ExternalService/lgscreenmanager/mac/FW/27MD5KL_TBT_PD/ https://lmu.lge.com/ExternalService/lgscreenmanager/mac/FW/24MD4KL_TBT_PD/

This gist lists challenges you run into when building offline-first applications based on IndexedDB, including open-source libraries like Firebase, pouchdb and AWS amplify (more).

Note that some of the following issues affect only Safari. Out of the major browsers, Chrome's IndexedDB implementation is the best.

Backing file on disk (WAL file) keeps growing (Safari)

When this bug occurs, every time you use the indexeddb, the WAL file grows. Garbage collection doesn't seem to be working, so after a while, you end up with gigabytes of data.

Random exceptions when working with a large number of indexeddb databases (Safari)

Errmojis

Users have a hard time dealing with errors.

To solve that, put these emojis prominently in your error messages. Then when the user says:

I dont know what happened but I saw a christmas tree and then everything stopped working

You'll know it was an internal error!

	import { drizzle } from "drizzle-orm/postgres-js";
	import postgres from "postgres";

	import { env } from "~/env.js";
	import * as schema from "./schema";

	import { type PostgresJsDatabase } from "drizzle-orm/postgres-js";

	// Fix for "sorry, too many clients already"
	declare global {

	#!/bin/bash

	# Copyright 2017 Théo Chamley
	# Permission is hereby granted, free of charge, to any person obtaining a copy of
	# this software and associated documentation files (the "Software"), to deal in the Software
	# without restriction, including without limitation the rights to use, copy, modify, merge,
	# publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons
	# to whom the Software is furnished to do so, subject to the following conditions:
	#
	# The above copyright notice and this permission notice shall be included in all copies or

	# full process. Ingests data from postgres to tb, calculates duplicates, inserts them to a new datasource and removes the rows from that datasource that appear in the original one.

	source $(pwd)/.env


	# related, to ingest data from postgres: https://blog.tinybird.co/2019/10/14/the-one-cron-job-that-will-speed-up-your-analytical-queries-in-postgres-a-hundred-fold/
	echo 'Ingesting most recently update jobs'
	psql $HEROKU_POSTGRES_URL -c "COPY (SELECT id, url, job_title, company, description, description_cleaned, date_posted, now() FROM job WHERE COALESCE(description, '') <> '' AND updated_at > now() - interval '70 minutes') TO STDOUT WITH (FORMAT CSV)" \| curl -F csv=@- "https://api.tinybird.co/v0/datasources?name=jobs&mode=append&token=$TINYBIRD_ADMIN_TOKEN";

	import { EChartOption } from 'echarts';

	declare interface _Format extends EChartOption.Tooltip.Format {
	marker: string;
	axisValueLabel: string;
	}

	const formatter: EChartOption.Tooltip.Formatter = function(params: _Format\|Array<_Format>, _ticket, _callback) {
	if(params instanceof Array) {
	if(params.length) {

	// This assumes Styled Components is in play, as well.
	//

	// Here we have the (too simple) React component which
	// we'll be rendering content into.
	//
	class Underlined extends React.Component<any, any> {
	public hole: HTMLElement \| null

	// We'll put the content into what we render using

	DROP TABLE IF EXISTS requests;

	CREATE TABLE requests (
	request_date Date,
	request_time DateTime,
	response_time Int,
	request_uri String)
	ENGINE = MergeTree(request_date, (request_time, request_uri), 8192);