Archives for February 2006

Oracle really spoils you with the ALL_DEPENDENCIES data dictionary view. If you want to know what depends on what, you just query it. These days, I’m working in Sybase again, so I had to figure out how to do it using Sybase’s data dictionary views. Hopefully you’re looking for the same thing and this will be useful to you:

SELECT o.id, o.name, o.type
FROM sysobjects AS o, sysobjects AS do, sysdepends AS d
WHERE do.name = 'procedureName'
AND d.depid = do.id
AND o.id = d.id

Just replace 'procedureName' with the name of the procedure you’re interested in.

Tags:
database,
sql,
oracle,
sybase

Back in October 2003, I signed up as an organizer for the Northern NJ MySQL Meetup Group. I mostly let the group sit idle, since I didn’t have much time to really promote it. Then, a year later, Steve G. contacted me and said he’d be interested in actually meeting up! Thanks to Steve, I scheduled the first meetup in March 2005 and even blogged about it. Four people attended that first meetup: Steven B., Steve G., Mike I. and myself. I was absolutely thrilled, it was a great success.

Almost a year later, we’re still meeting up every month. This past meetup, the February 2006 meetup, we had a whopping 11 people attend! This has been our largest meetup to date. I even posted a few photos from the meetup as proof. Steve G. gave his presentation on the “contact manager” project we started last meetup, this time using Smarty templates for PHP. He’s posted the code up on njgeeks.org, check out his blog entry where he links to the code. In attendance were: Glen B., Steven B., Jim D., Juan G., Steve G., Mike I., Doug M., Nancy S., Bill W., Kipp W. and myself.

At the meetups, we discuss all sorts of things, not just strictly limited to MySQL. We discuss whatever is of interest to the folks who attend, which has included MySQL, PHP, Debian and Ubuntu Linux, various web startups, Web 2.0, blogging, podcasting, RSS and syndication, social networking, writing books and so on. I’m even trying to get folks interested in AOLserver and Tcl, although it’s never easy to do. We’ve been meeting at the Panera Bread on Route 4 West in Paramus, NJ, the one that’s in the same mini-mall as the Daffy and Kohls, across the highway from the Bergen Mall and the Cittone Institute. We meet around 7:00 PM although I usually can’t make it there until 8:00 PM. There’s free wi-fi at the location, so bring your laptop if you’ve got one.

If you’re interested, I urge you to join our meetup then RSVP for the March 2006 meetup. If you’ve got questions, don’t hesitate to contact me, I’ll be glad to answer whatever questions you might have. Hopefully, we’ll see you at the next meetup! Come celebrate our first year anniversary meetup and see what we’re all about.

Tags:
meetup,
new jersey,
local,
event,
mysql,
open source

There’s a technique in Unix where you can pass a file descriptor (FD) from one process to another through Unix domain sockets on BSD or pipes on SysV. However, how do you do it on Win32? The “Unix emulation” that Windows provides, called Interix, says in its UNIX Application Migration Guide:

The two sockets functions recvmsg and sendmsg appear in many network applications but are not supported by Interix. These functions are the only way to pass an open file descriptor from one running process to another running process.

This doesn’t make it sound very promising. Can you really not pass FD’s between processes on Win32? In the hopes that someone else out there who knows Win32 much better than I do has already solved this, I’m asking for help. If you know of a way to pass FDs on Win32, please leave me a note in the comments or send me an email. Remember, I know how to do it on Unix already. I’m asking specifically for how to do it on Win32, if it’s even possible. Thanks.

Tags:
lazyweb,
win32,
coding