TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Show HN: Google Sheets as backend for React apps

17 点作者 haxzie超过 1 年前

4 条评论

indiantinker超过 1 年前
You can do it directly using just &#x27;google-spreadsheet&#x27; npm package. I built this[1] mini-HR portal using that. 95+ lighthouse score :) [1]: <a href="https:&#x2F;&#x2F;www.wildcardjobs.com" rel="nofollow">https:&#x2F;&#x2F;www.wildcardjobs.com</a>
评论 #39370736 未加载
haxzie超过 1 年前
Creator of Apico here. This is a tiny example of how to use SaaS apps as backend for your small projects. As folks outlined in other comments I will clarify a few things.<p>&gt; How is this different from using the SDKs, or APIs directly from Google? Honestly it&#x27;s very similar, the APIs offered by this app and Google are very similar. The only difference is that you get the APIs literally within a single click and added benefit of fine-grained access control over individual endpoints. You can make endpoints public (access to anyone) vs private (only be accessed with an auth token)<p>&gt; Why don&#x27;t just use Google APIs then? Most of the APIs are server side considering security, you cannot expose these credentials to the client side, unless you only allow specific scopes that can be exposed. And then create a different set of credentials to be used on your server side to handle other actions. With this app, it acts as a proxy and firewall on top of the Google APIs, so you can expose specific endpoints to be public and rest to be private.<p>Adding to that you need to spend more time looking through docs and setting up Postman or similar tool to test the APIs, the app literally gives everything you need, APIs, Playground and a proxy for you to play around.<p>&gt; Rate limits? Right now, I haven&#x27;t looked into this, but hopefully soon :)
hiatus超过 1 年前
How does this solution compare to creating a google project for yourself? It seems if you are already developing a react app, setting up a project in google is straightforward. The direct method also enables sharing of sheets via email. Example implementation: <a href="https:&#x2F;&#x2F;thenewstack.io&#x2F;how-to-use-google-sheets-as-a-database-with-react-and-ssr&#x2F;" rel="nofollow">https:&#x2F;&#x2F;thenewstack.io&#x2F;how-to-use-google-sheets-as-a-databas...</a>
评论 #39370699 未加载
35mm超过 1 年前
How does this deal with Google’s rate limits?