Giter Club home page Giter Club logo

blog's People

Contributors

ruebenramirez avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar

blog's Issues

post: sql formatting in vim

vundle plugins:

"Keymap: i - Install plugin; c - Cleanup; s - Search; R - Reload list
"Search results for: sql
Plugin 'sql.vim'
Plugin 'color-codes-SQL-keywords-from-Oracle-11g'
Plugin 'sqlplus.vim'
Plugin 'sqlserver.vim'
Plugin 'sql_iabbr-2'
Plugin 'sqlplsql'
Plugin 'sqlite_c'
Plugin 'vim-addon-sql'
Plugin 'sqloracle.vim'
Plugin 'mysqlquery'
Plugin 'nosql.vim'
Plugin 'mySqlGenQueryMenu.vim'
Plugin 'psql.vim'
Plugin 'sqlvim.sh'
Plugin 'Menu_SQL_Templates.vim'
Plugin 'tcl_sqlite.vim'
Plugin 'Access-SQL-Syntax-file'
Plugin 'SQLComplete.vim'
Plugin 'MS-SQL-Server-Syntax'
Plugin 'psql.vim'
Plugin 'sqlldr.vim'
Plugin 'sql.vim'
Plugin 'changesqlcase.vim'
Plugin 'sql.vim'
Plugin 'sql.vim'
Plugin 'sql.vim'
Plugin 'SQLUtilities'
Plugin 'sql.vim'
Plugin 'MySQL-script-runner'
Plugin 'plsql.vim'
Plugin 'plsql.vim'
Plugin 'sql_iabbr.vim'
Plugin 'sql.vim'
Plugin 'sqlplus.vim'

post: tracking issues and building documentation

I really like the idea of tracking issues inline as part of your project's documentation:
https://medium.com/@MrJamesFisher/documentation-for-free-ec6d50f2b3c2

For the longest time, I've been using Jira and github task and issue tracking to organize development effort.

[ ] - find the changelog interview with the founder of gitlab.com -- covers issue tracking and workflow management.

I use agile sprint planning to help with longer term company roadmaping of my work. This is often messy though, as it's common to create issues and and add them into the sprint. I like the idea of just working off of a prioritized backlog at least.

I could see this wiki-style issue tracking actually work if there were proper tooling in place with the wiki software.

post: CoreOS setup and review

[ ] setup coreos on a couple of local machines

  • What are the benefits?
  • How does CoreOS help me deploy applications?
  • What is difficult about how CoreOS works?
  • What did I have to learn to get started?
  • Overall what is different?

post: moving off of gmail

Why would you want to move off of gmail?

[ ] - mail in a box docker container info

  • spamassassin config (claims to be just as good as gmail'a spam filtering)
  • clamav config

Using kolab

  • why is Kolab better?
  • alternative to running exchange
  • apply the mail in a box spamassassin rules to Kolab config

End result:

  • what kind of VM specs do you need to be able to run this?

Imapsync to move your messages

post: what is mysql proxy capable of

It's possible to write mysql queries that join tables from multiple databases.
[ ] - add a link to the mysql docs for this cross database join feature

Because queries do not span multiple database server connections, it is not possible to join databases across multiple servers.

Enter MySQL proxy....

[ ] - Does mysql proxy expose access to all proxied mysql servers via a single connection?

  • If so, is it possible to perform cross database joins where those databases are deployed across servers?

Dropcam, Simplicam or DIY

I saw Dropcam and fell in love. But with the idea, not their proprietary offering.

I recently purchased my first home and ADT sales staff are worse than mosquitoes. For $50 a month I could have the house monitored "professionally", or I could rig something up myself for a one time up front investment. I setup Motion on an old laptop (more on that below) which was easy enough, but figured there had to be a better open source way to cover more of the house (and outside as well) without breaking the bank and getting sucked into expensive subscriptions.

I also just rescued Sammie from a dog shelter and am still house breaking her, so it's ideal to be able to see how she's doing without having to drive home from work multiple times a day. Dropcam and Simplicam both have a two way audio com feature that would be nice to replicate.

So I started researching on social media and all of my progress really started here:
https://twitter.com/yibi/status/481462671221719040

Dropcam

features:

  • event notification on your phone
  • record to the cloud
  • event detection disregard learning

Dropcam is pretty much a plug and play solution. It comes at a cost though. $150 for the cheaper offering and $200 for the "higher end" camera.

Simplicam

features:

  • very close to the Dropcam offering
  • only one camera available: better specs than Dropcam's entry-level offering but not as good as Dropcam's Pro camera
  • offers a $50 /yr 1 day record feature subscription (cheaper than Dropcam's minimum 7 days recording subscription at $99)

DIY options

ZoneMinder

Motion

  • This is what I've been using (on an old laptop with a built-in webcam) and is probably the easiest to setup.
  • Detects events by calculating a pixel delta score from frame to frame. Motion saves still images above sensitivity score you specify.
  • Motion saves the images to a folder on the machine which I've configured dropbox to sync.
  • I have an IFTTT recipe that runs when dropbox syncs a new file. This serves as my notification of an event picked up by the system.

[ ] does Motion support IP cameras?


alternatives to zoneminder:
http://alternativeto.net/software/zoneminder/

need to investigate these:

  • iSpy
  • yawcam

post: iOS 8 woes

did a complete reset and things seem snappier..

keyboard is still broken in various applications though :(

fault tolerant and load balanced CIFS

Wondering how difficult it would be to rig up gluster on the backend for this:
http://www.gluster.org/

[ ] can we consume this via iSCSI?
[ ] how to combine CIFS with LDAP perms with this kind of a back end?
[ ] how to load balance? how to setup a reverse proxy? (is there a CIFS reverse proxy?)

post: vultr competing with DigitalOcean

How low can you go? Who provides the best of the cheap hosting space?

  • the have the same site layout
  • they have the same price points
  • vultr looks to be trying to wal-mart them out at a feature of more resources per price point

[ ] - need to give them a test run for a month and see how they do.

  • tie in a performance monitoring solution
  • compare the performance to DigitalOcean at the same price point

[ ] - what distinguishes vultr as a good hosting provider? How do they stack up with the "more mature" DigitalOcean?

  • how old is digital ocean
  • how old is vultr?

[ ] - what kind of support do these providers offer?

[ ] - how do these providers stack up against bigger names like Rackspace, Amazon, Microsoft, and Google?

Post: data warehousing

Source: mysql

What are the best targets for a small data warehouse?

Replication:

Benefits of replication for this situation:

  • the size of upstream production data is small
  • we still don't know what data is valuable, so it's ideal to have all of it just a query away (bringing in all data to a single mysql database server allows us to

Running mysql proxy:
[ ] - would running a mysql proxy allow us to query production with cross database joins?

Index building options:


What can elastic search so for us?

post: embedding images in posts

embed images in posts by first adding the images to a contrib directory in your repo

then embed those images in the markdown with something like:
![ScreenShot](https://github.com/ruebenramirez/blog/raw/master/contrib/screenshot.png)

default function keys over special keys

temporary fix:
echo 2 | sudo tee /sys/module/hid_apple/parameters/fnmode

permanent fix:

echo options hid_apple fnmode=2 | sudo tee -a /etc/modprobe.d/hid_apple.conf;
sudo update-initramfs -u -k all;
sudo reboot`

an audio experiment

I bought a pair of Logitech Z263 THX 2.1 speakers some 3 years ago, and they finally gave out on me today.

Monoprice

I've bought all kinds of cables from Monoprice for a long time now. I still haven't tried out any other products they sell though. Before spending money on their $250 5.1 surround sound system, I figured I would run a cheap experiment and replace my office speakers that just died.

I decided to kick things off with the 8" 3-way bookshelf speakers:
8"-3-way boookshelf speakers
https://www.monoprice.com/Product?c_id=109&cp_id=10904&cs_id=1090407&p_id=8251&seq=1&format=2

I've heard great things about these little amps:
little-amp-pic

http://www.amazon.com/Lepai-LP-2020A-Tripath-Class-T-Amplifier/dp/B0049P6OTI/ref=sr_1_1?s=electronics&ie=UTF8&qid=1414904333&sr=1-1&keywords=Lepai

Don't forget the wires! Don't do what I did and forget to buy the speaker wire...

nexus 9 first take

The hardware is starting to grow on me. The metal on the sides of the screen seems like it doesn't fit around the glass as well as it should.

The device performance is great. It started out slow (while I a TON of updates were pulling in the background), but sped up pretty quickly and is a better experience than my iPad Air that I think I'll be selling soon.

I didn't go for the LTE but I'm already kind of kicking myself wishing that I had. I can definitely see using this over my iPad Air.

The downsides... Apple has a default split keyboard in landscape mode, where android does not. There are some after market keyboards that do offer this though, so I'm going to keep trying them out to see which one works best for me.

post: headphones

  • Beats by Dre Tour - I'm not a big fan of heavy in-ear headphones
    ** Good at the desk only: they kept falling out of my ear while on the treadmill
  • Bose headphones - the best noise canceling, but definitely not the best audio
  • UE (logitech) headphones
    ** the soft travel case doesn't protect them very much
    ** (un)folding them after a few months put some wear on them, but overall they're pretty decent build quality
  • LG bluetooth headphones
    ** actually not bad at all even though they have an in-ear design
    ** surprisingly good quality audio: I wasn't expecting much but they really turned out to deliver
  • ability to cancel noise

pebble fit app and the android struggle

what's the current state of using pebble watch as a fitness tracker? pedometer, etc...

And is the android app going to get any better anytime soon? It's better than it used to be at least...

toggle touchpad on linux

source: https://wiki.archlinux.org/index.php/Touchpad_Synaptics#Software_toggle

Then save this script to something such as /usr/bin/trackpad-toggle.sh:

/usr/bin/trackpad-toggle.sh

#!/bin/bash
synclient TouchpadOff=$(synclient -l | grep -c 'TouchpadOff.*=.*0')

Then finally add a key binding to use the script. It is best to call with xbindkeys like so (file ~/.xbindkeysrc):
~/.xbindkeysrc

"/usr/bin/trackpad-toggle.sh"
    m:0x5 + c:65
    Control+Shift + space

Budget android with stock android!

I just found out about a budget smartphone with pretty incredible specs for the price point. It's a Motorola device with stock android like you might find on a nexus device.

The Motorola g

They have a second generation now also with a bigger screen, and a micro sd card slot under the back cover.

[ ] is the battery removable/swappable?

I don't use my phone for much beyond light browsing, texting and maybe a few calls here and there, but I really like that Motorola is offering latest stock android support direct from Google.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.