I knew for SQL I wanted to highlight the followingīy the time I had written out every object I wanted to highlight out of the AWS spec it was a very very long list, about 300 things. Having different highlighted zones allows your eyes to snap to the bits of the code you are looking for. Good syntax highlighting makes functions different colors from variables. You could do that but I could also call all my variables VAR, it gets the job done but it's hardly efficient. So syntax highlighting isn’t just a highlight everything that's not freetext. Lesson 2: It wasn’t as free form as I thought it was. So I had to take option one and Dev something myself. I felt like I was trying to find a case for my Motorola phone when all I can find are Samsung and Apple cases. So this was mental breakdown number one, everyone on git-hub had taken the easy way out because the languages they supported where mainstream enough to have an easy to grab language pack. Could I alter an existing one? Not that I could figure out. Could I find a language pack for Redshift? Nope. No dev work what so ever.Įvery single extension I looked at uses the TextMate Language pack method. Method Two simply requires you to download a TextMate Language pack and then nothing else. This is what the VSCode documentation tells you. Method One requires you to declare what you are highlighting in a JSON package using REGEX expressions. There are 2 ways to do syntax highlighting. I 100% thought I could take the Oracle Extension and rip out the bits I needed and would be done in time for dinner. So I totally thought I could git-bash my way to success here. Lesson One: No one built something I could steal. ![]() Here are the lessons I learned along the way. (And I would just use the internal global snippets file) So seeming all I need is SQL syntax highlighting and a snippet library I thought I'd give it a shot at making my own syntax highlighter extension and I can ditch bloaty-mcbloat face. The extension also does like 60 different things and I only use it for 2. ![]() However the Oracle Extension I've been using this whole time has been getting bigger and buggier over time. Redshift is very similar to PostgreSQL and Oracle and so I've been getting by using Oracle based extensions. Now this hasn't been an overly big problem for me. Well that's a slight lie, there is one, but that's also a lie, its just tagged as Redshift because SEO. When I search for Redshift on the VS Code Extension Store there is nothing!!!! So suffice to say finding Redshift SPECIFIC technology is pretty hard to find on the interwebs. I'm a data analyst in an AWS Redshift SQL environment.įor context, the environments that analysts out in the field tend to use, in order of popularity are:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |