Tuesday, December 30, 2008
Thanks to a plug from TechCrunch, I have discovered Posterous, and I am very happy with it. It allows me to post stuff to any combination of Twitter, Facebook, or my blog, all from my email or from SMS. I can even have one item which posts to all of them, which is very useful for links to interesting stuff.
For example, this blog is being written on Thunderbird. HTML formatting seems to make it through unscathed.
And note that now I have offline blogging, tweeting, and updating Facebook, without some specialized software for each service.
I write to firstname.lastname@example.org, it goes to my blog. I write to email@example.com, it goes to, you guessed it, Twitter and Facebook. I write to firstname.lastname@example.org, it goes to all three.
The one bummer is that the Facebook interface doesn't set my status - instead it adds something to my wall. So if you're just looking at my status updates (e.g. through the status RSS feed which I just discovered, cool!), you won't see my Posterous posts...
All the same, I highly recommend checking it out...
Friday, December 19, 2008
But the comments and tweets I've seen since Petr blogged about SQL completion in PHP are very encouraging that we're on the right path...
Here are some sample tweets - I love the "scribbling on the wall" nature of tweets. It's almost like being in a bathroom stall :)
PHP support in NetBeans keeps getting better - SQL code completion is tight http://is.gd/c00a
trying out NetBeans. Nice fieatures and "Now with PHP support!" If MySQL code completion works as claimed, I'll be overcome with giddiness
I'm not much of a twitterer myself, but I've found that listening in on RSS feeds for Twitter Search has been very useful in sensing the pulse of the community...
I was debugging a unit test, and there was a method I wanted to step into only when my particular test case that was failing was hit. This same method is called repeatedly, so I didn't want to put a breakpoint in it, or I would hit it over and over and over again until I got to the invocation I wanted to debug.
The problem is, once I was in there, I didn't want to step, step, step to get down to the actual method I wanted to step into from there. Capiche?
So what to do? Well, I though, it sure would be nice if I selected to the method I wanted to step into and just say "go there." What the heck, I said, let's put my cursor there, right-click, and see what happens. Magic, that's what!
Note how the method I care about is highlighted in yellow. That happens automatically when you click on it. Then notice the "Run Into Method" action in the drop-down menu.
Hey, why not, I tried it, and bingo, there I was! It's a thing of beauty I tell you!
Thursday, December 18, 2008
But, yes, there is a new New Connection dialog planned with a Test Connection feature. It will also have a "Automatically Reconnect on NB Restart" checkbox that I know I will love to have.
Note that what he's showing is a wireframe/mockup and not the actual dialog. Point taken about the current dialog being too wide, we'll see what we can do about that.
And yes, we are looking at making a help plugin with full MySQL docs and also making MySQL documentation available in code completion for MySQL functions (to start, maybe keywords later), both in the PHP editor and the SQL editor. If we get this to work, it will be very cool
Another problem with the net is that it's still "technology", and "technology", as the computer scientist Bran Ferren memorably defined it, is "stuff that doesn't work yet." We no longer think of chairs as technology, we just think of them as chairs. But there was a time when we hadn't worked out how many legs chairs should have, how tall they should be, and they would often "crash" when we tried to use them. Before long, computers will be as trivial and plentiful as chairs (and a couple of decades or so after that, as sheets of paper or grains of sand) and we will cease to be aware of the things.
...the following query returns all the items which have the values 'Book' and 'Hardcover' in keyword:
select * from my domain where every(keyword) in ('Book', 'Paperback')
Now available in the nightly builds, when editing a date field, just click on the drop-down arrow and you get a nice date picker. This is so much nicer than trying to enter in the date by hand.
All this cool data entry functionality is coming from Ahimanikya Satapathy's team in Bangalore. They are a completely separate team here at Sun - they don't even have the same VP as we do. His team is part of the group that delivers Sun's Java CAPS (Composite Application Platform Suite). This suite provides SOA and data integration services for Sun customers. It's been great working with them, a win-win for both of us.
Next up from them, import/export to/from CSV and XML. Stay tuned...
This isn't quite working yet for MySQL, but should be fixed in the next few days... We'll also be fixing the dialog for creating a new connection so you don't have to specify the schema any more, we'll just use the default given by the database. If you want to switch your default, just right-click on a schema and say "Set As Default" That'll be nice...
Wednesday, December 17, 2008
Just last night she was struggling with "eight" saying something like "ee-ga-hut" and I said "that spells 'ayt'" and she said "WHAT? That makes no sense!"
She also got quite mad at words like "through", "psychic" and "laughter". I hadn't thought of this for a long time, but working with her bring the silliness of English spelling all back. Although in a way it's fun to use the spelling to figure out how it used to be pronounced a thousand years ago: "threwoch" for "through" and "k-nicht" for "knight."
Which brings me to a note she wrote a year ago, before learning to read.
I wit awot sid to luc for a for leef clover.It turns out that there are still people trying to simplify spelling of the English language.
ps i wat sicer doo dols for my nix chreet
Here is Mark Twain's proposal for fixing English spelling.
For example, in Year 1 that useless letter "c" would be dropped
to be replased either by "k" or "s", and likewise "x" would no longer
be part of the alphabet. The only kase in which "c" would be retained
would be the "ch" formation, which will be dealt with later. Year 2
might reform "w" spelling, so that "which" and "one" would take the
same konsonant, wile Year 3 might well abolish "y" replasing it with
"i" and Iear 4 might fiks the "g/j" anomali wonse and for all.
Jenerally, then, the improvement would kontinue iear bai iear
with Iear 5 doing awai with useless double konsonants, and Iears 6-12
or so modifaiing vowlz and the rimeining voist and unvoist konsonants.
Bai Iear 15 or sou, it wud fainali bi posibl tu meik ius ov thi
ridandant letez "c", "y" and "x" -- bai now jast a memori in the maindz
ov ould doderez -- tu riplais "ch", "sh", and "th" rispektivli.
Fainali, xen, aafte sam 20 iers ov orxogrefkl riform, wi wud
hev a lojikl, kohirnt speling in ius xrewawt xe Ingliy-spiking werld.
 "I went outside to look for a four leaf clover. Ariel. P.S. I want snicker doodles for my next treat."
Tuesday, December 16, 2008
He was asked what he thought about Obama winning the election, and he said (paraphrased as best I can):
When I was in school Kennedy won the election. The nuns at my school told us that this mean anybody could be president, anybody. So I went home and told my Dad this and he said "yes, it's true, anybody can be president." And I said "so that means I can be president!" And my Dad said "You? Pffff! What are you crazy?"
Monday, December 15, 2008
Thursday, December 11, 2008
OK, fine, but these sure sound like band-aids on a huge problem. I didn't hear him actually say "we will guarantee health care to every man, woman and child in the USA without breaking the bank." Because that's what we need, and badly.
When I was on vacation this summer, the place where we were staying had a copy of Tim Harford's the Undercover Economist. I was intrigued by his discussions of health care. First of all, he says health insurance is intrinsically broken because it's like the used car market: the insurers can't get enough information about the insured's true health (although they try), and so they have to charge you (or your employer) assuming you're going to get sick. As a result, the healthy people bow out of the insurance market, and you're left with those who need it, and thus in a vicious circle the costs go up even more.
He also claims (and this makes sense) that single-payer insurance managed by the government is guaranteed to be costly and inefficient, because it is not market-driven. That doesn't mean we should just privatize insurance and let the poor sick shmucks die. But a true free market brings out the most efficient solution. So, through our taxes, the government should subsidize a market-based health program. A program like this that is actually in place and actually works incredible well is the one in Singapore. Singapore (it's a "fine" place :)), well, it's an odd place, but they have some of the best health care in the world with one of the lowest administration costs anywhere. See Bryan Caplan's discussion here.
Will we ever see something like this in the USA, where the individual's make their own choices for how they allocate their health care dollars? I doubt it, especially after hearing Obama's (pardon me) weak proposals. Why? Entrenched interests - in particular, insurance companies. A program like this eliminates the need for insurance. Poof. Gone.
So instead I suspect we'll see an ongoing snowballing mess of the existing situation with government money pouring into particular initiatives that may, or may not, help the problem, because they are in no way driven by a true market. Ugh.
But you know, Facebook ultimately works for its advertisers, not for you and me. That bothers me, both in terms of what's happening with my data, what drives Facebook's features, and Facebook's long-term viability, especially in a knock-down economy like this.
So, I have a wild idea. Let me pay you, Facebook. $10 a month.
And for that $10 a month I want you to kiss goodbye to your advertisers. I don't want my data analyzed, scraped, or monetized. I want you to guarantee complete ownership of my data.
And I don't want to have to go to your site to get status updates. I want to get them on email, on SMS, on IM. It's not a surprise you can't do that today, because that would mean not seeing all the ads and "additional features".
And don't be like cable. I remember when cable first came out, the idea was, we pay you, and we don't have to watch ads. Five years later, cable was full of ads. To me that's a breach of trust.
The thing is, Facebook has become a black hole. So many people are there, it's where everyone meets. It doesn't matter if other services are free. Everyone's hanging out at Facebook. It has reached critical mass, and people are addicted to Facebook. It's like their morning paper.
So, charge a cover charge (at least as an option), and become beholden to your users, not your advertisers. Please.
Wednesday, December 10, 2008
Here's a summary of the timing
- Download: 2 minutes and 30 seconds. I cover this time by describing bringing up a slide and describing the clustering architecture
- Installation and cluster setup: 4 minutes, 30 seconds.
- Verifying and testing cluster by deploying a sample application: 3 minutes
We were initially thinking the project would cost $10,000, but the owner of the company kept asking for additional features, so we thought maybe the cost might rise to $20,000. But in the end, the final cost was close to $50,000. Flash is not a serious programming environment, and as soon as you try to do something ambitious with it, you learn a painful lesson about its limits. For this reason, I am very excited about JavaFX
as you scroll on your computer, your guest will see what you see and their view will scroll as you scroll. Visit a YouTube page, for instance, and the video will start playing on everyone’s desktop - all in sync.
I've been very interested this since I heard Shai Agassi was leaving SAP two years ago. I really like this idea. My only question is - what is being done with old batteries? I can imagine huge toxic waste dumps of old batteries - not a pretty picture.
I know there are other tools out there that do this as well. If it were me, I'd much rather have a tool like NetBeans do it than write a script like this...
I think to keep things simple, maybe I'll just start calling everyone Petr...
Tuesday, December 09, 2008
In this session we’ll be building a PHP+MySQL application that uses the Twitter API and has some AJAX fun with it.
You’ll also get a chance to see what it’s like to build an application in a PHP IDE like NetBeans. Those of you who use ‘vi’ might want to see how the other half lives, and scoff at us under your breath. Or you may actually get turned on to the power of a good IDE and realize hey, I could use some of that.
In this session we will be demonstrating
- Building a PHP+MySQL+web services+AJAX application in NetBeans
- Using the Twitter search API
- Using AJAX-based graphing tools to provide dynamic graphing to your application
And then I remembered Eric Schmidt standing there behind Obama as part of his economic team, and if I were Eric Schmidt, I would see these kinds of government investments as pure manna from heaven.
I actually like the idea of making broadband generally available, so that everyone has access to it. That sounds like a good thing. But is that truly a priority? What happened to the greening of our infrastructure? I didn't hear a peep about that.
Then there's this thing about getting computers in every classroom. I hope they're not thinking that in and of itself will make our kids smarter and more competitive. I'm a computer guy, but I personally don't believe that computers necessarily make for smart and self-sufficient kids. I do know they can easily make kids who are hyper-restless and unable to focus, and kids who sit around all day staring into computers and video games.
Human beings live in a body, and working with a computer all the time (I speak from grim experience) takes you "out of the body." The body is key to learning, and computers (and TVs) remove all need for the body to be engaged, so what you get is shallow learning. No, I don't have data to back it up. My blog, my opinion.
I just wish I had seen a more balanced proposal to improve education, instead of focusing on broadband and computers. Why not more investment in science and research? Why not more investment into music and the arts, which allow for a more rounded and creative populus? And again, why the focus on computers, when there are so many other things we can focus on?
And what's this about medical records? Why is that important to our economy, and more importantly, why does it take top billing in his weekly address? But one thing I know: Google has been very interested in medical records.
Silicon Valley has been behind Barack Obama in a big way. In general I think that's a great thing, and in general I believe Obama is a huge, huge improvement to what we have had for the last eight years-plus. But when I see stuff like this, I just sigh. The whole thing smells to me of the same old politics, sorry...
With the graph above we see that the IMDG [In-Memory Data Grid, which runs on top of MySQL] scales very close theoretical linear scalability. The above results were achieved with an IMDG running on 2 partitions. Better scalability can be achieved by increasing the number of partitions.
Read more about how to scale-out the data-tier in Scaling-out MySQL.
To enable this level of on-demand scalability we used our new Cloud Framework, which combines the GigaSpaces SLA-driven container as the application deployment virtualization layer, Amazon EC2 as the machine level virtualization layer, and the GigaSpaces application server as the middleware virtualization layer. This way we can provision new machines as soon as the SLA on the web-tier is breached (measuring latency, in this specific case).
Monday, December 08, 2008
At around 8 pm this Pearl Harbor Day we loaded up the little BMW and set forth for the city. It was overcast and dark on 301, the narrow country road that takes us to the highway. We had gone no more than a mile when a weird thing happened - the headlights of an oncoming car suddenly
disappeared. I had about one nanosecond to wonder about this when a huge horizontal tree trunk appeared in the headlights, right in front of us. I hit the brakes hard, but not soon enough, and we ran right into it.
The tree had fallen straight across the road, and was suspended about 4 feet off the ground by the guard rails on both sides. Thus it was invisible until we were on top of it, right at windshield height.
Screech ka-thump! and there we sat, covered in a snow of glass fragments, totally freaked out but completely unhurt. The airbags did not deploy so I guess we had almost managed to stop. The engine was running, the headlights were on, and the car seemed diveable, so I backed up about 20 feet thinking to turn around, but the windshield was just one mass of shattered safety glass so I gave up on that. To avoid getting smacked from behind I turned on the flashers, and Enid called
911. The police and fire department were on the way. A minute later another car called pulled up beside us to ask if we were OK.
It was then that I noticed the power lines right in front of my face, which the tree had pulled down beneath it as it fell. I couldn't tell if they were touching the car or not, and I certainly was not going to get out and look. If I had a brain in my head I would have backed up further to get clear, but all I could think was - DON'T MOVE! A woman got out of the other car and peered at the cables. "They're about two inches from the top of the car," she said. "You can get out, if you're careful." We thought about it, and decided that we didn't want to just sit there in the broken glass, so we got out. Carefully.
We were standing talking when an emergency service car arrived, lights flashing. "You folks stay right here," he said. "I have to put some flares out on the other side of the tree." Er, I said. Good luck ducking under that tree; it's lying on top of the power lines. He stopped and reconsidered. "Folks, let's move back a ways. And don't touch that guard rail!" The one the tree was resting on, he meant. When cars approached from the other direction, he waggled his flashlight at them. They stopped and turned around.
Then a huge fire truck arrived, and the firemen got out and stood there looking with their emergency lights flashing on the tree trunk. Enid asked if we could get our stuff out of the car. "Lady," said the head fireman, "You're not going near that car. And if I'd got here before you climbed out, you'd still be sitting there waiting for the power guys to show up. Do you realize you coulda fried like a piece of bacon?" So NOW Enid gets scared. Too late.
The fire ambulance arrives, and we are invited into the warm roomy back cabin to get a quick once over, blood pressure and pulse, and fill out forms. We hang out for a while, chatting with the nurse and the old Chief Volunteer (about Pearl Harbor, among other things). The policeman sits in for a while, to fill out his accident report, and the fire chief sticks his head in to scold us again, before saying that the power guys are busy - it's been a windy evening - but will be here soon so the VFD will be "fading away now". It's amazing that all these people, every one but the policeman, are volunteers. Huge burly guys in their fireman suits, the nurse, and all.
We get a ride home with the ambulance, and phone the towing service to bring the poor car by, once it's been rescued from the power cables, so that we can get our stuff out. The damage seems relatively minor - windshield demolished, a bit of a dink on the "eyebrow" above the windshield, and the side view mirror destroyed - but the Chief Volunteer, who has seen a lot of this, says it's even money that the insurance company will total it rather than pay for repairs. (We know that one -- fix it up for a thousand bucks and sell it for 12 grand. It's a 2001 325i sports wagon, 65K miles, all wheel drive -- a sweet little car and well maintained. Bah.)
OK, it's freezing outside, down around 15 degrees according to the tow truck guy. It was very cold to climb around on the tow truck to get into the car and unload to Enid standing below, but we went back in the house and had a shot of scotch and a big bowl of ice cream and all is well with the world, more or less.
As jobless numbers reach levels not seen in 25 years, another crisis is unfolding for millions of people who lost their health insurance along with their jobs, joining the ranks of the uninsured.
Friday, December 05, 2008
... sometimes you may want to sort your strings based on some other rules than those in the languages supported by the JRE. The most common example is that users want case-insensitive string matching. Another example came up recently in this thread on derby-user, where a user wanted to modify the German collation rules to make Greek characters sort near their Latin equivalents ('α' near 'a', 'β' near 'b', and so on).Bada boom, bada bing.
Derby currently (as of 10.4) doesn't allow you to define your own collation rules, it merely relies on the collators returned by java.text.Collator.getInstance(java.util.Locale). Fortunately, the JRE allows you to define new locales with their own collation rules. And it turns out that it's quite easy, just perform these three simple steps:
- Create a class that extends java.text.spi.CollatorProvider and returns a collator that orders strings the way you want it to
- Create a text file named META-INF/services/java.text.spi.CollatorProvider which contains one line with the name of your collator provider class
- Put the compiled class file and the text file in a jar file which you drop into your JRE's lib/ext directory or in one of the directories specified by the java.ext.dirs property
Thursday, December 04, 2008
SimpleDB makes it easy to scale. You don't have to worry about creating a complex master-slave setup to support a high level of concurrent access. In fact, concurrent access is where the SimpleDB model really shines. Fire up a bunch of threads and start sending requests our way. SimpleDB can handle the load. In fact, during the private beta the developers at Pluribo scaled their application up until it was making 5600 requests per secondSome things to note:
- 60 day free trial for up to 1GB of data
- 30 day free trial of the Simple DB Explorer, including upload of MySQL data into SimpleDB
- Tools for various languages, including Java, Python, Ruby, and ActiveRecord
- Queries can include sorting on any attribute
- Coming soon: a SELECT-like API and batch loading
Fade to the present. A few days ago I sat down with one of our best and brightest engineers on the NetBeans team to get his help with something. This guy is famous for his ability to pump out good, cool, useful code. He is an invaluable member of the team.
After our technical discussion, we were chatting about this and that, and he mentioned he was having problem with our mail server which appears to be caused by the fact that he has over 20,000 unread messages in his Inbox.
I just stared at him. He said "I know I should be reading all these, but every time I read something, it's something else I have to do, and it stops me from getting my work done."
I said, so how do I reach you? He said IM, and gave me his IM account. But he said most of the time he marks himself as away because otherwise his mother will want to chat.
He also said he has a private email account for personal conversations, but he generally doesn't read those either.
Then he said, I guess if you really need to reach me you can call me. I said "but last time I called your extension, your voice mail said that the best way to reach you is by email!" He laughed and said that actually he hasn't listened to his Sun voice mail in about six years.
And I realized, this is someone who is so passionate about his work that he will accept no distractions. He is on a mission, and he gets stuff done. It may be highly frustrating to try and talk to him, but you can't deny his real value to Sun.
So, thus, my new motto: "Those who can, do. Those who can't, tweet." Now, back to work, and maybe I'll get back to you.
Wednesday, December 03, 2008
The correct spelling is actually bated breath but it’s so common these days to see it written as baited breath that there’s every chance that it will soon become the usual form, to the disgust of conservative speakers and the confusion of dictionary writers.http://www.worldwidewords.org/qa/qa-bai1.htm
For those who know the older spelling or who stop to consider the matter, baited breath evokes an incongruous image; Geoffrey Taylor humorously (and consciously) captured it in verse in his poem Cruel Clever Cat:
Sally, having swallowed cheese,
Directs down holes the scented breeze,
Enticing thus with baited breath
Nice mice to an untimely death.
Tuesday, December 02, 2008
It's asinine to do it this way. However, there is a good reason why I haven't just skipped schemas schemae schemata One to Six. There are a lot of people in the world who actually think like this. This is their for-real, no-joking conception of "marriage". They do not grasp that men and women are interchangeable, as a result of which homosexual marriages create repulsive integrity problems in their heads. "But if they're both guys, which one is the wife? Does not compute!" How sad.
It all started when I backed my car into the garage door, bending it in an ugly way and leaving a gap along the ground. Let this be a warning to you all - FIX HOLES IN YOUR HOUSE RIGHT AWAY. After a few months, the rats crept into the garage and enjoyed the food we were storing in there, and made a disgusting pissy/crapy nest of one of our camper foam pads.
That was a year ago. It has been an unending battle every since. We closed up the hole in the door and every other hole we could find in the house. The rats remained. I initially tried soft tactics, such as putting peanut butter down the side of a bucket that they would fall into. They laughed at such innocence. I set traps. They were ignored.
One day I opened the door to our water heater closet and convulsed in disgust when three rats who were warming their bellies on the top of the water heater (and probably having a few beers) went skittering up the pipes into the attic.
We put wire mesh along the gap in the door to the water closet. They promptly dug a new hole through the wall from the crawl space. We removed all food from the garage. They built a nest in the attic above our house; we could hear them scraping and digging in the wall just above our heads in the bed. We could hear them dancing on our ceiling at night.
We called in an exterminator to destroy this infestation. He laid traps everywhere and got five (or was it six) rats. But one of them completely ignored the traps. Every night we still hear her scraping and digging right above our heads. It is infuriating.
One day I went to fetch our sleeping bag from our outside earthquake bin and found that our food supplies had been raided, shredded, urinated and defecated upon. I spent an hour cleaning up the unholy stinking mess (being eaten alive by fleas - did I mention that we had a flea infestation, probably because of the rats?). I saw our dear friend had dug a hole right through 1/4 inch of hard plastic to get in.
We removed the food and I put a trap in there. She ignored it. She went back into the garage and got into some Cliff Bars we had left in there (silly us) and then proceeded to destroy a diaper bag I had put in there which must have had a little food in one of the pockets. Arrrgghhh!
Last night I got Rat Glue traps and laid them in front of the hole. She deftly stepped around them, and this morning I saw her (a beautiful gray specimen) running along the railing above our garage door.
This morning I listened to the terror experts talk about the difficulty of fighting terrorists, how their roots are deep and almost impossible to eradicate, and how everybody is tired of them and wants them to go away. Although my problem is on a much much smaller scale and involves destroyed property and not human lives, I could only nod my head. I completely understand...
Monday, December 01, 2008
I had a problem with Derby DB connectivity with netbean 5.5.1.
I had changed the location of my application server but the libraries had not changed too.
I saw a solution that you had put on the internet for another query and so I changed my library locations according to your instructions.
My application ( from a book) now works and I am very grateful for your help even though you are unaware of this.
Before breakfast, we spent an hour tightening ropes holding down our tents, a task that would usually take 10 minutes. While we were outside, our weather station recorded a 91mph gust, and average wind speeds were around 70mph [a hurricane is defined as 72mph and above]. Imagine sitting on the roof of a car speeding on the freeway and you get an idea of the forces involved. It was impossible to walk or stand, and, to reach our tents, we crawled over the rocks and ice.
EATABIT - The heck with the food chain, waiting for all those copepods and krill and anchovies to pass the nutrition up the line to get to something we can filet, with everybody taking their middle man bite of the energy before it gets to us. The time has come to start breeding edible plankton.
Wednesday, November 26, 2008
The names of the places - the Taj, the Oberoi, the Indigo Deli, Colaba - all places we have been to and enjoyed. The pictures bring back memories, at a difficult and sad time.
My prayers go out to all those in Mumbai and around India undergoing this horror - we are with you in spirit
Tuesday, November 25, 2008
Dad! You mean you rode around in uncontrolled travelcars that you had to steer yourselves? Didn’t you crash into things? You could even run into one another and get really hurt, if you weren’t watching and steering every minute! How could you sleep?
Thursday, November 20, 2008
To refresh, here's an example of what it would look like:
But I have also gotten some feedback from more than one source that this may not actually be as valuable as it may first appear. The reason is that, and this makes sense, the actual work flow when building SQL for your application is as follows:
- Open SQL tool and write your query
- Execute, evaluate results, modify, repeat
- Copy and paste final SQL into your editor
What are your thoughts? Can you explain to me why SQL editing features in the code editor is valuable, if generally SQL is composed in a SQL tool/editor?
One thing we've talked about is enabling testing from within the code editor. But it's not clear what this would look like. We would need to be able to build up an executable SQL statement from SQL that contains substitution variables and may even be a concatenation of multiple strings. I suppose it's possible, but it seems complicated and error-prone.
I suppose one simplistic approach is the following flow:
- In your editor, write a full SQL statement as a string
- right-click and choose "Test SQL" (or run a hot key) to let you test the SQL string right there in the application editor
- refine, retest
- modify the SQL to use substitution variables
So, what are your thoughts? Your feedback much appreciated.
Wednesday, November 19, 2008
If you execute a query and you get results, you can then do a number of interesting things with them.
Things like show what the CREATE TABLE statement would look like, or copy and paste the data you have selected (the paste format is hard-coded right now, but next release we plan to support CSV and XML output).
The one I like the best is that you can generate INSERT statements for the data.
Combine this with generating the CREATE TABLE statement, and it makes it really easy to hand your data set to someone else for testing or collaboration.
Some of the use cases include:
- Get a connection from the explorer and using it to automate some kind of database functionality, such as generating code based on a database schema
- Add drivers or connections to the explorer either through a layer file or programmatically
- Dragging and dropping a table, view or column onto a UI component and then getting metadata for that element. This is used, for example, to bind a database element to a field in Matisse or the visual web toolkit.
In the next release, we are making it possible for you to add nodes to the Database Explorer tree and to add actions to a specific node. This is very nice when you want to integrate a database-specific addon plugin to NetBeans.
We also plan to add a metadata API that will allow you to easily inspect database metadata for a given connection without having to dive into the complexities of the JDBC DatabaseMetadata API.
Lots of news today. Looks like we have a pretty cool early access of Python support available.
From the Python page:
- Python project support
- Fully featured editor
- Interactive interpreter console
- Debugging for Jython and CPython
By moving the sorting out of the database and back into the application, plus putting a limit on how many stories would be returned to any first request, Freund watched query execution time drop from an average 5.27 seconds down to 2.54 seconds. In other words, Clickability chopped 48% of the time it took to execute each query out of his overhead. The new tool "gave us a snapshot. We learned more about query usage in two minutes than we could gain in two years of ad hoc log analysis and guessing,"
Of course there is also the cool stuff we've done in the databases area:
- SQL code completion
- SQL history
- Editable, pageable results
- Export results as SQL INSERT statements
- Easy installation of Sakila sample database
I installed Quan (Query Analyzer) and within about 20 minutes it became clear I had a query that was averaging 14 seconds to run. This query doesn't get run all that often, every 5 minutes or so, but it uses a table that is the most active table on our system.
OK, click on the query and it pops up a full view, showing the query with literals replaced by place holders. If you have Example Queries configured, you can check to see if there is an example showing all of the data, and if you have Example Explain configured, you will also be able to get a full breakdown of what indexes will be used in resolving the query.With a few minutes of checking the query and fine tuning it I was able to get it down to 0.15 seconds on average. That is almost a 100 fold improvement.
Tuesday, November 18, 2008
So, I decided it was time to move on. I checked out Google Analytics, but they're talking to someone who isn't me. It's all about monetization and improving your click throughs blah blah blah.
So I looked around, and now I'm trying out Clicky. So far I'm pretty happy with it. Sad thing about Feedburner... I wish Google would just explicitly kill it instead of letting it quietly die.
Take a look - yes, you're getting column names in the completion list when working with a string literal in PHP. And notice how it works with aliases...
It's a prototype, but it's a good start, and we expect to have something like this working for you in NetBeans.next
Friday, November 14, 2008
I just read the news.
I don't know about you, but I was pretty much expecting this. Even though it may cost me my job, I am glad they bit the bullet and cut 15%. We're just burning too much cash and the size of the company didn't match its current market cap.
How do I feel? Relieved, in a way, because I knew it was coming. Am I affected? I have no idea. Nobody's telling the peeps yet, that will happen in the next few weeks.
Software is getting seriously reorganized. NetBeans is now part of the cloud computing platform. Why? My blog, my opinion: because I think Sun gets it that what Sun can offer in this space is a developer platform. Amazon Web Services is a bunch of cogs and wheels targeted at system admins. Google App Engine is focused on a very small slice of developers who are willing to work with Python and BigTable and don't mind locking themselves in to Google.
But Sun has something more to offer, a different path to take. If you combine the strength of the NetBeans development environment with a cloud platform, now you have something interesting. I look forward to see what this looks like.
The Open Office team is also part of the same group. Now that's intriguing. Open Office has a lot to offer over a pure SAAS play like Google Apps. I can envision (again this is just me thinking, don't think I have any kind of "in" to what's actually going on), I said, I can envision taking parts of Open Office and "cloud-enabling" them, while continuing to give a rich desktop experience. For example, I can envision saving my documents to a cloud-based storage service so I can access them anywhere, or adding collaboration features to OpenOffice ala Google Spreadsheets.
Similar realignments are helping elsewhere in Software. The OpenSolaris group is joining the Systems group so they can focus on innovative integrated solutions like OpenStorage. The MySQL team is going to work with the rest of the application platform folks like Glassfish and Identity to provide a complete solution with add-on and optimized products and services that can bring in revenue.
So there is a lot of opportunity here to innovate and make money (and of course an opportunity to fall flat on our faces :)). The question, as always, is, can we pull it off, will it be enough? Is this the right direction? Well, we'll just have to see. I may be crazy, but I like this company. People here are smart, innovative, dedicated and kind. I'm hopeful. The audacity of hope.
And will I be there to see Sun come out the other end? Well, we'll just have to see... :)
Thursday, November 13, 2008
From the author of Liar's Poker comes an excellent and disturbing article about the culture of Wall Street and how incredibly greedy and free of conscience the folks were who were making a killing using other people's money.
Wednesday, November 12, 2008
We get this data through collecting "gestures" - where we track the clicks and actions performed by users who "opt in." In this case we detect what database vendors our users connect to through NetBeans.
Monday, November 10, 2008
Obama Win Causes Obsessive Supporters To Realize How Empty Their Lives Are
Thursday, November 06, 2008
VIENNA, Austria — She was a stranger, and she kissed me. Just for being an American.
It happened on the bus on my way to work Wednesday morning, a few hours after compatriots clamoring for change swept Barack Obama to his historic victory. I was on the phone, and the 20-something Austrian woman seated in front of me overheard me speaking English.
Without a word, she turned, pecked me on the cheek and stepped off at the next stop.
I found 25 or so people who had made their way in the dark to the marble steps of the memorial and stood silently around a lone transistor radio.
I think there are a number of reasons.
First, it is just plain amazing that a black man will be our next president. It just never seemed possible, and I still feel like I'm pinching myself. In a profound way, it has healed and old old wound in this country. No limitations.
Secondly, I think many of us weren't consciously aware of the emotional damage being done to us watching those in power lie, cheat and steal in a million offensive and painful ways. Almost every day for eight years we have been hurt and outraged by the immoral acts of our administration. It just places a heavy burden on you.
And then, like that, it's gone. Thus, the jubilee. With the lifting of that burden comes elation, and tears. We did it. We are rid of the scoundrels. I don't think any of us expected the power of that feeling when Obama finally won. It was like a tidal wave of relief, for the whole world. We try to be realistic, be cynical, but the relief just overflows.
Then there is Barack Obama himself. You can never really tell, but all signs point to him being an excellent president, a president who serves his country rather than use the position as a way to party and profit. He inspires, he is thoughtful, he listens, and he comforts with his calm and discipline. His family seems truly happy and loving. They seem to be good people.
My final feeling of joy and hope is that, in no small part due to power of the social web, we seem to now be able to elect someone who has not been anointed by the powers that be. Obama defeated the Clinton machine and the Republican machine. That would not have been possible without the money and volunteering from an army of citizens.
Now I'm sure if McCain had won, he would have been a different president than Bush, and there would have been some relief in that. But he was backed by the same scoundrels who backed Bush, and I believe that if he had won, it would have been like a stamp of approval to business as usual. The rest of us, both in the USA and outside of it, would have crawled back into our holes to hunker down and weather it through.
There are difficult days ahead. There are still major issues with the structure of our system. But at least we were able to make our voices heard, and we are now prepared to team together with our government to work to heal these problems, rather than watch with chagrin, outrage and a sense of powerlessness as our administration and their cronies ransack the country.
Wednesday, November 05, 2008
My take on this: it's an ongoing effort. One has to hold the vision of where we want to go. Barack Obama, a black man, is now our next president. Yes we can.
This last week, I listened a lot to the concerns of the Yes on 8 folks. What I am hearing is that they have strong religious beliefs that marriage is between a man and a woman. There is a sense that any other kind of marriage is "unnatural." There is a feeling of the sanctity of marriage, that it is a union blessed by God and should not be tampered with by the State.
I can see how one might think that way. I can see how the thought of a gay couple getting married is like "ewww" and feels "wrong." One could argue, well, why not allow a man or woman to marry a sheep next?
But seeing so many gay couples get married, these arguments just fall away. I wish those who feel gay marriage is "wrong" or "unnatural" could be at these weddings like a fly on the wall and see the love that is there.
When I am at these weddings, I see the sanctity in their vows. The power of those vows and that commitment is there as fully as at the heterosexual weddings I have been at. I feel God's blessings and support descend upon these couples during their vows like a blanket of light.
What is sacred and holy is not the shape of the bodies containing two loving souls, but the love itself, and the act of commitment and sacrifice that makes that love manifest. The outer form of the two souls is just window dressing.
Since I have had that experience, I believe that it is morally right that we should allow any two loving souls to make the commitment of marriage. Anything that prevents that is discrimination and goes against God's loving nature. So, the fight goes on.
It was a phenomenon captured in a photograph ... shared last week of a homemade sign with the Confederate flag. It read: “Rednecks for Obama. Even we’ve had enough."
Tuesday, November 04, 2008
I still remember the Luo tribe, which is the tribe Barack Obama's father comes from. They had beautiful shining black faces with high cheekbones and dazzling smiles. They were always so friendly and loving and open-hearted. Hard to imagine that town bursting into riots.
What a strange connection with my childhood.
Monday, November 03, 2008
By the way, I grew up in Colorado. I've met people like this and gone to school with them. They helped make junior high school miserable. When I first came to Colorado some of the boys told me my parents were hippies. I had never heard what a hippie was, and when I asked them, they said that hippies walked around naked, lived in caves, and peed outside. Even at that age, I wasn't sure what to make of that. Some comments just stop your mind.
It's also disconcerting that the McCain/Palin ticket seems to be drumming up/stirring up these kinds of passionate, fear-and-anger-based feelings. It reminds me of what the dwarfs did in the Mines of Moria - be careful how deep you dig, as you may unleash a power greater and older than anything you can handle. The Balrog is being awakened...
Now, for reasons I don't fully understand, there is strong support to eliminate this right by explicitly disallowing anyone to marry except a man and a woman.
I can understand having strong feelings about who can marry, and even belonging to a church, temple, mosque or other organization that does not condone or support gay marriage.
But why does this mean removing the right for a gay couple to marry within the state of California? To me this is imposing one's own beliefs upon everyone. There are orthodox rabbis who will only marry two Jews. Does this mean we should have an amendment that says that only two people of the same faith can marry?
My heart breaks at the thought that my Mom's marriage, and the marriage of my friends, will be invalidated by the state constitution, and that future couples will be denied the right to marry and enjoy the same rights and responsibilities the rest of us have.
So, if you're in California, please vote NO on Prop 8.
Whether you live in California or not, you can help in other ways, through donations or volunteering, at http://www.noonprop8.com/.
Friday, October 31, 2008
Don't expect anything more than what is listed in the "P2" section. The P3 section is an unordered list of other ideas, and if we have time, we'll pick some of them off. If there are specific things that you really want, please let me know. And of course, any other feedback you have is always much appreciated.
The two main themes are: add more SQL integration with the PHP editor, and improve our overall UI experience.
We also would like to produce a plugin for a visual E/R tool (what I am calling a Visual Database Explorer to distinguish it from a full E/R tool like MySQL Workbench). We want people to test drive it for a while with this release, and then we can refine it and potentially integrate it into NB proper in the next release.
I will admit I am hesitant with the Visual DB Explorer. I know many of you have asked for this, but my concern is that once you have something out there, then you'll want more. "Why can't I create a new table right there?" "You don't fully support feature X of the Y database". "Why can't I generate SQL from the E/R diagram?".
If we're not careful, we can spend all our time refining the E/R tool when, as I've said before, that's really not taking advantage of our core strengths as a DB tool inside NetBeans.
There are numerous E/R tools out there, including MySQL Workbench, and I don't think it makes sense to spend all our time replicating that. Look at what we are doing in the PHP editor - that's something that takes advantage of the fact that the db tooling is inside an IDE. That can add real value that a standalone DB tool can't.
That said, I know how nice it is to quickly pull up a visual representation of a database schema to help understand it. So we'll do that. But please don't expect us to build Erwin for NetBeans. And to be honest, I don't think that's what most of you want anyway.
Imagine building an app that that can run standalone just as easily on your laptop or on a cloud-based cluster.
Such a thing may be possible using AJAX and a CouchDB backing store running on the same machine as your browser or serving up the app and data from a server. No PHP or Ruby middle tier getting in the way.
CouchDB provides replication for free, so all of your data can be replicated to your server or to any other peer. It's the framework for true offline, peer-to-peer data sharing applications.
Oh, and did I mention it's logarithmically scalable? Very cool.
... one of the high points of the semester, if you’re a teacher of introductory macroeconomics, comes when you explain how individual virtue can be public vice, how attempts by consumers to do the right thing by saving more can leave everyone worse off. The point is that if consumers cut their spending, and nothing else takes the place of that spending, the economy will slide into a recession, reducing everyone’s income.
In fact, consumers’ income may actually fall more than their spending, so that their attempt to save more backfires — a possibility known as the paradox of thrift.
At this point, however, the instructor hastens to explain that virtue isn’t really vice: in practice, if consumers were to cut back, the Fed would respond by slashing interest rates ... So virtue is virtue after all, unless for some reason the Fed can’t offset the fall in consumer spending.
I’ll bet you can guess what’s coming next.
I guess it's time for me to go out and buy an iPhone 3G and a flatscreen HDTV...
Wednesday, October 29, 2008
Then you can do anything read-only with it that you would do with regular tables: filter with WHERE clause, subqueries, aggregation, join with other tables, etc. Pretty darn nice.
If you need high-performance lazy initializing of an instance field, use the double-check idiom with a volatile field. This idiom wasn't guaranteed to work until release 5.0, when the platform got a new memory model. The idiom is very fast but also complicated and delicate, so don't be tempted to modify it in any way. Just copy and paste -- normally not a good idea, but appropriate here...
Wednesday, October 22, 2008
First of all, MySQL Workbench really owns this space. Yes, I know, right now it only runs on Windows, but the next release will fix that. And, yes, I know it only works for MySQL, but the promise is that they will fix that too, albeit not right away.
Secondly, NetBeans DB tooling has a huge opportunity because we're part of the IDE. An E/R diagram tool doesn't really leverage that advantage. There are things we can do that will make your day-to-day experience of slogging code for database applications really nice. But we can't be doing that if we're spending all our time writing an E/R tool.
That said, we're looking very seriously at a simple read-only E/R plugin. First and foremost what people want is a way to understand the structure of their database and to communicate this to others. Being able to build a database design through visual tools is useful, but has a secondary order of demand.
Anyway, keep your eyes peeled to this space, all you E/R lovers.
He told Tom Brokaw that he was troubled by what other Republicans, not McCain, had said: “ ‘Well, you know that Mr. Obama is a Muslim.’ Well, the correct answer is, he is not a Muslim. He’s a Christian. He’s always been a Christian. But the really right answer is, what if he is? Is there something wrong with being a Muslim in this country? The answer’s no. That’s not America. Is something wrong with some 7-year-old Muslim-American kid believing that he or she could be president?”
The same thing has been bothering me for a while. How did the word "Muslim" become a dirty word? I am glad people in power are standing up against this.
The webinar is live, and you can ask questions via a chat-based interface. It's at 9:00 am San Francisco time, you can see what that is in your local time here.
The webinar is limited to 20 people, so it will be first come, first serve. Apologies about the small "classroom" size -- MySQL University just started using DimDim (this is actually the first session using it) and are still in testing mode.
Monday, October 20, 2008
Many of you -- many of you know that I got my name, Barack, from my father. What you may not know is Barack is actually Swahili for "That One."
But this weekend, I went on a road trip with my kids. I wanted to find ice cream, click click I found it using the Google Maps app on my iPhone. I got lost - click click and I could find out where I was. I wanted to find a bank. Easy peasy. Now, how to get back home? Click click, slick slick.
So the thought of giving this all up when I turned off my service on my iPhone was sad, but at $60 a month I decided I would just have to let it go. But then last night a light bulb went off in my head - why not switch my iPhone over to T-Mobile? I heard it was possible, and even legal, although it makes the Gods at Apple and AT&T angry.
So, Googling around, lots of info, lots of it seeming not very trustworthy, and then I found this tutorial for using Pwnage with the 2.1 version of the iPhone OS. I was encouraged that engadget seems to endorse this tool. I tried it, and, very nice, very nice indeed! I was expecting a lot of command-line garbage with poor documentation, and this was an unexpected surprise of usability.
If you're ever tempted to shop around, I recommend Pwnage. Of course, there are risks. There is FUD around your iPhone getting bricked. I'm still unclear what happens when Apple delivers a new version of the iPhone OS or iTunes that could mess things up. But so far it's worked like a charm. When I finished the steps in the tutorial above, I had a jailbroken and unlocked iPhone. I plugged in my T-Mobile SIM chip (here's how you do that), and I was good to go.
Now this is cool. I am paying $7.00 a month instead of $60 month, and I have everything I had before, except visual voice mail (ah well). And still one device instead of two. I am a happy camper.
Jailbroken, BTW, means you can install apps from Cythia, rather than just the iPhone app store. This seems to include apps which for some reason or another are not approved for the app store. I haven't tried that much, but that seems like a nice side benefit.
UPDATE: Doh! T-Mobile doesn't have a data service. So I do lose my data features like Google Maps when I'm not connected to WiFi. Sigh, oh well. But still, I like it that I can use my iPhone for phone calls and not have to carry around two devices and keep contacts synched between them. Anybody know of a GSM plan that's pay-as-you-go and has data services? I thought not...
Friday, October 17, 2008
A simple rule dictates my buying: Be fearful when others are greedy, and be greedy when others are fearful. And most certainly, fear is now widespread, gripping even seasoned investors. To be sure, investors are right to be wary of highly leveraged entities or businesses in weak competitive positions. But fears regarding the long-term prosperity of the nation’s many sound companies make no sense. These businesses will indeed suffer earnings hiccups, as they always have. But most major companies will be setting new profit records 5, 10 and 20 years from now.
Thursday, October 16, 2008
I just got my wife a pay-as-you-go plan from T-Mobile. No contract, can use any unlocked phone, and it's .10c a minute if you get a $100 card.
So let's say I talk on my phone on average 70 minutes a month, that's $7.00 a month. Hm, that sounds pretty good.
The only problem - the cancellation fee of $150 unless I wait until Feb of 2010. And I'll need to buy an unlocked phone, but you can get a nice Motorola V195 from T-Mobile for $30. At a savings of more than $50/month, that extra $180 will pay for itself in less than four months. So it's worth it to switch now, even with a cancellation fee.
But wait, can you actually do that - cancel your AT&T service and still have a working iPhone with WiFi, browser, email, contacts, apps (even location-sensitive apps), and music? Survey says, yes!
Wednesday, October 15, 2008
The more I listen to and read about "the most liberal member of the U.S. Senate", the more I like him. Barack Obama strikes a chord with me like no political figure since Ronald Reagan. To explain why, I need to explain why I am a conservative and what it means to me.
Monday, October 13, 2008
FS is the most amazing filesystem I’ve ever come across. Integrated volume management. Copy-on-write. Transactional. End-to-end data integrity. On-the-fly corruption detection and repair. Robust checksums. No RAID-5 write hole. Snapshots. Clones (writable snapshots). Dynamic striping. Open source software.
Thursday, October 09, 2008
This is a project by some Ph. D. students at UC Berkeley. They are using AI algorithms to find items (in this example shoes) that are "like" the one you picked. Notice how they've gathered shoes for sale across the web and displayed them in a single view.
Pretty nice! I suspect these guys are going to get slurped up by somebody! :)
I don't know, I think I like "we'll always have Paris" better... :)
But that said, I do have a 401k and a rollover IRA. I don't plan on retiring any time soon. So maybe there's a silver lining here.
I recently read a quote from Warren Buffett
Occasional outbreaks of those two super-contagious diseases, fear and greed, will forever occur in the investment community. The timing of these epidemics is equally unpredictable, both as to duration and degree. Therefore we never try to anticipate the arrival or departure of either. We simply attempt to be fearful when others are greedy and to be greedy only when others are fearful.
Maybe it's time to look for some bargains?
I haven't put it through serious paces, but a cursory look, from signing up to starting a meeting and enabling desktop sharing (available on Mac and Windows) were pleasing - it passes the "first fifteen minutes" test...
Easter egg: some fun profiles of the management team.
Tuesday, October 07, 2008
A week after the insurance giant, the American International Group, received an $85 billion federal bailout, executives at its life insurance subsidiary, AIG General, held a weeklong retreat at the exclusive St. Regis Resort in Monarch Beach, Calif. Expenses for the week, lawmakers were told, totaled $442,000, including $200,000 for hotel rooms, $150,000 for food and $23,000 in spa charges.
In addition, the former A.I.G. executive who led the London-based division whose implosion is largely blamed for the insurance giant’s downfall, Joseph J. Cassano, continues to receive $1 million a month from the company, on top of the $280 million he received in the last eight years.
And even after A.I.G. reported $5 billion in losses in the final quarter of 2007, its chief executive at the time, Martin Sullivan, argued before a compensation committee that executives should receive performance bonuses. He received $5 million.
Wow. It makes one's head spin...
We’re entering the age of cloud computing, remember? And clouds, it turns out, don’t like databases, at least not as they have traditionally been used.
This fact came out in my EmTech panel and all the experts onstage with me nodded sagely as my mind reeled. No database?