Skip to content

Instantly share code, notes, and snippets.

View gabidavila's full-sized avatar
💁‍♀️
I try to solve all my problems with a single SQL query.

Gabriela Ferrara gabidavila

💁‍♀️
I try to solve all my problems with a single SQL query.
View GitHub Profile
@gabidavila
gabidavila / composer.json
Last active August 29, 2015 14:05
Added phpunit, will instal a binary into /vendor/bin
{
"require": {
"laravel/framework": "4.2.*",
"phpunit/phpunit": "4.*"
}
}
// Part of Gruntfile.js, this is the Uglify section
phpunit: {
classes: {
dir: 'app/tests/' //location of the tests
},
options: {
bin: 'vendor/bin/phpunit',
colors: true
}
},
// Plugin loading
grunt.loadNpmTasks('grunt-contrib-compass');
grunt.loadNpmTasks('grunt-contrib-sass');
grunt.loadNpmTasks('grunt-contrib-concat');
grunt.loadNpmTasks('grunt-contrib-uglify');
grunt.loadNpmTasks('grunt-phpunit');
// Task definition
grunt.registerTask('default', ['sass', 'concat', 'uglify', 'phpunit']);
//Gruntfile
module.exports = function (grunt) {
//Initializing the configuration object
grunt.initConfig({
// Paths variables
paths: {
// Development where put SASS files, etc
assets: {
// Foundation by ZURB
// foundation.zurb.com
// Licensed under MIT Open Source
//
// FOUNDATION SETTINGS
//
// This is the default html and body font-size for the base rem value.
// $rem-base: 16px;
@gabidavila
gabidavila / releases.mysql.sql
Last active August 29, 2015 14:06
releases
CREATE TABLE `releases` (
`id` int(11) NOT NULL,
`source` varchar(45) DEFAULT NULL,
`packagename` varchar(255) DEFAULT NULL,
`package_id` varchar(45) DEFAULT NULL,
`isbn` char(13) DEFAULT NULL,
`book_title` varchar(255) DEFAULT NULL,
`year` char(4) DEFAULT NULL,
`issn` varchar(45) DEFAULT NULL,
`series_title` varchar(127) DEFAULT NULL,
#these are for to get the dependencies
npm install -g bower
npm install -g grunt
npm install grunt-contrib-concat grunt-contrib-uglify grunt-contrib-less --save-dev
#it will download the dependencies
bower install
#this command you run everytime you change the LESS or JS
grunt

Keybase proof

I hereby claim:

  • I am gabidavila on github.
  • I am gabidavila (https://keybase.io/gabidavila) on keybase.
  • I have a public key whose fingerprint is 0EA0 6C8B 0A02 C31F CBAB E56A 6820 F852 FA6A 32AA

To claim this, I am signing this object:

@gabidavila
gabidavila / cofnerence.md
Last active August 29, 2015 14:07
Database Wizardry for Legacy Applications

In my experience, one of the major bottlenecks in building an Application lies in the database. This crucial piece of your app is also the most difficult to alter. If you have high availability software, how do you improve from spaghetti code without being able to do major changes to its database? You may refactor your spaghetti into beautiful, hexagonally layered lasagne, but if your database sucks, your data sucks.

In this talk you will learn how to improve your legacy application by discovering the benefits of NoSQL to consolidate your data, and how MapReduce can increase your project performance.

----- talk info -----

Many people talk about refactoring code, and we ask someone about the database they say: "If you abstracted your models well, you don't need to worry about it", but in many cases, this is not reflect the real world.

This is why I want to talk about it. To show what can you do to make your DB more suitable for your application.

Switchers guide to Postgres - Intro

As developers one item on our long ToDo list is to bring stuff from somewhere, do the every day CRUD operation and make that stuff store more and more data.

Differently from the majority people who started programming in PHP with MySQL, that was not my first RDBMS system. Believe it or not, it was Firebird!

The project I worked on was a web interface to the already running Delphi ERP system. So I learned to do things a little differently and was very lost when I started to use MySQL, let's just say that Firebird was more strict than the popular database.

After that I had the oportunity to experiement other database flavors. Postgres, Microsoft SQL Server and Oracle too.