|
I have exported the XPS light control source code into my subversion repository. The software is currently set up to build with Cygwin. As an added bonus, I now have added a target that creates a dll so the code can be reused more easily. How to use: xps\_lights>_make all_ rm -f *.o *.dll *.exe gcc -mno-cygwin -Wall -c -o xps\_led\_control\_lib.o xps\_led\_control\_lib.c gcc -shared -o xps\_led\_control\_lib.dll xps\_led\_control\_lib.o gcc..
|
|
Standards are quite useless if fools do not adhere to them; unfortunately fools are everywhere. Therefore, one could almost conclude that standards are quite useless. Specifically I implemented a data transfer protocol based on GET requests, and as specified in RFC 3986 “Uniform Resource Identifier” section 2.5 . … the data should first be encoded as octets according to the UTF-8 character encoding [STD63]; then …. should be percent-..
|
|
This year I will be posting directly to the blog, rather than sending out e-mails to everyone like I've done in previous years. The easiest way to get notified of updates is via a news aggregator . A news aggregator is similar to your Web browser, but with the added feature that it lets you know when new posts have appeared. This saves you the chore of having to check the Websites you are interested in "by hand." In other words, it's so....
|
|
This year I will be posting directly to the blog, rather than sending out e-mails to everyone like I've done in previous years. The easiest way to get notified of updates is via a news aggregator . A news aggregator is similar to your Web browser, but with the added feature that it lets you know when new posts have appeared. This saves you the chore of having to check the Websites you are interested in "by hand." In other words, it's so....
|
|
This year I will be posting directly to the blog, rather than sending out e-mails to everyone like I've done in previous years. The easiest way to get notified of updates is via a news aggregator . A news aggregator is similar to your Web browser, but with the added feature that it lets you know when new posts have appeared. This saves you the chore of having to check the Websites you are interested in "by hand." In other words, it's so....
|
|
Do you speak test? In that case: Hello web application: public class WebIntegrationTest extends net.sourceforge.jwebunit.WebTestCase { public void testIndex() { beginAt("/index.html"); assertTextPresent("Hello world"); } private org.mortbay.jetty.Server server; protected void setUp() throws Exception { server = new org.mortbay.jetty.Server(0); server.addHandler( new org.mortbay.jetty.webapp.WebAppContext("src/main/webapp", "/my-context")); ..
|
|
On my sixth trip to the South Pole, I will try to publish at least one drawing or photo each day, possibly including some text.
|
|
On my sixth trip to the South Pole, I will try to publish at least one drawing or photo each day, possibly including some text.
|
|
On my sixth trip to the South Pole, I will try to publish at least one drawing or photo each day, possibly including some text.
|
|
The security people at my were suggesting that we needed to create an encryption service, to securely store passwords so that even rogue DBAs could not get at them. The idea is that no matter how good your access is to the database, you shouldn’t be able to decrypt the passwords unless you have the secret key. In a solution like this, the key is generally stored offline with the application and loaded into memory sometime during startup.
|
|
Now, this one has been on my TODO list for a while : Trip to LatinoWare and OpenBeach 2005, and the Nivea Sun sailing race in Brazil
|
|
Now, this one has been on my TODO list for a while : Trip to LatinoWare and OpenBeach 2005, and the Nivea Sun sailing race in Brazil
|
|
The `SUM(col)` of zero rows should zero, but is instead `NULL`
-
www.databasesandlife.com
-
19 years ago
-
eng
I must admit I get bitten by this regularly. The SQL standard states that aggregate functions should return NULL if no rows are processed (with the exception of COUNT). This means that computing the SUM of zero rows returns NULL as opposed to 0. This goes against mathematical intuition. If I have zero USB sticks, how much data can I store on my USB sticks? The answer is 0 bytes, but modelling USB sticks in a database would return “und..
|
|
The old expression “Mac users usually swear by their computers…..Windows users typically swear at their computers” got to me last week when my instructor computer’s Windows desktop and applications froze 3 times at the beginning of class. As a result, my Terminal Services connection (that I use to record daily quiz marks) was destroyed each time. So I brought an old iMac G3 with OS X Tiger into my classroom this week and put it on a switc..
|
|
The old expression “Mac users usually swear by their computers…..Windows users typically swear at their computers” got to me last week when my instructor computer’s Windows desktop and applications froze 3 times at the beginning of class. As a result, my Terminal Services connection (that I use to record daily quiz marks) was destroyed each time. So I brought an old iMac G3 with OS X Tiger into my classroom this week and put it on a switc..
|
|
In my last post, I wrote about four integration scenarios using databases: Reference data, Consolidated view, Subscription and Publishing. Of these, the Consolidated View scenario requires the most interaction between the server and the client roles. This post will examine how to make the pieces fit together. Consolidated view joins the data of multiple clients into a consolidated view. This makes you able to create administrative applicati..
|
|
In my last post on using the database for integration, I argued that the best metaphor for creating systems that are interconnected is that of One-Large Database. Carl-Henrik asked some very relevant questions about this, which I will interpret (for now) mainly as “how do you avoid drowning in complexity”. This post will address the issue of maintainability, especially when things grow to be large. The On Large Database metaphor is mostly u..
|
|
I got the following addition on my Dell XPS LED code from David Pritchard. The new version of the code has a “-touchpad” argument. Specify “-touchpad 1” to turn the XPS 2 touchpad light on, “-touchpad 0” to turn it off. Here is the updated source code and executable. The executable should work without Cygwin now. (Note to self: Use “-mno-cygwin” gcc option to strip out the dependency)
|
|
I started to get errors when using gmail. Gmail is normally very reliable. I would enter the URL in Firefox, the white background with “Loading…” top-left would appear, then a little later “This appears to be taking longer than normal” would appear, and that was it. It turned out, I only got the errors when using a T-Mobile UMTS card (in Austria). This has an option to “compress images” which is on by default. This means that JPEGs look..
|
|
The Supreme Administrative Court has ruled that Lord Mayor Jussi Pajunen was disqualified to decide the fate of the historic Helsinki-Malmi airport . Helsingin Sanomat reports : Pajunen participated in the preparation of Helsinki’s general land use plan 2002 in the Helsinki city council. At the same time he was also the president of the Malmin Nova company. The company had business in the Malmi shopping center. In addition the comp..
|
|
The Supreme Administrative Court has ruled that Lord Mayor Jussi Pajunen was disqualified to decide the fate of the historic Helsinki-Malmi airport . Helsingin Sanomat reports : Pajunen participated in the preparation of Helsinki’s general land use plan 2002 in the Helsinki city council. At the same time he was also the president of the Malmin Nova company. The company had business in the Malmi shopping center. In addition the comp..
|
|
Honking Cars in Egypt, especially Cairo honk all the time. Day and night. If we woke up at 4 am in the hotel room, there would be cars honking outside. The honk to wake up pedestrians or other cars, taxis honk to attract the attention of potential customers, and often, it seems like they honk just for the fun of it. Security There’s a ton of policemen in Cairo, easily recognizable by their white uniforms.
|
|
After a rather unsuccessful day, we decided to have a more aggressive program the last day in Cairo. We started out early with a subway trip to Coptic Cairo. It seems that very few tourists are using the subways, which is a pity because it is a pretty good system. If they only could have any information in English. We had to trust the ticket guy who said it was LE 2 for both of us.
|
|
We had a late start on Wednesday. We are going to take the train to Alexandria, and we want to make sure that we get the tickets, so we start with a trip to Ramsees railway station. I had expected the trains (which seem nice from the guidebook) to be much used by tourists, but as it turned out, all the information was in Arabic, with the platform numbers, and the word “platform” as the only thing in English.
|
|
In Cairo, we have noticed a recurring theme. Many places that are visited a lot by westerners are sectioned off from the rest of the city. When Egypt was a British colony, the colonialism was expressed by importing British culture into Egypt. With modern colonialism, a section of the western world is placed wholesale as a small colony inside the city. After a rather tiresome day, we didn’t feel like we had the energy to go egyptian style ag..
|
|
Broward Horne is a software developer with a diverse background, including several years as an electronic technician at Litton and Teradyne and as a sysadmin at a major University. Broward also has a business background, doing contract work for the United States Department of Transportation on experimental pen-based systems, early wireless LANs and two-dimension barcoding. Since 1999, he has been in java software development, mostly for sal..
|
|
Broward Horne is a software developer with a diverse background, including several years as an electronic technician at Litton and Teradyne and as a sysadmin at a major University. Broward also has a business background, doing contract work for the United States Department of Transportation on experimental pen-based systems, early wireless LANs and two-dimension barcoding. Since 1999, he has been in java software development, mostly for sal..
|