Live data from Hacker News

Portugal. The Man – Official Website Is a Google Sheets Document

portugaltheman.com

181–186 of 186 posts

Re: Portugal. The Man – Official Website Is a Google Sheets Document

#181

Earlier quoted context omitted.

A band name is not trivial. It doesn't seem they spent any time or effort thinking up a good one (unless of course there is a marketing angle here, and the name (and band?) was entirely manufactured).

I think you're thinking about this a little too hard. It's music. Listen, or don't.

Ah but words are important. I'm disappointed by their word smithing (in the explanation, if not the actual naming).

Re: Portugal. The Man – Official Website Is a Google Sheets Document

#182
post #153

Earlier quoted context omitted.

A band name is not trivial. It doesn't seem they spent any time or effort thinking up a good one (unless of course there is a marketing angle here, and the name (and band?) was entirely manufactured).

You must be a lot of fun at parties.

Indeed I am!

Re: Portugal. The Man – Official Website Is a Google Sheets Document

#183
post #144

Earlier quoted context omitted.

A band name is not trivial. It doesn't seem they spent any time or effort thinking up a good one (unless of course there is a marketing angle here, and the name (and band?) was entirely manufactured).

Let’s be real, the Beatles is one of the worst band names ever. People often name their band when they are young and they get stuck with it. If Portugal the man is manufactured (entirely baseless claim) they did a pretty terrible job with it. They recorded and toured for ~15 years before getting any mainstream success.

Granted. But 'Portugal. The man' seems particularly cack-handed. Worse to me as I actually live in Portugal currently, it would have been nice to see some sort of connection.

Re: Portugal. The Man – Official Website Is a Google Sheets Document

#184
post #163
post #97

Earlier quoted context omitted.

You write the SQL yourself, so you can do anything you want, including UPDATE parties SET name=:name, date=:date WHERE id=:id;

Thanks for the response, I was looking at your site from mobile earlier and it didn't jump out at me that it could also be used to edit data (tho I now see it mentioned clearly). Might be worth calling it out in a section as easy editing. Btw how would you compare this to https://datasette.io/ which is the first thing that came to mind? Is yours a bit more developer oriented?

Hey, that's a good question, and the tools do have some overlap. Here is my (totally biased) comparison:

- datasette builds one single website and API, which you cannot customize, on top of a SQLite database. It is a little bit ugly, but very efficient to help you discover your own dataset, and make some quick data analysis. If you're concerned about restricting public access to your database, sharing it may not be ideal.

- SQLPage does not build anything for you by default. You need to write at least two or three SQL queries to make a useful website on top of your database. This requires you to already know the schema of the data you are working with. But this allows you to build visualisations of your data that look the way you want. While Datasette mainly offers tables, SQLPage provides forms, graphs, lists, tables, data cards, and more. The results tend to have a more polished and professional appearance, and your database remains private. Only the (parameterized) queries you create yourself can be executed by website visitors.

Furthermore, a significant distinction is that Datasette exclusively works with SQLite, while SQLPage can connect to SQLite, Postgres, MySQL, or SQL Server databases.

Re: Portugal. The Man – Official Website Is a Google Sheets Document

#185
post #163

Earlier quoted context omitted.

Thanks for the response, I was looking at your site from mobile earlier and it didn't jump out at me that it could also be used to edit data (tho I now see it mentioned clearly). Might be worth calling it out in a section as easy editing. Btw how would you compare this to https://datasette.io/ which is the first thing that came to mind? Is yours a bit more developer oriented?

Hey, that's a good question, and the tools do have some overlap. Here is my (totally biased) comparison: - datasette builds one single website and API, which you cannot customize, on top of a SQLite database. It is a little bit ugly, but very efficient to help you discover your own dataset, and make some quick data analysis. If you're concerned about restricting public access to your database, sharing it may not be i…

I haven't quite had a chance to set it up and play with it yet but one thing that I think is missing is that there is no clear way to write to it via api. I know it's not exactly the main purpose but I'd really like to be able to shoot data over from wherever and then let my friends/family easily see and edit it in the GUI.

Anyway it's a great looking tool and wishing you the best with it!

Re: Portugal. The Man – Official Website Is a Google Sheets Document

#186
If anyone is interested one of the founding members Dewey Halpaus has a podcast called Peer Pleasure Podcast.

He interviews other bands and often speak about his time touring and going through the music industry. I believe in addition to the podcast he also works a tradesman in Oregon.

Great Idea for Anyone who just needs to point people in a direction to find them.

Post reply on HN