| // Credits to Louistiti from Drizzle Discord: https://discord.com/channels/1043890932593987624/1130802621750448160/1143083373535973406 | |
| import { sql } from "drizzle-orm"; | |
| const clearDb = async (): Promise<void> => { | |
| const query = sql<string>`SELECT table_name | |
| FROM information_schema.tables | |
| WHERE table_schema = 'public' | |
| AND table_type = 'BASE TABLE'; | |
| `; |
| { | |
| // Commented-out options have their default values. | |
| "include": ["src/**/*"], | |
| "exclude": ["node_modules/*"], | |
| // "files": [], // A list of relative or absolute file paths to include. | |
| // "extends": "", // A string containing a path to another configuration file to inherit from. | |
| // "references": [], // An array of objects `{"path": "./to/dirOrConfig"}` that specifies projects to reference. | |
| // "compileOnSave": false, // Signals to the IDE to generate all files for a given tsconfig.json upon saving. | |
| "compilerOptions": { |
| # scaffold your project | |
| npx preact-cli@rc create default my-app && cd my-app | |
| # upgrade to Preact X | |
| npm i -D preact-cli@rc && npm i preact@latest preact-router@latest preact-render-to-string@latest | |
| npm rm preact-compat |
| // Iterated from: https://stackoverflow.com/questions/10599933/convert-long-number-into-abbreviated-string-in-javascript-with-a-special-shortn | |
| function abbreviateNumber(value) { | |
| let newValue = value; | |
| const suffixes = ["", "K", "M", "B","T"]; | |
| let suffixNum = 0; | |
| while (newValue >= 1000) { | |
| newValue /= 1000; | |
| suffixNum++; | |
| } |
| "use strict"; | |
| /** | |
| * Hypertext Transfer Protocol (HTTP) response status codes. | |
| * @see {@link https://en.wikipedia.org/wiki/List_of_HTTP_status_codes} | |
| */ | |
| enum HttpStatusCode { | |
| /** | |
| * The server has received the request headers and the client should proceed to send the request body |
| defmodule Map.Helpers do | |
| @moduledoc """ | |
| Functions to transform maps | |
| """ | |
| @doc """ | |
| Convert map string camelCase keys to underscore_keys | |
| """ | |
| def underscore_keys(nil), do: nil |
When hosting our web applications, we often have one public IP
address (i.e., an IP address visible to the outside world)
using which we want to host multiple web apps. For example, one
may wants to host three different web apps respectively for
example1.com, example2.com, and example1.com/images on
the same machine using a single IP address.
How can we do that? Well, the good news is Internet browsers
#Simple Authentication with Bcrypt
This tutorial is for adding authentication to a vanilla Ruby on Rails app using Bcrypt and has_secure_password.
The steps below are based on Ryan Bates's approach from Railscast #250 Authentication from Scratch (revised).
You can see the final source code here: repo. I began with a stock rails app using rails new gif_vault
##Steps
| # As root user | |
| sudo su | |
| # Update the OS | |
| sudo apt-get update -y | |
| # Add this to ~/.bashrc to remove timezone warnings | |
| echo 'export LC_ALL="en_US.UTF-8"' >> ~/.bashrc | |
| source ~/.bashrc |