Este, sólo para los que saben de Bases de Datos y SQL

xkcd - A webcomic of romance, sarcasm, math, and language - By Randall Munroe

Exploits of a Mom

Her daughter is named Help I'm trapped in a driver's license factory.

Mods para CIV IV

Página oficial de parches


Fall from Heaven

Fall from Heaven is a dark fantasy game mod for Civilization 4. It is loosely based on my long running Dungeons and Dragons campaign world. Although the original D&D game provides a lot of the history, flavor and mythology in the mod a team of writers are constantly creating new material to detail the world. The intent was never to replicate the D&D campaign, but to create the best possible turn based fantasy strategy game using any material that would help.

Powered by ScribeFire.

Enfocar fotos desenfocadas

Software comercial para enfocar las fotos desenfocadas

Recover Detail and Sharpen Your Blurred Photos

Focus Magic uses advanced forensic strength deconvolution technology to literally "undo" blur and recover lost detail. It can repair both out-of-focus blur and motion blur (camera shake) in an image. Can you read the license plate number in the "Before" image (below) ? Can you even vaguely make out one letter ? Imagine how you could use this technology on your photos.

This image is out of focus. Click to view original image.

This old photo has motion blur (or camera shake).

Juegos que hay que jugar

Heavy Rain - Wikipedia

Heavy Rain (possibly subtitled The Origami Killer[1]) is an upcoming video game, developed by French studio Quantic Dream for the PlayStation 3. The game is being directed by Quantic Dream's founder and CEO David Cage[2], who also wrote and directed the studio's two previous games, Omikron: The Nomad Soul and Fahrenheit. The game is scheduled to be released in Fall 2008.[3] The game was announced at E3 2006, where a tech demo entitled The Casting was presented to the media and general public.

Fahrenheit (video game) - Wikipedia

Fahrenheit (known as Indigo Prophecy in the United States and Canada) is a video game that was released in September 2005. It was developed by French studio Quantic Dream, and published by Atari. The game was written and directed by Quantic Dream founder David Cage.

I Have No Mouth, and I Must Scream (computer game) - Wikipedia

I Have No Mouth, and I Must Scream is a computer adventure game based upon Harlan Ellison’s short story of the same name. It is about an evil computer named AM that has destroyed all of humanity except for five people he has been keeping alive and torturing for the past 109 years. Each survivor has a fatal flaw in his or her character, and in an attempt to crush their spirits, AM has constructed a metaphorical adventure for each that preys upon their weaknesses. To succeed in the game, the player must make ethical choices to prove to the evil computer that humans are better than machines, because they have the ability to redeem themselves.

Elementos de una videoaventura

Diseño de videojuegos literarios: elementos (narrativa, puzzles...) de las aventuras conversacionales

bit-tech.net | How to write... an Adventure game - How to write an Adventure game

Of
course, there has always been one genre which has featured story as a
major attraction and has used delicate plot exposition and wonderful
characters to pull in players for some utterly enthralling game
experiences. It also happens to be one of my most loved genres,
responsible for first drawing me into the life of a hardcore gamer when
I was just a little kid playing on my Amiga A500+ – The Adventure Game

bit-tech.net | How to write... an Adventure game - Dialogue and NPCs

“When the genre is really mastered, it will be as intense, enriching, inspiring and fascinating as the best movies we saw or the best books we read. And it will do it in its own way, with its own language, with a bigger power than any other media. It is just a matter of time.”

Cómo responder a los matones

Se están poniendo de moda las cartas de abogados con requisitos de elminar contenido crítico de tu web. Aquí hay un buen ejemplo de cómo responderles.

Techdirt: Don't Post This Cease-and-Desist Letter, Or Else

Don't Post This Cease-and-Desist Letter, Or Else

Greg Beck writes "In an apparent attempt to avoid the Streisand Effect, lawyers sending threat letters sometimes claim that the recipient would violate the firm's copyright by posting it online. This post is about Public Citizen's response to one dumb threat letter and its decision to post the letter online despite the copyright claim." It's funny how popular it has become for lawyers to claim it's illegal to post or even show anyone their cease-and-desist letters. Remember: just because a lawyer says so, it doesn't mean it's true. You can see Public Citizen's response to the letter (pdf), which lays out a variety of reasons why the cease and desist is ridiculous (it's yet another attempt to force criticism offline) and ends with a fantastic response to the claim that the original C&D is covered by copyright and cannot be posted online without additional charges: "By this letter, we are inviting you to test the validity of your theory that the writer of a cease and desist letter can avoid public scrutiny by threatening to file a copyright law suit if his letter is disclosed publicly on the internet." Somehow, I doubt the opposing lawyer will test out this theory.

Visualizador dinámico de logs de seguridad

Un par de herramientas para ver en tiempo real los registros de conexión de actividad red, para detectar de un vistazo si te ha entrado un virus, troyano u otro malware.

Slashdot | Logfiles Made Interesting with glTail

"My
boss claimed it was pretty much impossible to create an entertaining
way to visualize server traffic and events in a short time frame, so of
course I had to prove him wrong. A weekend of neglecting my family
produced a small ruby program which connects to your servers via SSH,
grabs and parses data from Apaches access log and Ruby on Rails
production log, and displays your traffic and statistics in real-time
using a simple OpenGL interface (tested under Linux and Mac OS/X). It's
a bit hard to explain over text, so please have a look at fudgie.org
for an example movie, and more information."

I was about to say that it's a sort of etherape on steroids, but I've
just realised your visualisation could benefit etherape instead (if you
don't know etherape, look it up. No tools identifies a virus infection
quicker).

EtherApe, a graphical network monitor

EtherApe is a graphical network monitor for Unix modeled after etherman. Featuring link layer, ip and TCP modes, it displays network activity graphically. Hosts and links change in size with traffic. Color coded protocols display.
It supports Ethernet, FDDI, Token Ring, ISDN, PPP and SLIP devices. It can filter traffic to be shown, and can read traffic from a file as well as live from the network.

Sitios útiles para saber hacer cosas

Sitios con conocimiento práctico

• http://www.ttiqq.com/

• 15 Ridiculously Useful Websites

1. E-How

   A reference site for just about everything else. Want to k now how to wax snow skis? Make pizza dough? Install a bathtub? This is the place.

   How Stuff Works

   A very cool website that contains explanations of those mysteries in life that you just can't figure out. A few examples are Murphy's Law, Pickpockets, and Light Sabers (Yes, light sabers).

1. What Should I Read Next

   Can't decide what to read next? Simply enter a book title and/or author that you like and the site will recommend a number of books for you.

2. The Universal Packing List

   This is a very unique website I found that creates a packing list for you based on information you provide regarding your trip and intentions/plans.

Seguridad Linux

Lista de la compra de cosas que hacer para que una Linux box sea segura.

Slashdot | Cracked Linux Boxes Used to Wield Windows Botnets

Here's what I do. (I guess you could say these are some security tips for those running Linux boxes at home and leaving them up on the Net):

• Run a hardware NAT firewall/router. Any ol' Linksys, Dlink or Netgear thang will do. Just remember it's not the be all and end all to security problems.
• Open as few ports as absolutely possible. I have nothing open on my router except port 22 and BitTorrent, and I don't leave BitTorrent running all the time
• Check your logs at least once a day. Look for any suspicious signs -- missing log entries, ssh connects you weren't expecting, services running that you don't normally have running, NICs going into promiscuous mode unexpectedly, excessive mail being pumped through any MTAs, etc.
• When running OpenSSH, I disallow password authentication. This prevents problems with users due to the use of stupid passwords. My sshd only accepts a valid RSA key exchange as acceptable authorization.
• Regularly update and run rootkit checkers. These are not be all end all, but they help spot obvious rootkits
• Make cron jobs that regularly scan your system for unusual permissions -- world writeable, binaries that are setuid, etc. and for suspicious files. There are programs and scripts that will do this for you. STFW or check with your distro.
• Perform MD5 checking on your files and executables, espcially.
• Regularly check your /etc/passwd and /etc/group files for new or unusual entries.
• Don't run NIS -- it's inherently insecure. You should be using OpenLDAP if you need directory authorization on your network.

Videojuego artístico - Relación de pareja

Juego de Interactive Fiction en el que una pareja actúa de forma realista, basado en inteligencia artificial

Download Façade 1.1b - Façade is an artificial intelligence-based art/research experiment in electronic narrative. - Softpedia

Façade is an artificial intelligence-based art/research experiment in electronic narrative – an attempt to move beyond traditional branching or hyper-linked narrative to create a fully-realized, one-act interactive drama.

Integrating an interdisciplinary set of artistic practices and artificial intelligence technologies, we have completed a five year collaboration to engineer a novel architecture for supporting emotional, interactive character behavior and drama-managed plot.

Powered by ScribeFire.

La mamá linuxera

Anécdota de una mamá que usa Ubuntu, y le gusta.

Why My Mom Can Use Ubuntu (read: Why linux is Better than Windows) « Troubled Ramblings of a Jaded 20-Something

Now, she is by no means a full on linux geek but a full blown linux user (and maybe just a bit of a geek). This became abundantly clear when we met for lunch, one day. She told me the story of her IT guy friend in Michigan and his virus problem. Apparently, a massive infection, across several locations, covering 400 Windows computers in there organization caused a bit of work for this IT friend. A few weeks of antivirus duties, actually. Then, my mother delivered the punchline.



Mom: “then I said, ‘Antivirus??? What’s that!?! Hahaha!’“

20 lecciones sobre SQL

20 artículos y herramientas sobre SQL, en varios niveles desde básico hasta avanzado pasando por compatibilidad con distintos gestores de BBDD (Oracle, MySQL, SQL Server...)

SQL TOOLBOX: 20+ Tools and Lessons About SQL

SQL TOOLBOX: 20+ Tools and Lessons About SQL
October 3, 2007 — 02:08 AM PDT — by Sean P. Aune — Share This

SQL

SQL is all around us, but not everyone really knows its inner workings. We’ve gathered 20+ tools and lessons to help you learn all about it.

Defragmentar el disco duro a trocitos

Programa gratis para defragmentar el disco, permite desfragmentar fichero por fichero.

Defraggler - Defragment your files!

Defrag Individual Files
Most defragmentation tools only let you defrag the whole drive. Defraggler gives you the power to select individual files and folders to defrag. So you can get the job done in seconds, rather than waiting for the whole drive to complete. Of course if you want to defrag the whole drive Defraggler will let you do that too.

MP3 explicado

Artículo de la serie que explica el funcionamiento de los formatos de sonido.


The AudioFile: Understanding MP3 compression: Page 1

But what is MP3? The usual explanations usually take one of two forms. The long version, available in technical papers, is written in jargon and filled with math. The short version, often used by newspapers and nontechnical periodicals, simply states that the process eliminates parts of sound not normally heard by the human ear. But this one-sentence description raises more questions than it answers for any reasonably tech-savvy reader: how does it find those unheard sounds, and how does it get rid of them? What's the difference between the different bit rates and quality levels? If you're anything like me, you've often wanted to know the mechanics of MP3, but not to the point of writing your own encoder.

Las cuentas de una empresa

Estimaciones de costes (desglosadas por partidas) para montar una start-up, y cuánto costaron en realidad.


How to Change the World: Financial Models for Underachievers: Two Years of the Real Numbers of a Startup

Financial Models for Underachievers: Two Years of the Real Numbers of a Startup
Evil eye.jpg

My buddy at Redfin, Glenn Kelman, decided he wanted to bare his financial soul so that other entrepreneurs could get greater insight into the witchcraft called financial modeling. In this two-part posting, he reveals his numbers and his lessons. They are eye-opening for most entrepreneurs.

La pila atómica ya está aquí...no.

No incorpora una reacción nuclear, se carga por la desintegración de isótopos radiactivos.

Scientists Invent 30 Year Continuous Power Laptop Battery

Your next laptop could have a continuous power battery that lasts for 30 years without a single recharge thanks to work being funded by the U.S. Air Force Research Laboratory. The breakthrough betavoltaic power cells are constructed from semiconductors and use radioisotopes as the energy source. As the radioactive material decays it emits beta particles that transform into electric power capable of fueling an electrical device like a laptop for years.

Actualización: parece que era demasiado bueno para ser verdad...

Except, not so much. ZDNet's Mixed Signals blog with Rupert Goodwins explains why (as always) if it sounds too good to be true, it probably is: "The sort of atomic structures that generate power when bombarded with high energy electrons are the sort that tend to fall apart when bombarded with high energy electrons. While solar cells have the same problem, it's to a much lesser extent. There's a lot of research into making materials that don't suffer so much, but it remains a serious issue ... while it's true that a tritium-powered battery will eventually turn into an inert, safe lump of nothing much, and while it's also true that a modest amount of shielding will keep the radioactivity within the the battery the while, there's the small problem that if you break the battery during its life the nasties come out."

La historia del mundo, versión Slashdot

Slashdot Turns 10 But You Get The Presents

The History of the World, as seen through /.

A.D. 1000: The epic of the Beowulf Cluster is written down. It is the first English epic poem.

A.D. 1095: Pope Bruce II calls for a crusade against the Turks when it
is revealed they are violating the GPL. Later investigation reveals
that Pope Bruce II had not yet contacted the Turks before calling for
the crusade.

...

Powered by ScribeFire.

"Reescalado líquido" en GIMP

La nueva técnica de procesado de imágenes que permite cambiar el tamaño de las imágenes de forma "natural", ahora está disponible como software libre.

All about Linux: Liquid rescale feature now available as a GIMP plugin

Liquid rescale feature now available as a GIMP plugin

Fotografía científica

Premios de visualicación: Fotografía científica

2007 Visualization Challenge Winners -- Lester 317 (5846): 1858 -- Science

Matemáticas simples de entender

La otra cara del problema: también se puede conseguir que las matemáticas complicadas sean fáciles de comprender. Vídeo que muestra transformaciones en el plano, como proyecciones de una esfera.

YouTube - Moebius Transformations Revealed