USB Drive sounds (Linux Mint 10)

[BC_Programmer]

Is it running a website?

technically, Yes, but it's not internet exposed at the moment. Normally, I have home.bc-programming.com redirect to it, but I'm not using my router (so there is no "Virtual Server" configured) and I'm at a different IP address  than usual so it just times out (since there's nothing there). Mostly it's just for quick testing of PHP and server side stuff; much easier to edit a file in var/www than have to download it, edit it, and then upload it back to my web host, then test it.

More specifically at the moment, I'm using the MySQL server to test and debug my "JobClock" Application for a Vehicle Repair Shop in Iowa. it holds the database server; my .NET application connects to it and issues queries and all that etc. Of course in-site they have their own MySQL server, but since their server is separate from where the applications run I like to try to keep my environment as close to that as possible (thus using a separate machine for the DB Server).

[Veltas]

the Apache/MySQL/PHP stack  is a lot easier to install & administer via on Linux

I know what you mean!

[Rob Pomeroy]

much easier to edit a file in var/www than have to download it, edit it, and then upload it back to my web host, then test it.

It took me a while to come up with a development setup that was convenient and quick and which worked no matter where my laptop was, but this is how I've cracked this nut:

• web development server (LAMP) is at home
• my main development domain is registered and the DNS hosted is by one of the usual suspects
• at home I am also running a local DNS server (BIND), which has its own zone files for my development domain
• my IDE of choice is NetBeans; all changes are immediately uploaded to the development server via SFTP - firewall friendly

When I'm at home, my laptop uses the local DNS server (which forwards queries for domains it doesn't know about, in the usual way).  So file uploads and browsing happen over the LAN.  When I'm out and about, it gets the external DNS host.  (This is the most foolproof method of overcoming the problem of hairpin NAT - going out of your router and back in again when using an external IP address.)

The only hassle here is that when I make a change at my domain host, I have to remember to make a similar change at home.  But with judicious use of wildcards, I don't have to touch DNS records that often.

You might recall, BC that I had an issue with NetBeans caching DNS entries - that was the final wrinkle to iron out.  It all now works gloriously (thanks).

[BC_Programmer]

For me, normally, I use EditpadPro's FTP panel to rather seamlessly edit PHP/HTML/whatever files on my webhost, which worked well. Only reason I have to use FTP now is purely convenience; I'm using a cat-5 cable directly between my desktop and laptop to test the aforementioned program, and so I can't actually use that cat cable to connect my desktop to the internet. I could, of course, just use my LAN for the connection, but when I was first setting it up it seemed to have issues with DNS names on the LAN (Satellite refused to resolve to the laptop) so I plugged in the cat5 to test it and since it worked I just haven't bothered to change it. (another plus, with internet only available on my laptop, there are fewer distractions )

Also, I tend to not use IDE's for most dynamic languages. (Python, PHP, etc) there just isn't enough context in the language for any useful "intellisense" type functionality that I would like, by virtue of them being dynamic. (Also, Editpad Pro- and gedit's- syntax highlighting is usually enough for me). I also avoid frameworks, because they tend to simply introduce complications rather than resolve them (in my experience); Not that they are bad, of course- just that, this way, if something doesn't work, I know it's my fault, and I don't have to go hunting through my code only to discover that it was in fact an obscure issue in a framework I was using. Those are rare but it's happened before to me and, well, once-bitten twice shy.

And now I have the unenviable (but perhaps inevitable) task of fixing a bug that occurs at the client site (apparently elapsed times are jumping somewhat erratically, from say 1:40 to 2:00 and 2:59 rolling over to 2:00) which I can't for the life of me reproduce locally. But it definitely exists and it's driving me freaking nuts. (And apparently my client entry application crashes during these discrepancies as well). I'm crossing my fingers that the one instance where I used the Local system time (DateTime.Now) when I was supposed to use the time on the database server could somehow be the cause of all those issues... though since my laptop and desktop aren't in sync time-wise I would have expected to see the symptoms myself... That, and I'm completely rewriting the code  that goes through the database records to calculate the elapsed times for orders and users.

TL;DR
databases are a pain

[Rob Pomeroy]

TL;DR
databases are a pain

Ha.  I've been using CodeIgniter for ages and I must say it did wonders for my programming practice (viz. it made me much tidier, more disciplined, wrote less code to do more, etc.).  I'm now learning CakePHP, which has great strengths of its own - integrated ORM for example.  I have absolutely no interest in writing my own DB mappers.

Again, because I'm lazy, I've used 960.gs for layout on several websites and now I'm playing with Twitter's Bootstrap.  Both have helped me make prettier websites, more quickly.  I guess I'm just too lazy to come up with these elements all on my own - plus I am extremely confident that I would make many mistakes and spend hours just having to debug my own support code.  No ta! 

[kpac]

I guess I'm just too lazy to come up with these elements all on my own

Using code that is already publically and freely available for use doesn't make you lazy, it makes you efficient. Or so my lecturer says.

[BC_Programmer]

Using code that is already publically and freely available for use doesn't make you lazy, it makes you efficient. Or so my lecturer says.

No. it's lazy. But that's good. As Larry Wall notes, Sloth is one of the hallmarks of a good programmer.

[kpac]

No. it's lazy. But that's good. As Larry Wall notes, Sloth is one of the hallmarks of a good programmer.

No, it's not. No need to re-invent the wheel when it comes to programming.

[BC_Programmer]

No, it's not. No need to re-invent the wheel when it comes to programming.

Laziness:A natural disposition that results in being economic (at least that would be the definition used with regards to the quote)

How that doesn't cover exactly what you are saying I haven't a clue.

With regards to "re-inventing the wheel".

sometimes you need a different kind of wheel. You can't put a wagon wheel on a Dump Truck. If nobody ever "reinvented the wheel" programming-wise, we'd all still be using punch-cards and FORTRAN. Things can't be improved much without being rethought and reinvented.

Sometimes, you should stop killing your imagination by always using things others have done. And, most importantly, if nobody re-invented the wheel, we wouldn't have frameworks to use in the first place.
 
"re-inventing the wheel" is an often quoted passage, as you've demonstrated. But as a rule of thumb it has exceptions.

-If you want to learn more about the wheel
-If the existing wheels don't fit your "vehicle" (to follow the analogy)
-if the existing wheel(s) sucks

It's fine to re-invent the wheel. Just know why you are doing it.

[kpac]

Yes, I agree with everything you've said. But for the majority of things you're going to be doing programming-wise, there is code out there which can make things a lot easier.

jQuery is an example. No point in writing a whole piece of Javascript just to make something fade in and out when jQuery or one of its plugins can do it. But I see what you're saying.

[BC_Programmer]

HAHA! so I figured out what was causing the bug.

The bug in the program was that times would have mysterious effects.

after 30 minutes, for example, it would say 1 hour 30 minutes; then at 1:59, it would roll over to 1 hour. and so forth.

this was the cause:

Code: [Select]

String FormatTimeSpan(TimeSpan formatthis)
{
    return String.Format("{0:00}:{1:00}",formatthis.TotalHours,formatthis.Minutes);
}
A short translation: basically, this will give the result of the TimeSpan's TotalHours field and Minutes fields, separated by a colon. And it worked perfectly, actually.

So what was the bug? Well, I thought the TotalHours field was a integer; or, rather, that it would return 0 until the first hour passed, then roll over to 1. Turns out it is a float, and therefore the minute portion was included as a fraction. This resulted in the value being rounded for the format string; so once the minutes passed 30 (.5) it would round up; resulting in all sorts of ridiculousness.

Face-palm worthy, really. All the complicated stuff to look through the various databases, calculate the appropriate date-ranges and cull the right overlaps and so forth works perfectly fine, and then this single line goes and simply formats the otherwise correct value wrongly.

of course my fix was to simply Floor() the TotalHours field. And suddenly all the "calculation issues" went away. VICTORY.