±Forensic Focus Partners

Become an advertising partner

±Your Account


Username
Password

Forgotten password/username?

Site Members:

New Today: 0 Overall: 35667
New Yesterday: 6 Visitors: 128

±Follow Forensic Focus

Forensic Focus Facebook PageForensic Focus on TwitterForensic Focus LinkedIn GroupForensic Focus YouTube Channel

RSS feeds: News Forums Articles

±Latest Articles

±Latest Webinars

Article re SQL joins

Computer forensics discussion. Please ensure that your post is not better suited to one of the forums below (if it is, please post it there instead!)
Reply to topicReply to topic Printer Friendly Page
Forum FAQSearchView unanswered posts
 
  

PaulSanderson
Senior Member
 

Article re SQL joins

Post Posted: Nov 11, 14 19:03

Afternoon all

I have recently uploaded an article/bog to my web site re different
SQL joins (or more specifically SQLite joins). While this article uses
The Forensic Browser for SQLite as the query engine, the concepts
discussed are relevant (and mainly discuss hash matching) for anyone
who has large tables of data that they want to filter/compare. The SQL
can of course be used in any SQL query engine.

sandersonforensics.com...-SQL-Joins

Cheers

Paul
_________________
Paul Sanderson
SQLite Forensics Book
www.amazon.com/SQLite-...entries*=0

Forensic Toolkit for SQLite
sandersonforensics.com...for-SQLite 
 
  

Chris_Ed
Senior Member
 

Re: Article re SQL joins

Post Posted: Nov 12, 14 14:47

Detailed, and informative. Thank you for taking the time to do it!  
 
  

AlexC
Senior Member
 

Re: Article re SQL joins

Post Posted: Nov 12, 14 16:25

Great article Paul. I recently had to write a query simulating a 3 table FULL OUTER JOIN in SQLite. It got...lengthy... but luckily, in that case, the results were very compelling, so it was all worth it.

Thanks for sharing.  
 
  

PaulSanderson
Senior Member
 

Re: Article re SQL joins

Post Posted: Nov 12, 14 18:45

Thanks both

Doing lots of work with the Browser at the moment and a side effect of that is lots of work on SQL queries as I help customers (not that most need it as the visual query design makes most queries and joins easy).

I have another article up my sleeve that shows off some of the power of SQL (I think I mentioned it to you at the conference Alex). It's abit more complex so i am working through it trying to simplify as much as I can.
_________________
Paul Sanderson
SQLite Forensics Book
www.amazon.com/SQLite-...entries*=0

Forensic Toolkit for SQLite
sandersonforensics.com...for-SQLite 
 

Page 1 of 1