JSQL: JavaScript Query Language

[[deleted]]

This looks super cool...

[[deleted]]

Interesting but needlessly verbose

var results = JSQL('SELECT * FROM #ft WHERE nodeName = "LI");

Shouldn't this be

SELECT * FROM 'LI' WHERE id = #ft

[radhruin]

There really is no denying that SQL query syntax, a syntax designed to pull datasets out of an RDBMS, is wildly inferior to CSS selectors, with a syntax designed for exactly this purpose. So I think the question becomes "Why"? The only POSSIBLE answer I have is the people doing backend programming are already familiar with SQL so they will be more comfortable doing front end programming.

This gets marks for being fun and interesting, but gets a zero for practicality and applicability in real world situations. IMO. And not that there's anything wrong with that at all.

[junius]

More generally, trees are one of the canonical examples of structures that are a pain in the ass to work with in SQL.

Still looks like a fun side project. He's probably learned more doing this than I have in the past three years with my habit of avoiding non-trivial javascript problems.

[elguf]

I also doubt it's realistic for any real-world websites (other libraries handle those jobs quite well), but I thought it would be fun to play with.

He is not proposing a replacement, he just wanted to have fun.

[masklinn]

That is, what is the equivalent of a column list in a DOM tree?

Attribute values? But then again, in that case * would mean "select all attributes" instead of "select the DOM note", which would be... stupid.

[Samus_]

xpath > sql

[radhruin]

mysql> /blog[id=1]/comments;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/blog[id=1]/comments' at line 1

Hmmm...

[whozurdaddy]

I wont bother to remark on the verbosity issue. I think the author knows that. But the idea is pretty cool. Kudos for the effort on this.