paulovieira

{
	"useTabs": true,
	"singleQuote": true,
	"trailingComma": "none",
	"printWidth": 100,
	"quoteProps": "preserve",
	"singleAttributePerLine": false,
	"svelteStrictMode": true,
	"svelteIndentScriptAndStyle": false,
	"htmlWhitespaceSensitivity": "strict",

paulovieira

# comment
MY_VAR_1=aaa
MY_VAR_2=bbb

paulovieira

Generally I can use QGIS and its DBManager to import data into a PostGIS database. Sometimes that doesn't work perfectly. ogr2ogr can help though. Here are a few approaches to getting data into PostGIS with ogr2ogr.

This is probably the most basic approach:

 ogr2ogr -f "PostgreSQL" PG:"dbname=<db name> user=<username> password=<password> host=<host> port=<port #>" input.geojson -nln schema.table

Running this little command seems to work if you have need to specify the geometry type (Source):

paulovieira

CREATE EXTENSION IF NOT EXISTS "unaccent"

CREATE OR REPLACE FUNCTION slugify("value" TEXT)
RETURNS TEXT AS $$
  -- removes accents (diacritic signs) from a given string --
  WITH "unaccented" AS (
    SELECT unaccent("value") AS "value"
  ),
  -- lowercases the string
  "lowercase" AS (

paulovieira

// reference: https://tailwindcss.com/docs/configuration

let Path = require('path');
let TailwindUi = require('@tailwindcss/ui')
let TailwindDebugScreens = require('./plugins/tailwindcss-debug-screens.js');  // customized: https://github.com/jorenvanhee/tailwindcss-debug-screens/issues/3
let TailwindFilters = require('tailwindcss-filters');

let defaultTheme = require('tailwindcss/defaultTheme')

console.log({ 'process.env.NODE_ENV': process.env.NODE_ENV });

paulovieira

#/etc/init.d/dropbox

start() {
    echo "Starting dropbox..."
    start-stop-daemon -b -o -c dropbox -S -x /home/dropbox/.dropbox-dist/dropboxd
}

stop() {
    echo "Stopping dropbox..."
    start-stop-daemon -o -c dropbox -K -x /home/dropbox/.dropbox-dist/dropboxd

paulovieira

var Nunjucks = states.getEngine("nunjucks");
var Hogan = states.getEngine("hogan");

paulovieira

var Fs = require("fs-extra");
//var slugify = require("underscore.string/slugify");
var _s = require("underscore.string");
var states = require("./lib/index.js");


// var Cheerio = require("cheerio");
// var $ = Cheerio.load("<div id='a'><span id='b'>xyz</span><span id='b'>123</span></div>")
// console.log($("#b").length)
// states.registerEngine("nunjucks", require('nunjucks'));

paulovieira

CREATE OR REPLACE FUNCTION public.json_append(data JSON, insert_data JSON)
  RETURNS JSON
LANGUAGE SQL
AS $$
SELECT
  ('{' || string_agg(to_json(key) || ':' || value, ',') || '}') :: JSON
FROM (
       SELECT
         *
       FROM json_each(data)