Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 18, 2020 11:25 AM
Ok so I know that this would be fairly complex, and may not be possible, but if it is, how would I go about making a login system using Airtable. I am trying to see if I can use Airtable as the backend database to something, and I’d like to try and refrain from using an SQL database, if possible. Of course, if completely necessary, I am completely comfortable doing so.
Any help is appreciated.
Apr 18, 2020 02:04 PM
Try reading the web article that I linked to. It will give you a lot of background info and things to think about. Plus it includes links to the actual code.
Apr 18, 2020 02:05 PM
Only trouble is, is that I am using PHP, not JavaScript. I decided it’s safer not to use the JS API, I have absolutely no clue how to use JavaScript.
Apr 18, 2020 02:06 PM
The article is still a good place to start.
I wrote my code in PHP. I only used JavaScript in the client.
Apr 18, 2020 02:06 PM
Fair enough. So far, I’ve sort of written my own API, for my needs.
Apr 18, 2020 02:20 PM
Why do you think the JS API isn’t safe?
If you want to write a web app with any client side interactivity, you’re going to have to learn JavaScript. If you want to use the Airtable Scripting Block, you’re also going to need JavaScript.
If you already know PHP, learning JavaScript is easy. (But I don’t recommend trying to learn both languages at the same time.)
Apr 18, 2020 02:21 PM
No, as in, I decided to ‘play it safe’. I didn’t mean that it is not secure.
Apr 18, 2020 03:05 PM
Just to be clear - “Bill’s” three steps represent the broader psuedo-process of a login page, not a portal, and certainly not trivial. In fact, I recommended it not be the recommended approach so the implication I made was don’t do it. :winking_face:
Apr 18, 2020 03:12 PM
Yep - that works. Just be clear that if a user struggles to remember a password, this multiplies the request-responses needed to get someone logged in. This is typically not a big issue unless you have dozens of people logging in at about the same time and if so, you’ll likely have to consider the rate limiting on the Airtable API. The first approach tends to avoid this.
This is one of the tradeoffs in web app development - do you make a single aggregate call to set the stage for unanticipated follow-on data needs in the client? Or, do you use multiple HTTP POST sessions for each process? I tend to tilt toward caching data forward to meet the next likely data need.
Apr 18, 2020 04:07 PM
Airtable as a back end for a user portal definitely has scalability issues.
However, for small projects and initial proof-of-concept designs, it can work very well. The ease in viewing and editing the data make it much easier to start with versus an SQL database that does’t have a pretty front end.
Once you have a working prototype, you can then move to an SQL database on your server if you need to.
Jan 11, 2021 09:35 PM
This will help me in my research,
thank you.