hgimenez: Archive

Jul 22nd

GIANT ROBOTS SMASHING INTO OTHER GIANT ROBOTS:... →

thoughtbot-giantrobots: This following week, PostgreSQL Conf East will take place in New York City. The conference starts on Wednesday March 23 and ends on Friday the 25th. There is an excellent lineup of speakers and talks from the PostgreSQL community, as well as from the folks from MongoDB, Rails, Python and other…

Mar 15th

1 note

Feb 13th

cmdKeen: I'd like to write a daemon that'd be spawned (forked/run in thread) by postgres server and would run queries on the server without the socket overhead. Is that possible (and a good idea)?

daemon: I like to fork postgres myself not the other way around (0_o)

Feb 13th

Feb 10th

PostgreSQL 9.1: Neat Stuff is Coming →

Noah Misch has submitted a flock of patches that aim to reduce the number of table rewrites and index rebuilds that are required by ALTER TABLE.

Jan 25th

Fixing foreign key deadlocks — submitted →

the way I did this was by adding a second bitmapset to the relcache RelationData struct, which lists columns part of unique indexes. Well I’m glad that’s clear, then!

Jan 20th

http://mikeos.berlios.de/write-your-own-os.html →

Paste the following code into a file called myfirst.asm and save it into your home directory - this is the source code to your first OS.

Jan 14th

Jan 12th

Jan 9th

Jan 8th

GIANT ROBOTS SMASHING INTO OTHER GIANT ROBOTS:... →

thoughtbot-giantrobots: There are a number of variables that allow a DBA to tune a PostgreSQL database server for specific loads, disk types and hardware. These are fondly called the GUCS (Global Unified Configuration Settings) and you can take a look via the pg_settings view. There are also a few of things that you can…

Jan 8th

6 notes

Jan 2nd

Dec 30th

Dec 27th

Dec 25th

Dec 24th

Dec 23rd

Dec 21st

http://www.comicsanscriminal.com/ →

Dec 21st

“The ad buying page is so fresh and new that the “thank you” page...”

– http://m.readwriteweb.com/archives/twitter_launches_online_form_to_buy_ads_trending_t.php

Dec 15th

Dec 9th

Dec 7th

More postgres is awesome

Matt: harold, postgres - say I wanted to find all users where the time in days between their created_at and updated_at was 14 days
Matt: I dont need the query, but point me at a function or something if you can
Harold: easy peasy
Harold: i'd use age() and interval
Harold: so something like this:
Harold: (code talks)
Harold: select * from users where age(updated_at, created_at) < interval('14 days')

Dec 7th

Foursquare outage post mortem - mongodb-user |... →

Oct 8th

Sep 2nd

Background patterns

Patterns for the non-designer: http://bgpatterns.com/ http://dinpattern.com/ http://www.squidfingers.com/patterns/

Sep 2nd

Fonts for web design primer →

Fonts come in various styles, but most can be considered serif or sans-serif. Serif fonts have serifs—non-structural details and elements on the ends of the strokes on some letters and symbols. Sans-serif fonts (“sans-serif” literally translates as “without serif”) lack serifs.

Aug 31st

Aug 28th

Linked Data Patterns →

A pattern catalogue for modelling, publishing and consuming Linked Data

May 10th

Apr 29th

An awesome Redis Tutorial →

Apr 26th

Apr 13th

Rails 3, Railties and Engines →

Apr 7th

Errors in Database Systems, Eventual Consistency,... →

Apr 7th

Apr 2nd

Postgres saves the day

kith: i have a database with _lots_ of ip addresses
kith: and when i search for IPs i'm selecting all of them then run IPAddr.new on them and check if its a net which my ip belongs to
injekt: kith: More than 23k?
kith: injekt: dunno
kith: anyways, the script is friggin slow
injekt: I'd imagine so
injekt: er, 'I can imagine'
kith: would it be smart to kinda write some stored procedure to resolv ip addressing beforehand?
bleything: kith: do you want to validate the ip every time, or just once?  because you could do it on the way in instead of the way out.
kith: bleything: what do you mean by way in/out? and well yeah it has to be validated everytime someone is looking for an ip address
vovcia: kith: WHERE ip LIKE '12.34%'
injekt: kith: He means when you throw an IP address in the db, can't you just do all your validations there
bleything: kith: I meant, yes, if you're going to iterate over a db and create a new object for an item in every row, it's going to be slow.  if you could check them at insert time it'd be easier, but it's not clear what you're doing.
evan: if you're looking for a particular byte pattern.
kith: vovcia: not gonna work
bougyman: some databases have a cidr column type, so they take care of it at the column/db level.
bougyman: kith: are you using postgres?
bougyman: kith: yes.
bougyman: you can do subnet lookups and all sorts of cool stuff with it.
kith: does pg have this?
bougyman: yes
kith: FUUUCK :D
vovcia: bougyman: ipv6 as well?
kith: bougyman: why didnt you tell me earlier?
bougyman: http://www.postgresql.org/docs/8.3/static/datatype-net-types.html\
bougyman: -\
bougyman: cidr7 or 19 bytes IPv4 and IPv6 networks
bougyman: inet	7 or 19 bytes	IPv4 and IPv6 hosts and networks
bougyman: macaddr	6 bytes	MAC addresses
bougyman: woops
bougyman: kith:  select inet '192.168.1.5' 
bougyman: that's the kind of sweet stuff you get (is 192.168.1.5 in 192.168.1.0/24?)
kith: fuck need to read up on that
bougyman: http://www.postgresql.org/docs/8.3/static/functions-net.html
bougyman: there ya go
kith: bougyman: thx man
bleything: that is extra rad.
kith: rad?
bleything: awesome. cool. neat.

Mar 30th

Graph Theory Algorithms Book →

Mar 28th

Watch

Part 1 of 4 of a data visualization course in R with ggplot2 by the author himself, Hadley Wickham Part 2: http://blip.tv/file/3375233 Part 3: http://blip.tv/file/3375426 Part 4: http://blip.tv/file/3375517

Mar 23rd

Srum-ban →

Mar 22nd

“if gentoo made cars, they’d arrive as billets of iron and cartons of...”

– someone on irc

Mar 13th

Mar 10th

Mar 3rd

Yehuda on Rails 3 on infoq →

Mar 3rd

Opinion Mining/Sentiment analysis resources →

Mar 2nd

Google Visualization API →

Unlike the Google Charts API, allows you to interact with charts with JS

Feb 15th

2 notes