Online Collaboration Tools for SQL, HTML/CSS/JS and RegEx

More and more, I see my business moving away from Access an toward the cloud. That is simply the reality of the world we live in. People want their data accessible on any and every device and Access simply does not offer that natively.

As such, in the past few years I have been immersing myself in HTML, CSS, JS, PHP, MySQL, SQL Server and Azure, …

Sometimes, it can be very convenient to be able to demonstrate coding to fellow developers, to get help (forum postings), to collaborate, … or even just to quickly test out a concept rather than needing to setup your development environment you can use one of these tools.

Today, I thought I’d share a few online tools that enable such collaboration

Do note, in all cases, I have no affiliation with any of the listed sites.  Be sure to check out their terms of use and other policies prior to use.

HTML/CSS/JS

https://jsfiddle.net/
https://codepen.io/pen/
https://codesandbox.io
https://html-css-js.com/
https://jsbin.com/

HTML Code Formatter/Beautifier

Another tool that can be very useful is one that can take a raw SQL Statement and format it nicely to make it more legible:
https://webformatter.com/html
https://jsonformatter.org/html-formatter

HTML Encoders

https://mothereff.in/html-entities
https://www.w3docs.com/tools/html-encoder/

Databases

https://dbfiddle.uk/
http://sqlfiddle.com/
https://www.db-fiddle.com/

SQL Statement Formatter

Similarly to HTML formatting it can be very useful to have a tool that can take a raw SQL Statement and format it nicely to make it more legible.  Here are a couple:
https://sqlformat.org/
https://sql-format.com/
https://codebeautify.org/sqlformatter

Excel

The following link is truly useful to convert Excel data into HTML tables or Divs without all the extra HTML that MS or WordPress add when converting/importing.
https://tableconvert.com/excel-to-html

Regular Expressions (RegEx)

https://regexr.com/
https://regex101.com/
https://extendsclass.com/regex-tester.html

These are just a few of the tools available online.  If you want to share others, simply drop me a message through the contact form.

4 responses on “Online Collaboration Tools for SQL, HTML/CSS/JS and RegEx