Instantly expose a table as a REST endpoint – again.
Introduction
A while back I wrote a component for exposing FireDAC tables as REST endpoints in Delphi. I wasn’t entirely happy with the component that I’d written, however, it was really intended as a proof of concept. I was quite surprised to learn that people were actually making use of that component, rather than simply using it as an example of what could be done.
Fast-Forward a couple of years, and I found myself needing precisely that component in another project. I wasn’t going to make use of my proof-of-concept code, knowing it to have some flaws, and so I decided to have a do-over. Today, I’d like to introduce you to the deREST components: https://github.com/chapmanworld/deRest
deREST
The deREST components are my replacement for the older component which was named JCRUD.
As with the original component, I still maintain my disclaimer: “I will not be held responsible for any damages that occur due to the use or misuse of this component.”, however, unlike the original component I do intend to maintain deREST going forwards.
In the video below, I explain more about the component set, my intentions regarding maintenance, and how to make use of it. I also give a few hints as to my intended road-map for deREST.
(Apologies for the video being a little choppy in places, just where I edit out some gafs…)
deREST is licensed MIT https://github.com/chapmanworld/deRest/blob/master/LICENSE
Conclusion
I hope these components are useful to you.
Feel free to get in touch with suggestions for improvement!
Thanks for Reading / Watching!
Dear Chapman…Is this support for Delphi 10.3 Rio?
Honestly, I’ve not tested it in Rio yet, but it should work just fine.
Craig – as ever you take REST development forward in leaps and bounds. Im going to share this in the UK dev group. Perhaps Jason can get you along to a meeting to talk to us troops . Cheers and thanks. Pete
I am running tests and realized that the result is normally presented in the browser, however, in RESTDEBUGGER and DELHI does not return error and neither brings results and some tables that I am testing, I use FIREBIRD.
in deREST.api alter line 1158 from Response.ContentType := ‘application\json”‘; to Response.ContentType := ‘application\json; charset=”UTF-8″‘; and line 1164 from Response.ContentType := ‘text\plain”‘; to Response.ContentType := ‘text\plain; charset=”UTF-8″‘;
Thanks for the edits – I’ll make and test the changes.
I’ll raise a GitHub issue to track the changes shortly.