Wow, STRATO-Mitarbeiter atmen nicht!
ruut and me are setting up a new server. This blog is one of the first sites being migrated.
If you can read this, it has worked!
Ich habe ein neues Blog gestartet zum Thema Shadowrun 5.
Schaut doch mal vorbei :)
I have thought of myself as a “visual person” for a long time. But I think I never realized how much this defines me, until now.
It is almost impossible for me to memorize things just by hearing them. Names, numbers, dates, directions – my mind disposes of them in minutes. But when I read something, when I look at a picture, when I see a map, then I’ll remember it because I understand it. (I’m not talking about photographic memory here; I don’t have that. I’m just much better digesting visually than orally.)
When everybody in age group started using cell phones, I didn’t have one. I wasn’t interested in talking remotely to other people. Instead, I jumped on the train of modern smartphones on the first station – the first week after the original iPhone was available, I got one. It’s become an extension of my world, looking at this tiny screen has become an addiction. But I avoid using it as a phone; it’s muted.
I literally cannot understand when somebody is telling me how late it is, or gives me directions to an unknown place. But I can grasp diagrams, tables, texts, interfaces, signs, or images instantly. I’m not deaf; I love music, singing, the sounds of nature. But my ears seem to be connected only to my emotions, and not to my brain.
On the other hand, the connection between my eyes and my brain seems to be a fiber optics cable. I live inside my eyes. My job (which is also my hobby) means looking at code, interfaces, diagrams, articles, specifications, emails, search results, icons, server logs. Being able to live in a digitalized world is a heavenly gift for me. My eyes hunger for text since I learned to read; now I know I can dive into anything I want, I just have to put it on a screen.
When I watch a good movie for the first time, I often don’t get the story. I can’t remember the names of the characters. But I see colors, effects, materials, lights, shadows, signs in the background, textures, dust, skin, hair, tiny little details. I watch it with my eyes and mind fully focussed on the screen, while the music and voices can stream directly to my heart. I can cry on a well-done emotional scene, but I never look away.
People get frustrated with me for not listening to them, not understanding them, or having to tell me everything twice. I get frustrated at people for not seeing icons on their screen, not paying attention to spelling or typography, using gadgets that I find ugly, or using buggy syntax highlighting.
I spent years working on a syntax highlighter library. I’m not a designer, but I felt that getting the details of the presentation for source code right was essential. I’m still obsessed with it; I dream in highlighted code (mostly Ruby) when I close my eyes.
It’s not about aesthetics. I don’t have a good visual taste. It is about information. Truth. Seamlessness. Clarity. To me, the only way to make something clear is to visualize it, with text and code and pictures. This preference (or disability) has pushed me into a specific direction since school. It defines what I’m good at and what gives me trouble. It summarizes my strengths and weaknesses as a programmer.
I feel a bit like a penguin: Hearing is waddling on ice. Seeing is swimming in the ocean.
TL;DR If you want to truncate a SQLite table, use
DELETE FROM table; VACUUM.
While cleaning up my blog (backend, frontend and everything) for the new year, I noticed that the SQLite database I use to store its data had become quite huge — 28 MB huge to be exact. Since I could not dream of having written this much text, I had no idea what happened.
Since I despise writing SQL to inspect tables, I first searched for a simple, free graphical SQLite client (for OS X). No success in the Mac App Store. What I found then was a Firefox plugin called “SQLite Manager”. It’s horrible (Windows 3.1 style icons and poor interface design), but it did its job: After it hung up when I tried to look at the “sessions” table (connecting over SFTP wasn’t such a good idea), the culprit was found: ActiveRecord was storing sessions for each visitor without ever cleaning them up.
So, back to SQL:
Jay Adkisson did a great job in my opinion, and the project is destined to become popular — I guess, in the long run, even more popular than CodeRay. Like Pygments, it has a long list of supported languages, a plethora of compatible stylesheets (even with 256 color terminal output), and the ability to guess the language of a piece of code.
If you’re using CodeRay or one of the Pygments wrappers, you should definitely check out this project.
Rouge also inherits from Pygments the DSL-based lexer definitions, which means it’s much cleaner to maintain, and also slower to execute.
Here’s a very quick benchmark that helped me to get a first impression: