121–130 of 186 posts
Earlier quoted context omitted.
I like the idea of this a lot, but does it provide any way to edit the data?
You write the SQL yourself, so you can do anything you want, including UPDATE parties SET name=:name, date=:date WHERE id=:id;
Earlier quoted context omitted.
This looks really good, but I had to pass on it because I couldn't find screenshots or, even better, a demo site. I think that would really help sell this.
The official website for SQLPage ( https://sql.ophir.dev/ ) is written in SQLPage. The sql source code for it is here: https://github.com/lovasoa/SQLpage/tree/main/examples/offici... The site also links to this little collaborative game written in SQLPage: https://conundrum.ophir.dev/ The github README has code snippets and associated screenshots: https://github.com/lovasoa/SQLpage#examples There is also an official…
My recommendation would be to have a clear "see a demo" button, which leads to a website that showcases the most common elements I might want to have on such a page (a form, some graphs, etc), maybe with source code close by.
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;
I can’t tell if that’s a sarcasm or “dropbox is just ftp” level of professional deformation.
The update form would look something like this:
select 'form' as component;
select 'event_name' as name,
(select name from events where id=$id) as value;
select 'event_date' as name, 'date' as type,
(select date from events where id=$id) as value;
select 'event_id' as name, $id as value, 'hidden' as type;
update events set name=:event_name, date=:event_date where id=:event_id;
It's a little bit more complicated to set up than a google sheet, but it's less complicated to use afterwards.
I also have an iOS published app that has a Google Sheets “backend”: https://subsol.one It’s an app for finding parties and festivals in Romania, and the sheets choice makes it super easy for my brother and his friends to add parties to the app. I thought about adding a “real” database and tried some apps/frontends for them, but nothing made it easy enough to update and insert rows for non technical people. I figured…
Realtors and doctors, mostly.
It’s a pet peeve of mine how selectively the “don’t editorialise headlines” guideline is enforced
"Frances has a rare genetic mutation that causes a degenerative disease called DHDDS. In the last few years, breakthroughs in medical science have made it possible to develop a treatment. Unfortunately, it's extremely expensive. We are telling Frances’story in hopes of raising enough donations to fund her treatment."
https://www.chrisblackchangedmylife.com/donate
Hopefully the HN traffic boost can help drive some donations and new research into treating neurological diseases. Donate!
Earlier quoted context omitted.
The official website for SQLPage ( https://sql.ophir.dev/ ) is written in SQLPage. The sql source code for it is here: https://github.com/lovasoa/SQLpage/tree/main/examples/offici... The site also links to this little collaborative game written in SQLPage: https://conundrum.ophir.dev/ The github README has code snippets and associated screenshots: https://github.com/lovasoa/SQLpage#examples There is also an official…
This is all good, but you're making a mistake I see many people make: If one person has this experience/questions (me), then many of your other visitors will. Answering here will answer my questions, but it won't answer everyone else's questions. My recommendation would be to have a clear "see a demo" button, which leads to a website that showcases the most common elements I might want to have on such a page (a form,…
They’re not easy to create but side by side code/result demos like the ones I saw on https://imba.io/ make it very clear on what I’ll be getting into as a developer.
The problem with this website is that it's filled with popups suggesting to accept cookies, privacy, and stuff. Before I ever see an unobstructed web page, I have to perform about two or three clicks accompanied with intimidating text descriptions. The more clicks the better, right? More clicks is a sure sign of improved engagement. But seriously, it is not.
The issue you describe is a general one driven by regulation and not specific to this website
It’s driven by privacy invasive practices from the services. I have never created a website that showed popups or required people to “accept” anything, because I respect the people who visit them. The websites who say they “value your privacy” while at the same time revealing they have “1542 partners” (yes, really) they share your data with are the problem.
It’s as if the milk industry were peeing in your milk, a law passed saying they could only do that with consent, and you complained of all the pee warnings being driven by regulation. I mean, technically the warning are only there because of regulation, but the law isn’t the thing to criticise there, the behaviour which lead to it is.
If you click on the Tab 'FRANCES CHANGED MY LIFE' it shows that band members John and Zoe have a daughter Frances. They're raising money to fund research into Frances' rare neurological disease: "Frances has a rare genetic mutation that causes a degenerative disease called DHDDS. In the last few years, breakthroughs in medical science have made it possible to develop a treatment. Unfortunately, it's extremely expensi…