Timeline for Goodbye, Prettify. Hello highlight.js! Swapping out our Syntax Highlighter
Current License: CC BY-SA 4.0
19 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 23, 2020 at 21:05 | comment | added | Josh Goebel | SQL improvements finally landed in 10.5 for a holiday release! SE just updated to 10.4.1 so I'm not sure when the next update will be. CC @BenKelly | |
| Nov 2, 2020 at 23:13 | comment | added | William Robertson | I'd be happy to help out with Oracle SQL and PL/SQL, if Oracle Corp can't spare anyone :) | |
| Oct 17, 2020 at 18:22 | comment | added | Larnu | Thanks for the update @JoshGoebel, appreciate it. | |
| Oct 17, 2020 at 17:48 | comment | added | Josh Goebel | Sadly the SQL grammar improvements didn't make it into 10.3 because it turns out we're going with a complete rewrite of the SQL grammar. The new grammar should hopefully do much better overall on snippets but will drop vendor-specific (non-standard) things like MySQL comments. We could still use any contributors who might want to create (and help maintain) 3rd party modules for MySQL and Oracle to support the nuances of those vendor's SQL grammars. | |
| Oct 7, 2020 at 17:14 | comment | added | Josh Goebel | I will add variable support to SQL since that will prevent false keywords also. github.com/highlightjs/highlight.js/pull/2740/commits/… | |
| Oct 7, 2020 at 15:14 | comment | added | Larnu |
According to this answer from 2014, it does (did) not, @JoshGoebel . Though, not all of the languages use @. For example T-SQL (SQL Server), MySQL use @, where asPL\SQL (Oracle) and pgSQL (PostGreSQL) do not. SQLite doesn't actually support Variables at all; by the looks of it. I do admit that all the RDBMS using (vastly) varying implementations of SQL does pose many problem from the perspective of a generic "SQL" language implementation.
|
|
| Oct 7, 2020 at 15:08 | comment | added | Josh Goebel | Re:Comments. This is because there yet exists no "MySQL" SQL grammar so that support has been squeezed into SQL... MySQL does indeed allow # comments. What needs to happen here is for someone to creates a separate MySQL grammar and then the SQL grammar can be simplified (removing # comments). Does ANSI SQL even have variables? Variables would be something pretty trivial to add to the existing SQL support (since it currently includes too much). I'd be open to a PR against SQL adding variables. | |
| Oct 7, 2020 at 14:53 | comment | added | Larnu |
@JoshGoebel that doesn't explain most of the above. Yes the brackets ([]) are T-SQL specific, however, # is a very different story, as only -- and /*...*/ are the ANSI methods for comments. @ is also the common theme for variables. The majority of this is not T-SQL specific. The misinterpretation of # as a comment is especially detrimental in my opinion.
|
|
| Oct 7, 2020 at 14:50 | comment | added | Josh Goebel | Highlight.js "SQL" language is intended to be very "baseline". It's not going to handle every possible SQL variant well. Currently it includes too much (and on the list to be scaled back)... if someone wants "better/proper" MS SQL support then the correct solution is for someone to provide a 3rd party grammar module for MS SQL variant. Currently we already have PostgreSQL (core) and Transact-SQL (3rd party) grammars in addition to the plain jain "SQL". | |
| Sep 26, 2020 at 15:08 | history | edited | Larnu | CC BY-SA 4.0 |
added 476 characters in body
|
| Sep 26, 2020 at 15:01 | history | edited | Larnu | CC BY-SA 4.0 |
added 476 characters in body
|
| Sep 25, 2020 at 9:10 | history | edited | Larnu | CC BY-SA 4.0 |
added 560 characters in body
|
| Sep 24, 2020 at 21:47 | history | edited | Larnu | CC BY-SA 4.0 |
deleted 1 character in body
|
| Sep 24, 2020 at 19:47 | history | edited | Larnu | CC BY-SA 4.0 |
added 189 characters in body
|
| Sep 24, 2020 at 18:04 | history | edited | Larnu | CC BY-SA 4.0 |
edited body
|
| Sep 24, 2020 at 17:04 | history | undeleted | Larnu | ||
| Sep 24, 2020 at 17:04 | history | edited | Larnu | CC BY-SA 4.0 |
added 667 characters in body
|
| Sep 24, 2020 at 16:58 | history | deleted | Larnu | via Vote | |
| Sep 24, 2020 at 16:58 | history | answered | Larnu | CC BY-SA 4.0 |