[HN Gopher] My blog is now generated by Google Docs
       ___________________________________________________________________
        
       My blog is now generated by Google Docs
        
       Author : RupertWiser
       Score  : 191 points
       Date   : 2020-05-10 16:57 UTC (6 hours ago)
        
 (HTM) web link (benwiser.com)
 (TXT) w3m dump (benwiser.com)
        
       | madsohm wrote:
       | I run my wishlist from a Google Sheets document. It's a bit
       | annoying that you can't have gaps in rows in the spreadsheet,
       | since fetching as JSON will only return up until the first gap.
        
       | throwawaysea wrote:
       | Cool idea, but I worry about over reliance on Google or other big
       | tech players, especially after their recent steps to ramp up
       | censorship. Another example is that Medium blocked many
       | informative COVID-19 posts recently despite them being thoughtful
       | and necessary discussions, especially given the repeated failings
       | of the WHO. What's a great blog platform that features a lack of
       | censorship or protection against censorship as a feature?
        
       | tbstbstbs wrote:
       | Great job, thanks for sharing!
       | 
       | Some might like this adoption of the idea: I work in consulting
       | and have to prepare presentations all of the time.
       | 
       | Therefore, I created a Powerpoint generator that uses a Google
       | Sheet as a source: http://demo.inf.university
       | 
       | <-- It doesn't look spectacular, but it saved me really a lot of
       | time. "Can you prepare a briefing about X,Y,Z" - "Sure, it will
       | take -cough- about 3 days" :-)
        
       | magicalhippo wrote:
       | Way back I considered using Microsoft Word as my content editor
       | for my blog, and wrote a PHP script that converted .docx files to
       | static HTML. To publish all I had to do was upload a new .docx
       | file to a given directory on my shared host and wait for the
       | script to run.
       | 
       | It converted the Word "Heading 1" etc styles to some CSS class,
       | and had support for extracting inline images etc. I relied on
       | convention for certain things like post title, and it didn't
       | support too fancy things in the Word document.
       | 
       | At that time .docx was rather new, so I wasn't sure if it would
       | stick around. Also I wasn't sure this was the best idea ever, so
       | I ended up with something else. But it was a fun adventure.
        
         | Hello71 wrote:
         | is there any benefit of that over the built-in html export
         | function (which also works terribly)?
        
           | magicalhippo wrote:
           | Well the key point was to use Word for basic content editing
           | and layout, but have control over the styling on the website
           | part of things (ie via my own style sheet). As I recall the
           | generated HTML from Word was quite a mess, and it would be
           | non-trivial to change the styling of it.
           | 
           | It also allowed the pages to be easily integrated into my
           | blog, with first paragraph being visible on the main page
           | etc.
           | 
           | Mostly though it was just a "can it be done" experiment :)
        
         | [deleted]
        
         | [deleted]
        
       | jacquesm wrote:
       | Have you planned for what you will do if Google shuts down your
       | account?
        
       | Traster wrote:
       | So there's a few things I'd take issue with here. Firstly,
       | writing a static site with a little bit of CSS is easier than
       | ever. Not only are there lots of neat CSS files that will help
       | you, but browsers _actually_ are fairly good at functioining more
       | or less the same. There was a time that writing corect CSS was a
       | real art, but that 's not really true as much today. Secondly, I
       | think this is one of many examples of creating an incredibly
       | complex solution to a trivial problem - the initial problem isn't
       | a problem, and linking into an incredibly hefty cloud based
       | system just seems nuts in my opinion. Finally, who exactly is
       | looking to try and _increase_ their dependence on google?
       | 
       | I think part of my opinion comes from that latex/vim bent, where
       | you're using very programmatic, specific idioms to get what you
       | wrote, and if you're less comfortably with that then maybe you
       | appreciate all the work of building some google docs based on
       | monstrosity, but the more experience I've gained, the more I've
       | learned to use the right tool for the job. Google docs isn't a
       | blogging tool, so don't use it as one.
        
       | elondaits wrote:
       | I recently used Google Sheets as a CMS for a couple of projects.
       | 
       | In my case I had a server-side script which read the sheets,
       | converted the data to JSON and saved it on a file which was then
       | fetched by the JS client. The conversion only had to run when
       | there were updates (e.g once a day).
       | 
       | It was really convenient in my particular case because all users
       | where familiar with Google Sheets, already had users and
       | passwords, and I had good granular control over permissions.
        
         | ignoramous wrote:
         | You might also be interested in Glide, helps build mobile-apps
         | with Google Sheets:
         | https://news.ycombinator.com/item?id=19163081
        
         | mettamage wrote:
         | How does it work when you have _a lot_ of text and you need to
         | put that in one cell? Doesn 't that get a bit too unruly?
        
           | vijaybritto wrote:
           | I dont think we need to care about google sheet's looks while
           | using it as a DB. This approach is pretty good and fast
        
       | ForrestN wrote:
       | This is a nice idea, especially for a case where a website is
       | collaboratively edited. I don't love Google Docs for solo
       | projects, and I don't enjoy using it, but its collaborative
       | editing features are so good and reliable that I can't escape it.
       | Being able to suggest and accept changes with commenting among a
       | group of people would be really nice for a website for a
       | collective, say.
       | 
       | That said, a bit of small, hopefully constructive feedback. The
       | impact of this would be a bit bigger if there were more blog
       | posts, so that by the time you reveal you're using google docs it
       | feels more like a practical application and less like a very
       | quick demo. Also, while I understand that there's a sort of
       | "coder who doesn't do design" aesthetic, it might be good to at
       | least change the colors a bit so that there's a bit more magic of
       | transformation. This looks a bit too much like, well, a Google
       | doc, and you want to establish that something cool is going on
       | that couldn't be done with just an index of publicly visible
       | google docs.
        
         | [deleted]
        
         | [deleted]
        
         | remote wrote:
         | It's a really cool idea Google codelabs has been using for a
         | few years to provide a unified way to write development
         | tutorials[1].
         | 
         | 1. https://github.com/googlecodelabs/tools/
        
           | ehsankia wrote:
           | Not to be confused with Google Colab! Which provides shared
           | Jupyter Notebook, which also can be great for writing
           | markdown cells, with graphs and code interspersed.
        
       | ignoramous wrote:
       | My first encounter with a docs -> website was the now-defunct
       | joelewis' hexopress.com. The code; however, is opensource [0].
       | 
       | There's a dated, unmaintained Google Docs to Markdown converter
       | [1] which can be used as a source for a static site generator
       | like Hugo [2]. This is particular interesting since folks can
       | style content as they normally would from within Google Docs and
       | have it show up with the same styling on a webpage, rather than
       | write HTML themselves.
       | 
       | [0] https://github.com/joelewis/hexopress
       | 
       | [1] https://github.com/mangini/gdocs2md
       | 
       | [2] https://gohugo.io/content-management/formats/
        
         | leonidasv wrote:
         | As an alternative, Gatsby -- a JS-powered static site generator
         | -- has a plugin for Google Docs that appears to be in active
         | development.
         | 
         | https://www.gatsbyjs.org/packages/gatsby-source-google-docs/
        
       | richardARPANET wrote:
       | Shameless plug incoming... I made the equivalent but for APIs
       | using Google Sheets :) https://sheet2api.com/
        
         | metrix wrote:
         | i'm using Google Sheets for a Coronavirus Tracker
         | http://amarillo.land/coronavirus.html but i'm not enthused with
         | the performance. This looks very interesting!
        
         | fireattack wrote:
         | Want something like this for a long time.
         | 
         | The 50 row limit of the free tier doesn't fit my hobby project
         | unfortunately, but it's glad to see someone developed such
         | thing!
        
           | ehsankia wrote:
           | Yeah, this is a great service but the pricing doesn't make
           | sense (even after the free tier). 10$ a month (!!!) and it
           | still wouldn't fit my use case with only 1500 rows. The
           | convenience is nice but considering Google/Microsoft is
           | paying for most of the hosting, cell computation and so on,
           | not sure why a wrapper around an API is so expensive.
        
         | hckr_news wrote:
         | Saved :)
        
         | onesmalluser wrote:
         | You can get a Google Sheet in JSON format just by adding
         | alt=json to the URL. What do you do differently?
        
       | 1wheel wrote:
       | The NYT uses docs to author interactive articles that don't fit
       | nicely in the CMS.
       | 
       | I've missed that workflow a lot (comments and edits are
       | amazing!); I just open sourced a tiny library that saves a doc as
       | a text file.
       | 
       | https://github.com/1wheel/doc2txt                 npx doc2txt
       | 1StMiAtcY6bY6yEIQp5pVSGdIHSnZG-kFspdmsSzAJdE --outpath
       | gettysburg.txt
        
       | WheelsAtLarge wrote:
       | Hey all, keep in mind that this is an experiment and the OP is
       | therefore looking for input from users. Don't look at it from a
       | finished product point of view but as a starting point and give
       | your ideas. I think this is a great solution a quick in office
       | CMS for in house projects.
        
       | z3t4 wrote:
       | Would be interesting with more details on how this works. Like
       | how the URL works and how the pages are styled. Is there any
       | services needed beside google docs, etc.
        
       | Tade0 wrote:
       | Good work - bonus points for having it work with JS disabled - a
       | surprising number of blogs need JS to even render for some
       | reason.
       | 
       | A while ago was facing a similar dilemma, so I went with this:
       | 
       | https://sapper.svelte.dev/
       | 
       | Plus a one-step deploy process made in Ansible by a friend of
       | mine.
       | 
       | My take is that while Sapper isn't exactly production-ready, it's
       | a otherwise competent static-site generator.
       | 
       | I write my posts in markdown and the system adds styling and
       | modifications like target=_blank for links in a consistent
       | manner.
       | 
       | Best thing about it is that I managed to use the experience from
       | building my blog to help a friend who's an artist to set up his
       | webcomic - also a static site.
       | 
       | The friend in question knows how to use FTP but that's about the
       | extent of his technical skills, so the process involves him
       | modifying a JSON file by adding an object with the comic title,
       | flavour text and of course image URL to an array, running the
       | generator and uploading the result.
       | 
       | The landscape of systems for this use case is pretty horrible, so
       | this approach proved to be more pragmatic.
        
       | iisthesloth wrote:
       | Love using Docs as a source. A while back I wrote a service[1]
       | which creates an API using Google Drive and Docs as a source.
       | Docs are naturally pages, and the Drive folder structure builds
       | the hierarchy/tree of pages using a pretty simple naming
       | convention (Mainly for ordering). The CMS/collaborative aspect is
       | great. Some things that aren't ideal are:                 -
       | Seeing print-style page breaks in docs       - Formatting images.
       | Although, having Google host them is nice       - The html Google
       | Drive generates is inlined, inconsistent, and pretty nasty. I
       | resorted to using markdown in Docs.
       | 
       | 1. https://github.com/psaia/allwrite-docs
        
         | RupertWiser wrote:
         | Another solution that I explored a bit was using the google
         | docs api. It returns a Json structure of the doc. I just used
         | the drive export as a shortcut but you could totally create
         | something neater with the drive api.
        
           | iisthesloth wrote:
           | Great idea. I will certainly look into that. Thanks!
        
       | xnxn wrote:
       | I recently learned (via Rich Harris's recent Svelte Society Day
       | talk[1]) that the New York Times does something like this using a
       | custom markup language called ArchieML[2].
       | 
       | [1]: https://youtu.be/luM5uobewhA?t=1301
       | 
       | [2]: http://archieml.org/
        
       | nicexe wrote:
       | I don't really understand the argument against something like
       | jekyll. There is no special styling as of now anyway so why would
       | jekyll need any?
        
       | soared wrote:
       | Blot.im does this but with dropbox and its amazing. Since you use
       | word docs instead of g docs the formatting transfers over
       | perfectly. Super easy setup and $20/yr. I've been using it for 2
       | or 3 years and it's great.
       | 
       | Npzero.com is my blog if you want to see an example. There are
       | much prettier themes you can choose from as well. I have a chrome
       | book so sometimes I write in g docs, export to word, and upload
       | to Dropbox's webapp and make final adjustments in their online
       | editor. No affiliation, just a great product.
        
       | franciscop wrote:
       | The first version of https://makersupv.com/ was made with Google
       | Drive as well:
       | 
       | - There was a spreadsheet with the list of articles and some
       | meta-information such as publication date, "published" flag, etc.
       | This was then extracted with https://github.com/franciscop/drive-
       | db on a Node.js backend.
       | 
       | - Then each article was written as a single google docs document,
       | so we could edit them collaboratively.
       | 
       | Meta: The front-end was built with https://picnicss.com/, which
       | is a library I also created for this project.
        
       | obeattie wrote:
       | I've been thinking about going the other way a bit recently:
       | having bots consume input from and add their output to a Google
       | Doc.
       | 
       | There are so many processes in most businesses which involve many
       | humans collaborating on templatised documents. Google Docs/Sheets
       | fits into these workflows very well, but there's often scope for
       | some partial automation in there too - pulling information from
       | databases and outside sources and keeping it in sync, etc.
       | Developing custom web apps for each case is too much effort for
       | too little reward, takes users out of a familiar (and well-liked)
       | interface which updates in real-time, makes you reimplement
       | permission models, etc.
       | 
       | Not something I've explored properly yet so I don't know if the
       | APIs are rich enough to make this easy, but I would really like
       | to give it a look.
        
         | pier25 wrote:
         | I used that approach for a reporting system and it worked
         | pretty well. It was easy to hit the sheets api rate limit but
         | it was just a matter of waiting a bit between requests.
         | 
         | The node script was triggered hourly with Heroku scheduler.
        
       | londons_explore wrote:
       | It would be cool if it was 100% live... Ie. with every keystroke
       | the website is updated. Does the Google Docs API have some kind
       | of event based notification of new keystrokes you could hook
       | into?
        
         | schaefer wrote:
         | As a reader, i don't want to be anywhere near somebody's half-
         | finished first draft.
         | 
         | different personalities, I suppose.
        
       | marvinblum wrote:
       | You can do this with Emvi [1] too. It works like a headless CMS.
       | I wrote a wiki for a German gaming community [2]. The project is
       | available on GitHub [3] if anyone is interested and can easily be
       | adopted to your own project. The articles fit a blog very well as
       | they don't use pages and therefor are continuous. The API spits
       | out clean HTML.
       | 
       | [1] https://emvi.com/
       | 
       | [2] https://wiki.sts.wtf/
       | 
       | [3] https://github.com/Special-Tactical-Service/wiki
        
       | bawana wrote:
       | What's wrong with blogger? You know https://www.blogger.com/
       | 
       | Also run by Google. Also subject to all their rules. But also
       | robust with a simple clean interface.
       | 
       | I wish there were a simple free way for me to enjoy free speech.
       | I already pay for dropbox. Why can't dropbox let me assign a
       | folder in my account become a blog.
        
       | el_programmador wrote:
       | God forbid if Google lifted their hands some day, can you even
       | imagine how many million people will be impacted due to how many
       | services ranging from emails to map apps to cloud services to web
       | services, etc? Is it wise to give one entity power over so many
       | things or its better to encourage a decentralized structure where
       | multiple organizations control only bits of the pie?
        
         | austin223 wrote:
         | Absolutely agree. Unfortunately I don't think nations like the
         | US will ever have the balls to break up their wonder children.
        
           | hencq wrote:
           | You mean like the US did with AT&T? I'm not sure if they
           | 'have the balls' currently, but they have in the past and
           | it's not inconceivable they would do so again. Microsoft came
           | close to it as well.
        
             | lonelappde wrote:
             | AT&T reformed as regional monopolies in far less time than
             | it took the government to break up the national monopoly.
        
             | zokier wrote:
             | I do point out that US vs AT&T did first major anti-trust
             | settlement in _1913_ , and the breakup ultimately happened
             | in 1984, or about _70 years_ later. So maybe we 'll see
             | Google breakup too in 2084 or around that time..
        
           | el_programmador wrote:
           | Nations are ultimately made up of people and they are subject
           | to peoples' pressure. Its the people who we must convince and
           | wake them from their deep slumber.
        
         | zokier wrote:
         | Sure, it is a genuine concern. But I find the context for the
         | comment here bit funny considering how much the world runs on
         | top of gdocs etc, the risk of losing the source of personal
         | blog is drop in a ocean.
         | 
         | And while there of course are no guarantees, I at least would
         | expect fair warning before stuff like docs is killed.
        
           | lonelappde wrote:
           | The ocean is made of drops.
        
         | crazygringo wrote:
         | Well, I don't need to trust Google's employees, I trust its
         | shareholders wanting to make money, which will never stop.
         | 
         | Since Google's popular products all contribute to making money
         | in the end, they're not going to stop. Shareholders just
         | wouldn't let it happen. There's a chain of accountability here
         | that goes employees > C suite > board > shareholders.
         | 
         | So I don't quite see what situation you're worried about here.
        
           | judge2020 wrote:
           | if by some magical event Alphabet/Google is able to shut down
           | their free versions of their Office apps and rely solely on G
           | Suite/YouTube/Waymo/etc without losing money, I don't doubt
           | they would do it. If that event will ever happen is still a
           | mystery and is probably unlikely to happen within my/our
           | lifetimes.
        
           | lonelappde wrote:
           | Google's shareholders don't hold substantial voting power.
           | Accountability practically ends at CEO.
        
             | crazygringo wrote:
             | That's just so factually untrue it's hard to know what to
             | tell you.
             | 
             | Do you understand how corporate boards work? How large
             | shareholders get their own board seats? How boards hire and
             | fire members of the management team?
             | 
             | The idea of a toothless board is a complete fiction. I
             | don't know where you got the idea, but it couldn't be more
             | wrong.
             | 
             | (Perhaps you're confusing it with boards where a single
             | shareholder has more than 50% of shares, thus making the
             | board largely irrelevant because the shareholder controls
             | it. But even in that case, the CEO effectively reports to
             | that shareholder, and there have been _many, many, many_
             | cases of underperforming CEO 's being fired. It happens all
             | the time.)
        
         | hombre_fatal wrote:
         | I don't think the cost of losing things is as high as you
         | imagine. You can use X until it fails and then you can use Y.
         | 
         | I also don't think your doomsday scenario makes much sense
         | either. What do you mean "lifted their hands" and why would it
         | happen out of the blue with zero warning? Though I'll repeat:
         | so what?
         | 
         | I don't think a decentralized system is much better in this
         | regard. It just means things rot at a more staggered pace.
         | Service A shuts down on year 0, service B shuts down on year
         | 10, etc. It's just a different trade-off, not the panacea we
         | like to pretend it is.
        
         | duxup wrote:
         | At least with takeout I know I have regular backups.
         | 
         | That's more than most places offer.
        
           | tmpz22 wrote:
           | Have you looked through the takeout outputs though? They are
           | completely worthless to most users. It's funny to me that a
           | bunch of Google devs built the functionality and thought "ya
           | this will do".
        
             | thinkingkong wrote:
             | I doubt the devs have much influence over the scope of the
             | data output. The goal there is minimum for legal,
             | compliance, or pr reasons.
        
             | judge2020 wrote:
             | https://mboxfile.com/google-takeout/
        
             | adrianmsmith wrote:
             | What's wrong with the data?
             | 
             | I mainly care about Google Docs and Sheets, they're
             | exported as Word and Excel (and there are other options if
             | you don't like this formats), and the random sample of docs
             | I tried in the output worked fine in Word and Excel.
        
             | filleduchaos wrote:
             | How are the takeout outputs useless? Mail for example comes
             | as a nice standard mbox
        
           | jacquesm wrote:
           | Takeout is useless without Google. Also: gsuite doesn't
           | really have a backup feature. You're locked in for all that
           | it's worth.
        
             | duxup wrote:
             | Why is it useless?
        
           | lonelappde wrote:
           | Takeout doesn't work for users with substantial data.
        
             | duxup wrote:
             | What does it do?
             | 
             | Does it not provide the data?
        
       | hawski wrote:
       | I'm finishing up with a simplistic template for Zim wiki. That
       | will enable me to have a website with nice Wysywig interface
       | divorced from web bloat and limitiations, but also some of its
       | convenience.
       | 
       | https://zim-wiki.org/
        
       | krm01 wrote:
       | After building a number of [1] projects that are powered by
       | Google Docs, I recently realised that it also means that
       | countries (like China) where Google is blocked, won't be able to
       | access your content.
       | 
       | https://upstart.me (powered by Google Docs)
        
         | sfusato wrote:
         | FAQ not expanding.
         | 
         | Console errors: Blocked loading mixed active content "http://cd
         | njs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.mi...
         | upstart.me Request to access cookie or storage on "<URL>" was
         | blocked because it came from a tracker and content blocking is
         | enabled. 6 ReferenceError: $ is not defined script.js:1:1
         | Blocked loading mixed active content "http://cdnjs.cloudflare.c
         | om/ajax/libs/jquery/2.1.3/jquery.mi... upstart.me Loading
         | failed for the <script> with source "http://cdnjs.cloudflare.co
         | m/ajax/libs/jquery/2.1.3/jquery.mi.... upstart.me:179:1
         | ReferenceError: $ is not defined
        
           | scott113341 wrote:
           | Looks interesting, I signed up!
           | 
           | FWIW, I ran into the same issue (Chrome): https://user-
           | images.githubusercontent.com/1910118/81509549-a...
        
           | judge2020 wrote:
           | Have you visited the Cloudflare main website by chance? cdnjs
           | doesn't serve cookies unless you've visited cloudflare.com
           | yourself. Either way the cdnjs jquery isn't a tracker.
        
             | shanipribadi wrote:
             | mixed active content was why the browser blocked it. the
             | cdnjs link is http, while the site is https.
        
       | lihaciudaniel wrote:
       | >wordpress (I really don't like wordpress).
       | 
       | I really don't like your blog
        
       | patwalls wrote:
       | I built an app that lets you create a blog from Google docs.
       | 
       | https://youdontneedwp.com
        
         | davidsojevic wrote:
         | I remember this from a while back -- you originally wrote this
         | as part of your live-streaming new projects effort, if I
         | remember correctly?
         | 
         | Your original HN thread about it here:
         | https://news.ycombinator.com/item?id=18077446
        
       | ipsum2 wrote:
       | Reminds me of generating webpages from Microsoft Word. The issue
       | is that the HTML looks pretty awful. For example, on the webpage,
       | there's a bunch of tags that don't do anything and the inline
       | style makes it difficult if you wanted to change the font family
       | or color.
       | 
       | </span></p><p style="padding:0;margin:0;color:#000000;font-
       | size:11pt;font-family:&quot;Arial&quot;;line-
       | height:1.15;orphans:2;widows:2;height:11pt;text-align:left"><span
       | style="color:#000000;font-weight:400;text-
       | decoration:none;vertical-align:baseline;font-size:11pt;font-
       | family:&quot;Arial&quot;;font-style:normal"></span></p><p
       | style="padding:0;margin:0;color:#000000;font-size:11pt;font-
       | family:&quot;Arial&quot;;line-
       | height:1.15;orphans:2;widows:2;text-align:left"><span
       | style="color:#000000;font-weight:400;text-
       | decoration:none;vertical-align:baseline;font-size:11pt;font-
       | family:&quot;Arial&quot;;font-style:normal">
        
         | marvinblum wrote:
         | Yeah that's pretty ugly. Emvi [1] generates clean HTML. Here is
         | an example for that: https://wiki.sts.wtf/read/Arma-3-Sync-
         | oVlaBeQdAY (the part within the "article-content" div).
         | 
         | [1] https://emvi.com/
        
           | baxtr wrote:
           | Use "Show HN" to show case it :-)
        
             | [deleted]
        
             | marvinblum wrote:
             | We showed Emvi and the new user interface we are working on
             | right now already :)
             | 
             | https://news.ycombinator.com/item?id=22640054
        
         | RupertWiser wrote:
         | The alternative is to hook into the Google Docs API which gives
         | you a more structured response which you can then self style.
         | 
         | Exporting HTML was the easy way out for me. I haven't
         | investigated the accessibility impact but the file sizes are
         | minimal so it didn't feel like a massive trade off.
        
       | ErikAugust wrote:
       | I would only worry that the Google API access changes or gets
       | pulled altogether. Otherwise it has some benefits, including
       | collaboration.
        
       | lkc9 wrote:
       | This isn't directly related to the post but the root of this
       | website is hilarious: https://benwiser.com/
        
         | miguelmota wrote:
         | On mobile I just see a broken static image of the person's
         | head.
        
         | modeless wrote:
         | I love it! I think the rendering could be improved by
         | projecting the image to compensate for screen tilt, in addition
         | to rotating the head.
        
         | superhuzza wrote:
         | Came here to say the same thing. It's weird, I loved the
         | effect. I showed it to my partner and she found it terrifying
         | though!
        
       | andy_ppp wrote:
       | I saw someone I was working with using Google docs for seed data,
       | I actually think this is quite cool as long as it's performed in
       | two steps (pull, insert) as you still want to be able to recreate
       | offline or should Google docs explode (or price or cancellation).
        
       | janjanson wrote:
       | I've run a little round robin/bracketed tournament website
       | through the Google sheets JSON API once. It was a really easy way
       | to have an interface for the organizers to update scores and
       | players.
        
       | _Chief wrote:
       | seeing secrets.txt in the repo gave me a fright for a second and
       | it's not even my project
        
       | butz wrote:
       | What about just using Google Sites? They have updated UI and
       | improved functionality quite a bit. You can even link your own
       | domain.
        
       | city41 wrote:
       | This website: https://www.fgbg.art/, is powered by this
       | spreadsheet:
       | https://docs.google.com/spreadsheets/d/1W8RE885PVF2z3L9KU9LS...
       | 
       | The spreadsheet not being normalized is a bit annoying, but I
       | could fix that if I really wanted to. All in all, I actually find
       | using Google as a data source like this works pretty well.
        
         | jonnydubowsky wrote:
         | I just spent 20 minutes browsing your site, revisiting these
         | epic scenes. Thanks for sharing!
        
         | onesmalluser wrote:
         | What add-on are you using to do that? I've been playing around
         | using Lovely Table and Awesome Table for this purpose but not
         | really sure which one I ultimately want.
        
           | city41 wrote:
           | The site is built with Gatsby using gatsby-source-google-
           | sheets. The source is here: https://github.com/city41/fgbg
           | (warning, it's pretty terrible. I built this thing very
           | rapidly as at its heart it's really just an experiment).
           | 
           | https://www.gatsbyjs.org/packages/gatsby-source-google-
           | sheet...
        
       | mikeryan wrote:
       | It's a bit strange hitting the google redirect notice when
       | linking from the site.
       | 
       | You also might want to put your .idea directory and secrets in a
       | .gitignore
        
         | netsharc wrote:
         | If I were to fork his code I'd fix that the first thing, I'd
         | hate to annoy my users like that.
         | 
         | Reminds me of this jwz post (you have to copy and paste
         | manually since he doesn't like HN as a referrer:
         | https://www.jwz.org/blog/2008/02/looking-forward-into-the-pa...
         | ).
        
           | cookiecaper wrote:
           | Right-click -> Open in Private Tab/Window also strips the
           | referrer, FYI.
        
           | [deleted]
        
           | gibolt wrote:
           | This feels like such a weirdly specific block... You have a
           | blog that you want people to read, but not people who come
           | from a specific source
        
         | harikb wrote:
         | I wish IDEs (with collaboration from git) made it clear what
         | should and shouldn't be checked in to source control (or rather
         | they had a way to do both) - where I want to store per-person
         | level settings as well as shareable settings.
         | 
         | In this particular case though - IntelliJ itself would have
         | prompted him to add these files - so those are in fact
         | shareable files
         | 
         | Note: I do know IntellJ purposely excludes workspace.xml , but
         | these things should be handled much more explicitly and IDE
         | should provide better conventions and guidance.
        
           | Larrikin wrote:
           | The .ignore plugin and the GitHub repo it is built around I
           | think do the job well enough by having a list of suggestions.
           | I may actually have a private repo and have all the settings
           | on both computers that I use.
        
         | RupertWiser wrote:
         | Hah fortunately those secrets were never actually in use. I
         | just did the unspeakable and quickly rebased master to update
         | that though so thanks for that!
         | 
         | I wasn't planning on sharing the code at first so I probably
         | didn't give it as critical an eye as I should have. This was
         | also a learning project for me to try out Kotlin so I'm sure
         | there are a million things others would do far better.
        
           | amenod wrote:
           | It is soooooo easy for something that was just an experiment
           | to get published somewhere, that I have learned (the hard
           | way, multiple times) to never commit any secrets to a git
           | repo. Well, _intentionally_ that is... but if I do it by
           | mistake, I treat them as compromised and change them.
           | 
           | Instead I just create a .env file and put them there. It's a
           | bit more boilerplate but it is worth it when I don't need to
           | decide between keeping secrets and having code history before
           | publishing. And env vars are supported everywhere afaik.
        
       | K0SM0S wrote:
       | I'm more of a Markdown, maybe LaTeX guy myself, but 100% down
       | with the author's approach.
       | 
       | The simplest "CI/CD", and closest to the material (plain text
       | files), is usually the best in practice, especially for a one-man
       | operation.
       | 
       | Iterate into complexity on a need-to-basis.
        
         | puzzlingcaptcha wrote:
         | I personally like Pelican as a static blog generator that
         | parses Markdown content.
         | 
         | https://blog.getpelican.com/
        
       | factorialboy wrote:
       | The URL to your GitLab project goes via a Google redirect. I'm
       | guessing this in an unintentional side-effect of using Google
       | Docs as CMS?
        
       ___________________________________________________________________
       (page generated 2020-05-10 23:00 UTC)