Thursday, April 27, 2017

Theory of Time Travel using Quantum Mechanics is plausible

This post's video will disprove the following popular cultural beliefs;

  1. The "Grandfather Paradox" was described as early as 1931, and even then it was described as "the age-old argument of preventing your birth by killing your grandparents".[5] Early science fiction stories dealing with the paradox are the short story Ancestral Voices by Nathaniel Schachner, published in 1933, and the 1943 book by René Barjavel Future Times Three.
  2. The "butterfly effect" coined by Edward Norton Lorenz (1972), but first alluded to in the Ray Bradbury's 1952 short story "A Sound of Thunder". Ray Bradbury's concept of how the death of a butterfly in the past could have drastic changes in the future is a representation of the butterfly effect, and used as an example of how to consider chaos theory and the physics of time travel.
  3. The so called "Mandella effect" popularized in 2010. The Mandela Effect refers to a phenomenon in which a large number of people share false memories of past events, referred to as confabulation in psychiatry and currently disproved.

    Some have speculated that the memories are caused by parallel universes spilling into our own (thereby rewriting our past and present memories) this will proven impossible. 

There are very times I would use the label genius, but it applies to Dr. Seth Lloyd and he's break boundaries of space. For the uninitiated, Dr. Seth Lloyd, a MIT professor, quantum experimentalist (his words) and is the lead voice in quantum mechanics and who dubbed the term "Quantum Hanky-Panky" and published hit PHD Thesis April 1, 1988, proving humor, fun and math go hand-in-hand.

He describes the quantum mechanics of time travel during a guest lecture at the Institute for Quantum 
Computing, University of Waterloo. Recorded on Nov. 4, 2010 (how did I miss this?), this is the entire lecture entitled "Sending a Photon Backwards in Time."


Time travel is explained near the end of the lecture at time 59:40 (https://youtu.be/yCQ_3qE6SmQ?t=3580)

Summary

Watch the whole thing to understand it, but at a minimum a qubit is is a two-state quantum-mechanical system, such as the polarization of a single photon. 

According to Dr. Seth Lloyd; 


  1. qubits can travel back in time
  2. a qubit state in a past cannot be change to alter the state of the same qubit in the future

Are qubits timeless then? (my 4 cents). Has Seth just broken timespace in half? There has been some theories suggesting that we spacetime is broken, and you can replace completely rewrite gravity as an Entropic Force

Seth's alludes that he has mathematically proven and  has the experimental evidence the above holds true.

So you cannot go in the past and change things in the future. So self consistency applies in the universal spacetime fabric.


Seth proves you cannot kill yourself in the past and change a potential future outcome and worlds. 

Countless plot lines and sci-fi adventures like Back to the FutureContinuum, have been proven not feasible. The sci-fi world is going to collapse into itself in an apocalyptic idea black-hole singularity:)  


So this disproves 1, 2, 3 above. Sorry folks.


 

Wednesday, April 26, 2017

The best, top rated, fastest, open source (free) Windows grep tool with a GUI

This post quickly reviews and recommend the best Windows Grep tools with a Graphical User Interface (GUI).  

A little backgrounder, grep originated from unix and now has linux and windows equivalents. It's a  command-line utility for searching within files for lines that match a text search or regular expression. Command-lines are difficult for the novice user to master hence the the need for a Graphical User Interface (GUI)


This is an current popular list of current  Windows Grep tools with a Graphical User Interface (GUI) with issues I found; 

  1. PowerGREP (paid $159 USD)
  2. Windows Grep (dead)
  3. Bare Grep (not open source, last update 2006, free unlimited trial, licensed is $25 USD)
  4. AstroGrep (open source, C# code base but super slow, tested personally)
  5. dnGrep (open source, C# code base but slow complaints by users)


The winner grepwin, an active open source initiative, last release 2017-04-08.

grepwin  "A powerful and fast search tool using regular expressions"


No. 1 for the following reasons; 

  1. Speed, this project is coded in C and is super speedy
  2. Open source and free, freely to inspect for malware and spyware, none so far
  3. Flexibility, you can combine search for file names and/or search for content separately!




Tuesday, April 25, 2017

mySQL Workbench vs SQL Server Management Studio (SMSS) SQL Formatting Beautify SQL Code

This post will examine SQL Server Management Studio vs mySQL Workbench SQL Formatting or "Beautify SQL Code"

Beautification or SQL Formatting basically will syntactically colorize and format SQL to be multi-line so it is human readable.

There are a plethora of sites (see chart at bottom) online to beautify but only a few sites that work when you SQL is syntactically incorrect.

The true test of you beautifier is whether or not it can parse SQL that is broken, incomplete or has an systax error. Many online SQL Formatting sites and tools will fail.

There is original and best is Poor Man's T-SQL Formatter (org. Oct 2013) and a upstart https://sqlformat.org/ is also good (it's interface is just slightly slicker).

Let's take this sample incorrect SQL statement that is missing the s in select


1
elect p.shipid,   p.shipname,   c.desc ContactShipCOM,   a.desc SpacialCoordiantes from profile p left join contact c   on p.id = c.profileid   and c.ord = 1 left join address a   on p.id = a.profileid   and a.ord = 1 where p.shipid = 'Rocinante' and c.show='The Expanse'

Paste into https://sqlformat.org/ a SQL Formatting engine that works on incorrect SQL

Not exactly as shown, but very close.



SQL Server Management Studio (SSMS)

SQL Server 2016 Management Studio (SSMS) is a free download, get it here.

There is no built-in SQL Formatting for SSMS, but because of Microsoft's architecture to make it's tools extensible the community stepped-up and made a tool to fit this need. Poor Man's T-SQL Formatter has a 
SQL Server Management Studio (SSMS) and Visual Studio Add-in for many years now. The installer is same for both, but it will give you an option for the Visual Studio add-in during the install wizard steps.


incorrect SQL Statement, still formatted 

















MySQL Workbench 

The latest MySQL Workbench 6.3 Community does have a built-in SQL Formatter but it does not work when the SQL is incorrect. Sadly, I have made a request for a fix for this in 2014, and still nothing has been done. Even though this is "open source" doesn't mean you get your request through the request queue and there is not other way to extend this product unlike SSMS. 


incorrect SQL Statement, NOT formatted 












So for the best SQL Editor and Formatter, I declare 
SQL Server Management Studio (SSMS) - Winner!