Published on
March 31, 2006 in
SQL and webdev.
I want to outline something I developed something like 5 years ago, and that I was kind of happy with at the time: a way of saving all SQL queries inside the database itself. The reason for writing this is that it would really fit in with all the RubyOnRails and other programming frameworks that are created these days. If someone feels like creating a component/plug-in for it, that would be so nice…
If you have no interest in programming and/or database management, go hug somebody and skip this article.
PRINCIPLE
In the most simple version, you have 1 extra table in your database that looks like this:
query_id int % unique ID of the query
template varchar(1000) % or even longer
var_list varchar(255) % comma separated list of vars
An example:
[ 33 , "select * from users where user_id = %user_id% AND type = '%status%' " , "%user_id%,%status%" ]
Instead of constructing your SQL code in your (PHP) code by making one big string and then executing it, you call a function my_exec_query(query_id,array_params)
This function will
- get the template text
- walk through the comma-separated list
var_list and for each variable inside, look the corresponding value up in the array array_params (or this can be a dictionary or a hashtable).
- when all substitutions are finished, execute the SQL code and return the result as (connected/disconnected) recordset or an array.
Continue reading ‘Storing the SQL queries in the database’
Google is looking for a “Product Manager – Interactive TV”:
In this role, you will provide leadership on product vision and execution of projects that enable using Google’s search and advertising technologies to enhance users’ Television viewing experience.
(…)
These (trends) include but are not limited to the intersection of internet and Television technologies, video-on-demand, personal video recorders and emergence of next generation set-top-boxes with IP connectivity. You will then identify areas where use of Google’s search and advertising technology can enhance this user experience and define appropriate products to deliver these user benefits
from Google jobs
Fewer people will be channel surfing, and more people will want to sit down and literally search for something to watch.
radioactiveyak via CNN Money
Continue reading ‘Google moving into Interactive TV’
Published on
March 29, 2006 in
spam.
Sometimes a spam mail escapes my filters and shows up in my inbox. Last week I got a “Enlarge your …” mail with some girl’s name in the From field. I deleted it right away but subconsciously I had already read some of the content. So I went back and retrieved it from my Deleted Items just to be sure: they really talk about “enlarge a penis up to 10 cm“? (UPDATE: I read this as 10cm TOTAL length, not 10 cm EXTRA length)
Indeed:
First off: as a straight guy I have no practical knowledge of what average size a girl has to put up with these days. Nor am I about to disclose my own dimensions (I want women to like me for my personality). Nevertheless, 10cm or 4″ strikes me as rather short, certainly as an ideal to be reached by taking pills. For those who cannot estimate dimensions: that’s the height of a cheap Nokia phone (the 1100, say).
Continue reading ‘Size doesn’t matter’
Google has filed and published the following patent applications:
(1) Method and system to provide wireless access at a reduced rate:
Methods and system for providing wireless access at a reduced rate. In one embodiment, access to a WAP is provided to an end-user at a rate subsidized by a first entity. The first entity includes advertisements in an end-user view.
which sounds like a Google (secure) proxy that modifies passing-though HTML
(2) Method and system to provide advertisements based on wireless access points:
Methods and system to provide advertisements in a view of an end user accessing a wireless access point. The advertisements are related to the WAP based on a predetermined criterion.
aka contextual advertising for Wifi
(3) Method and system for dynamically modifying the appearance of browser screens on a client device:
In one embodiment, a connection of a client device to a wireless access point is identified. Further, the appearance of a screen presented on the client device is modified to reflect the brand associated with a provider of the wireless access point.
aka the ‘captive portal’
on cre8asiteforums.com via seroundtable.com
Continue reading ‘Google files patents for contextual wifi advertising’
Published on
March 27, 2006 in
Belgium and TV.
Yesterday, while waiting for the Parelvissers to start on één, my zapping pattern made me stumble upon
- Big Brother: some ‘grown-ups’ were fishing rubber ducks out of a pool with forced enthusiasm
- De Pfaffs: 2 ‘grown-up’ men couldn’t work out how to install a game console and resorted to drinking half a dozen beers out of a home tap, in glasses featuring the face of their father-in-law (Jean-Marie Pfaff, Belgium’s best example of ‘brains don’t matter’)
Ironically, the excellent ‘Parelvissers’ show is about the decay of a formerly successful TV production company that falls apart because they produce more and more shitty stuff. I wonder how many of the people in Endemol (Big Brother) or Eyeworks (de Pfaffs) have a déjà-vu feeling when watching the series. “A show that features old people reading their will on TV and explaining why cousin X doesn’t get anything, hey, we had that idea too!“.
Watching Big Brother for 5 minutes was bad enough, but the Pfaffs episode was really embarrassing. Two guys in their late twenties fruitlessly struggling with a game console and a huge flat screen, a pregnant daughter talking to her doctor about her stool inconsistency, a 50-year ex-goalie talking about the importance of friendship while wearing sponsored shirts, … there’s just that much a sensible person can take. This is Reality television when the genre has outstayed its welcome, when they’re just trying to milk a dead cow. Reality TV is dead. Let’s see what’s on the other channels …
De omerta tussen Guido, Dick en Xavier staat op springen, lijkt het. En is Lucas niet met Piet zijn voeten aan het rammelen. Als er maar niks gebeurt met ons Anneke (de promiscue trees). Kijken nu zondag!
Continue reading ‘Parelvissers aflevering 5 komt er aan’
Writing code in your browser, it’s coming this way, I tell you! Some indications:
- my own WikiRAD article (July 2005)
- Playing around with PHP and wikis at the same time made me think on how web-based editing and compiling would be a good way to develop and run web applications
- Feed43
- Create an RSS feed out of any web page by using regular expressions with a nifty Web2.0 user interface. Lots of services are based on URLs and use RSS as input, so this can be the start of a first application. E.g. I just created an RSS feed for the Stubru playlist pages out of a Stubru Javascript file. Imagine I could now tell Feed43:
for each item in feed_that_I_just_created {
parse_the item_url
publish an rss feed for this item_url as feed_url_X
}
and then start working with that content too.
- Amazon S3
- web-based outsourced storage for any application, which made John Keyes and Peter Van Dijck to ask themselves: “Can you use Amazon S3 to create the new Flickr killer?”, and which made me think: but what if not only the storage, but the whole program was run by a 3rd party?
- Iamalpha (via Richard McManus)
- AOL’s new initiative for building microformat-based applications. It’s a bit early to grasp the extent what what they’re trying to accomplish, but I think it’s potentially more than just widgets. They don’t have a web-based IDE yet, but they do have a copy/paste code-validator. Most importantly: the applications are run by AOL!
- YouOS (via Jeremy Zawodny)
a web-based OS that allows you to develop Javascript-based applications in a web-based IDE, with version control and compiling. It’s one of the products coming out of Paul Graham’s Y-combinator startup incubator.
Continue reading ‘Web-based web development’
Recent Comments