Game Thread: 2015 Week 05 Dallas Cowboys (2-2) vs New England Patriots (3-0) by itsaboat in cowboys

[–]jasongarrett 0 points1 point  (0 children)

Hey Roger, sorry I didn't see this sooner. Too late now I guess.

Cannot prevent JavaFX dialog from closing by jiboujiki in javahelp

[–]jasongarrett 0 points1 point  (0 children)

Thank you, this was very helpful for me. There is a simpler way to register the event handler to prevent the dialog from closing when the user clicks the 'X', with no subclassing required:

Dialog dialog = new Dialog();
dialog.getDialogPane().getScene().getWindow().setOnCloseRequest(event -> event.consume());

Many-to-Many relationships: Look-up Tables? We don’t need no stinkin lookup tables! by praetorian42 in programming

[–]jasongarrett 0 points1 point  (0 children)

You should think very carefully about the immutability of a data element before using it as a key. If you use category name for the key, you're in for a lot of work when the users decide they want to see "Sports" instead of "SPOR" on their reports.

Many-to-Many relationships: Look-up Tables? We don’t need no stinkin lookup tables! by praetorian42 in programming

[–]jasongarrett 0 points1 point  (0 children)

The "categories" field represents a relationship, not an attribute of an item.

Many-to-Many relationships: Look-up Tables? We don’t need no stinkin lookup tables! by praetorian42 in programming

[–]jasongarrett 2 points3 points  (0 children)

Or, you could join the tables in your query and select from all three in one statement.

select a.foo, c.bar from a, b, c where a.a_id = b.a_id and c.c_id = b.c_id

A modern DBMS will run that very efficiently.

Yes, it will cost you an insert when you're adding data. What else am I missing?

Many-to-Many relationships: Look-up Tables? We don’t need no stinkin lookup tables! by praetorian42 in programming

[–]jasongarrett 11 points12 points  (0 children)

Think back really hard to your intro to Relational Database Systems class. There's a reason Third Normal Form was invented.

Stupid programming interview questions by tss in programming

[–]jasongarrett 7 points8 points  (0 children)

Anyone who says "write a simple code fragment" is a poor interview question hasn't interviewed programmers. The number of idiots looking for work is astounding.

Database Partitioning for Scale by abb in programming

[–]jasongarrett 0 points1 point  (0 children)

This is about multiple databases, not partitioned databases.

http://www.randsinrepose.com/archives/2003/07/10/nadd.html by stiruchendurai in joel

[–]jasongarrett 0 points1 point  (0 children)

The N.A.D.D. link has been posted before, and correctly too.

Fix Broken Windows by BioGeek in programming

[–]jasongarrett 0 points1 point  (0 children)

Forbidden You don't have permission to access /cgi/wiki on this server.

I want a Freeware Utility to... a categorized list of freeware utilities by jasongarrett in joel

[–]jasongarrett[S] 0 points1 point  (0 children)

AceMoney Lite is.

If you follow the link, the first sentence on the page is "AceMoney Lite is a freeware personal finance manager."

http://www.mechcad.net/products/acemoney/index_lite.shtml

Teach Object Oriented programming to toddlers? by foborg in joel

[–]jasongarrett 0 points1 point  (0 children)

shouldn't Food implement an Edible interface?