Mateus Pereira MateusBMP

Simulação simples de base de dados

Implementação de uma base de dados simples, com o objetivo de simular o funcionamento de uma base de dados real. Para utilizar, compile o projeto com gcc -std=c99 *.c -o main e execute com ./main. Para fazer um teste e entender seu funcionamento, execute ./main database.cdb --example, que criará o arquivo database.cdb e o preencherá com alguns dados de exemplo.

O contrato base está no arquivo database.h, enquanto a implementação encontra-se no arquivo database.c. O arquivo main.c contém um exemplo de uso da base de dados, apenas, e pode ser alterado para implementar o que for necessário.

	#!/bin/bash
	#
	# Play a sound using the speaker
	#
	# Usage: ./play_sound.sh [time]
	# time: time in seconds to play the sound (default: 0.1)

	if ! command -v speaker-test &> /dev/null
	then
	echo "speaker-test could not be found"

	#!/usr/bin/env bash

	# usage: progress_bar <current> <max>
	# see: https://gist.github.com/darrenclark/1392848
	progress_bar () {
	output="\r"

	output="$output ["
	total=$1
	count=0

	#!/usr/bin/env sh
	# see: https://olvlvl.com/2019-06-docker-pecl-without-pecl
	set -e

	dir=/usr/src/php

	if [ ! -f "$dir/.docker-extracted" ]; then
	echo >&2 "error: PHP source required, run 'docker-php-source extract' first"
	exit 1
	fi

	#!/usr/bin/bash

	wget https://s3.amazonaws.com/amazoncloudwatch-agent/ubuntu/arm64/latest/amazon-cloudwatch-agent.deb
	sudo dpkg -i -E ./amazon-cloudwatch-agent.deb

	sudo apt update
	sudo apt install collectd -y

	touch /opt/aws/amazon-cloudwatch-agent/bin/config.json
	cat <<- "EOF" >> /opt/aws/amazon-cloudwatch-agent/bin/config.json

	{
	"Enable strict typing": {
	"prefix": [ "strict_types", "strict" ],
	"body": "declare(strict_types=1);",
	"description": "Enable strict typing using the PHP strict_types directive"
	},
	"New php with strict typing": {
	"prefix": [ "<?php-strict_types", "<?php-strict" ],
	"body": [ "<?php", "", "declare(strict_types=1);", "", "$0" ],
	"description": "Create new php file with strict typing enabled."

	#!/bin/bash
	#----------------------------------------------
	# OPTIONS
	#----------------------------------------------
	USER='user' # MySQL User
	PASSWORD='pass' # MySQL Password
	DAYS_TO_KEEP=7 # 0 to keep forever
	GZIP=1 # 1 = Compress
	BACKUP_PATH='/set/backup/path'
	#----------------------------------------------

	#!/bin/sh

	# see: https://tech.labelleassiette.com/how-to-reduce-the-memory-usage-of-mysql-61ea7d1a9bd
	# you might want to add some user authentication here
	mysql -e "show variables; show status" \| awk '
	{
	VAR[$1]=$2
	}
	END {
	MAX_CONN = VAR["max_connections"]

	# Create structs FAN and QUEUE #
	MODE FAN = STRUCT(STRING name, INT ticket),
	QUEUE = STRUCT(FAN fan, REF QUEUE next);

	# Create NIL queue, default queue and tail and point both to NIL #
	REF QUEUE nilq = NIL;
	REF REF QUEUE head, tail;
	head := tail := LOC REF QUEUE := nilq;

	# Add FAN from QUEUE