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.
Another regex tester: https://extendsclass.com/regex-tester.html
Thank you for sharing, that link looks very good and also the site in general seems to offer several useful tools!
Curious, what php frameworks do you use?
I’ve used a couple, but my primary development is currently done using Yii2, looking forward to Yii3’s release.