Abdelouahab Djoudi djoudi

Installing and Setting Up Metabase with Postgres

This guide is written for installation of Metabase on Ubuntu 18.04. Instead of using H2 as the application database, we will be using Postgres. You can opt to use MySQL as well. Please follow the steps below:

Update and install Java with proper configuration

sudo apt-get update

Learn you a Haskell - In a nutshell

This is a summary of the "Learn You A Haskell" online book under http://learnyouahaskell.com/chapters.

1. Introduction

Haskell is a functional programming language.

Usage

Put SearchTrait.php in app directory. Then use SearchTrait in your model, like so

use App\SearchTrait;
use Illuminate\Database\Eloquent\Model;

class Article extends Model 
{

Detect all Arabic Characters:

Summary:

  Arabic (0600—06FF, 225 characters)

  Arabic Supplement (0750—077F, 48 characters)

	axios({
	url: 'http://localhost:5000/static/example.pdf',
	method: 'GET',
	responseType: 'blob', // important
	}).then((response) => {
	const url = window.URL.createObjectURL(new Blob([response.data]));
	const link = document.createElement('a');
	link.href = url;
	link.setAttribute('download', 'file.pdf');
	document.body.appendChild(link);


	nano /etc/systemd/system/idempiere.service

	-----------------------------------

	[Unit]
	Description=Description for sample script goes here
	After=local-fs.target

	[Service]

	Run as sudo:
	sudo -i

	Update server:
	yum update -y

	aapanel install command:

	yum install -y wget && wget -O install.sh http://www.aapanel.com/script/install_6.0_en.sh && bash install.sh

	#!/bin/bash

	# This program is free software: you can redistribute it and/or modify
	# it under the terms of the GNU General Public License as published by
	# the Free Software Foundation, either version 3 of the License, or
	# (at your option) any later version.
	#
	# This program is distributed in the hope that it will be useful,
	# but WITHOUT ANY WARRANTY; without even the implied warranty of
	# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

	#
	# validate_saudi_id() function for MySQL/MariaDB
	# This function will validate Saudi identity card number
	#
	# This program is free software: you can redistribute it and/or modify
	# it under the terms of the GNU General Public License as published by
	# the Free Software Foundation, either version 3 of the License, or
	# (at your option) any later version.
	#
	# by Daif Alazmi (http://daif.net)

	# Function returns user.login, current year, the primary_key which is the id, in 5 length (Example: 00045)
	string format
	# http://developer.postgresql.org/pgdocs/postgres/functions-formatting.html
	# to_char(5,'00000') results the same number format
	CREATE OR REPLACE FUNCTION "public"."function_name" () RETURNS trigger AS
	'
	BEGIN
	NEW.title = (SELECT login FROM users WHERE id = NEW.author) \|\| to_char(NOW(),\'YYYY\') \|\| lpad(NEW.id::char, 5, \'0\');
	RETURN NEW;
	END