Today's Question:  What does your personal desk look like?        GIVE A SHOUT

SEARCH KEYWORD -- Join

  An example of SQL outer join

SELECT MEMBER.Name, MEMBER.Address, ORGANIZER.phoneNo, TRAVEL.Tour_Name, TRAVEL.Start_Date, TRAVEL.End_Date FROM TRAVEL RIGHT JOIN ((MEMBER LEFT JOIN ORGANIZER ON MEMBER.Member_ID=ORGANIZER.memberID) LEFT JOIN PARTICIPATION ON MEMBER.Member_ID=PARTICIPATION.MemberID) ON TRAVEL.TravelID=PARTICIPATION.TravelID;...

   Access,SQL,Outer join     2011-03-20 09:08:11

  LEFT OUTER JOIN with ON condition or WHERE condition?

The difference is subtle, but it is a big difference. The ON condition stipulates which rows will be returned in the join, while the WHERE condition acts as a filter on the rows that actually were returned.Simple example: Consider a student table, consisting of one row per student, with student id and student name. In a second table, a list of grades that students have received, with student_id, subject, and grade. Give me a list of all students, and show their grade in Math. This requires a LEF...

   SQL,Outer jo0in,On,Where,On vs where,where vs on     2011-11-01 02:04:29

  Manipulating JavaScript Arrays

Our first tutorial on JavaScript arrays covered the basics: creating arrays, accessing the contents of arrays, array lengths, and looping through arrays. In this tutorial, you explore arrays in more depth, and learn how to use various methods of the Array object to manipulate arrays. Extracting sections of an array with slice() You're not limited to accessing single array elements at a time. Thanks to the slice() method, you can grab a whole section of an array at once. slice() has the follow...

   JavaScript,Array,Manipulate,Join,Splice     2011-08-07 01:56:06

  Fuzzy search algorithm in Sublime Text

Fuzzy string searching is the technique of finding strings that match a pattern approximately (rather than exactly. In many editors, we can easily find the Find menu item to do exact matching. While in Sublime Text and some other editors, we can use fuzzy string searching as well if we just want to have an approximate match. There is some algorithm implemented in Sublime Text to implement achieve this. First the search query is split into characters, join them with a regex wildcard, and then run...

   Sublime Text,Fuzzy search     2013-10-14 22:49:38

  Why using + to concatenate string in Java loop is not a good option

String concatenation is a common operation in Java programming. It is to concatenate multiple strings into a single string. Java provides a String class which is an immutable class which means the object cannot be mutated once instantiated. Once a String object is instantiated, its properties cannot be changed anymore, so when concatenating strings, it's actually create a new String instance to store the concatenated string values. For example, below is a simple string concatenation example. Str...

   JAVA,STRING,JAVA 8     2019-01-18 22:07:12

  Is Facebook developing RSS reader?

According to Sina Tech, on Thursday developer Tom Waddington said that he found some strings like "RSS feeds" in Facebook codes, it means that Facebook may launch its own RSS reader.Google announced in March this year that they would close its RSS subscription service Google Reader on July 1 mainly because its use had constantly declined in the past few years. Subsequently, many companies competing to launch Google Reader alternatives. Waddington believes that this time Facebook will also join t...

   Facebook,RSS reader     2013-06-14 12:41:11

  Nokia fires the Qt team

Recently, Nokia announced that they would lay off around 10000 employees, 700 of them are developers. Among these 700 developers, 100 are the core developers of the open source project Qt.Nokia is the main sponsor of the open source project Qt. According to Mirko Boehm, the core Qt team has around 100 people, this means that Nokia fires the whole Qt team.He criticized Nokia's decision, he thought that a responsible CEO should persuade the team to move to other platforms.Qt team is experienced, t...

   Nokia,Fire,Qt     2012-06-26 06:57:06

  Python threads: communication and stopping

A very common doubt developers new to Python have is how to use its threads correctly. Specifically, a large amount of questions on StackOverflow show that people struggle most with two aspects: How to stop / kill a threadHow to safely pass data to a thread and back I already have a blog post touching on these issues right here, but I feel it’s too task-specific for sockets, and a more basic and general post would be appropriate. I assume the reader has a basic familiarity with Pytho...

   Python,Multithreading,Communication,Synchronize     2011-12-28 07:38:32

  Can Your Programming Language Do This?

One day, you're browsing through your code, and you notice two big blocks that look almost exactly the same. In fact, they're exactly the same, except that one block refers to "Spaghetti" and one block refers to "Chocolate Moose." // A trivial example: alert("I'd like some Spaghetti!"); alert("I'd like some Chocolate Moose!"); These examples happen to be in JavaScript, but even if you don't know JavaScript, you should be able to follow along. The repeated code looks wrong, ...

   Programming,Maintainability,Reusable     2011-05-31 07:42:41

  5 Reasons to Join a Startup After Graduating

After I wrote my last post, a surprising number of people emailed me asking why I decided to join a startup after graduating from Duke. Many of those I heard from face similar decisions today: either they are college seniors choosing between a big company and a startup, or they are recent graduates who work at a big company and are thinking about making the switch. What’s interesting is that most are already leaning towards the startup career path: it seems they just want someone to ...

   Startup,Graduation,Work,Advice,Passion,Learn     2011-11-23 08:12:13

RECENT