Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

I keep turning my Google Sheets into phone-friendly webapps

arstechnica.com

Post reply on HN
Print view View original

221–230 of 238 posts

Re: I keep turning my Google Sheets into phone-friendly webapps

#221

Post by sneak »

imchillyb wrote: post #205
sneak wrote: post #193

Earlier quoted context omitted.

Apple’s own transparency report indicates they turn over data to the USG for over 100,000 different apple IDs each year in the no-warrant-or-probable-cause (FISA orders and NSLs) category. (Mind you; this includes device location histories due to geoip logs, unique identifiers, iMessage histories, photos, documents, everything.) The cases they are allowed to tell you about aren’t in this category. They aren’t even al…

> ...no-warrant-or-probable-cause (FISA orders and NSLs)... These are not equivalents, nor are they similar. FISA = Foreign Intelligence Surveillance Court / NSL = National Security Letter. If a person is the target of the FISA system, there most certainly is probable cause. National Security Letter is a gag order, given by the intelligence community, in order to protect national security. Again, if you or your organ…

There is no probable cause required for FISA orders. They are routinely used illegally against americans.

This has been well documented in the press following the Snowden disclosures. It’s called FAA702 or PRISM.

Re: I keep turning my Google Sheets into phone-friendly webapps

#222

Post by sneak »

dragonwriter wrote: post #206
sneak wrote: post #193

Earlier quoted context omitted.

Apple’s own transparency report indicates they turn over data to the USG for over 100,000 different apple IDs each year in the no-warrant-or-probable-cause (FISA orders and NSLs) category. (Mind you; this includes device location histories due to geoip logs, unique identifiers, iMessage histories, photos, documents, everything.) The cases they are allowed to tell you about aren’t in this category. They aren’t even al…

> Apple’s own transparency report indicates they turn over data to the USG for over 100,000 different apple IDs each year in the no-warrant-or-probable-cause (FISA orders and NSLs) category. FISA “orders” are warrants and have the same requirement for probable cause as any search or seizure warrant (they aren't criminal warrants so the probable cause is not of there being evidence of a crime, but of the target being…

> FISA “orders” are warrants and have the same requirement for probable cause as any search or seizure warrant (they aren't criminal warrants so the probable cause is not of there being evidence of a crime, but of the target being an agent of a foreign power.)

You put orders in quotes, but that’s what they are called, because it is illegal and inaccurate to call them warrants, because warrants per 4A are issued only upon probable cause. FISA orders are warrantless and do not require probable cause.

Snowden was very clear when he released the data on FAA702. No probable cause is required. They are not warrants. There is nobody in the room except a government petitioner and a government judge who rubber stamps them.

They are the #1 most used source in the US IC, and they make it possible for the FBI and DHS et al to read all of your gmail, all of your google docs, and all of your iMessages and phone photos without so much as a shred of criminal wrongdoing.

The idea that they are used only for foreign surveillance is patently false. There is ample hard documentation (again, thanks to Snowden) that they routinely use these to spy on americans. Their twisted logic is that if the data is replicated outside of the US (to say, a datacenter in Europe) then they are legally permitted to access it under the way the unconstitutional FISA Amendments Act (Section 702) is written.

Re: I keep turning my Google Sheets into phone-friendly webapps

#223

Post by lwhi »

ajcp wrote: post #203
lwhi wrote: post #100

This is giving me flashbacks to the days when MS Access (and later on Visual Basic) ruled this segment of the market. It's interesting to think there's still a market for this type of small scale enthusiast application. One scenarios I've been thinking about recently is the death of the generic app. If LLMs end up being able to create software easily, why wouldn't we choose to have software that's totally aligned our…

Not just totally aligned, but also "just-in-time" and ephemeral: an LLM goes and does/builds it on request, and then destroys all artifacts when the request has been fulfilled? If the persistence of something incurs a cost in storage and security, and the traditional penalties of efficiency and learning-curves are removed, why not recreate it every time its needed?

I like this idea.

As an analogue to this; would each iteration adapt and evolve in the same way an organism might?

Re: I keep turning my Google Sheets into phone-friendly webapps

#224

Post by tmpz22 »

maxglute wrote: post #102
tmpz22 wrote: post #38

Earlier quoted context omitted.

I’ve been jotting them down in a standardized format in apple notes and using a regex to parse them into structured json for later analysis. For all the apps that are supposed to make this easier none of them do it right.

I'm doing something similar, incidentally in a wildly complicated google sheets + appscripts lot in google keep and copy paste, then sheet does rest https://imgur.com/a/xoHaxFY (3 images) notation is ColB, it'll generate relevant metrics, running total for some metrics like sets / INOL I also have onedit in sheet where if I put $$ anywhere it will calculate for the row if I have: ++5,10 it will generate warmups 5 rep…

My format is

MM/DD/YYYY (i.e. 1/1/2025)

$sets x $reps $weight $name (i.e. 3x10 135 Bench Press)

I uploaded the log file to ChatGPT and had it spit out a Python script to parse into JSON:

``` for line in file:

    date_match = re.match(r'^(\d{1,2}/\d{1,2}).\*?$', line.strip())
    if date_match:
        # construct a new workout entry 
        # continue

    exercise_match = re.match(r'^(\d+)x(\d+)\s+(\d+)\s+(.+)$', line.strip())
    if exercise_match:
        # insert new exercise into current workout
        # continue
```

Re: I keep turning my Google Sheets into phone-friendly webapps

#225

Post by tmpz22 »

fudged71 wrote: post #60
tmpz22 wrote: post #38

Earlier quoted context omitted.

I’ve been jotting them down in a standardized format in apple notes and using a regex to parse them into structured json for later analysis. For all the apps that are supposed to make this easier none of them do it right.

I’m verrrry interested in your regex!! Can you share? I’m interested in building a fitness ontology/terminology linked to a tokenizer and parser.

My format is

MM/DD/YYYY (i.e. 1/1/2025)

$sets x $reps $weight $name (i.e. 3x10 135 Bench Press)

I uploaded the log file to ChatGPT and had it spit out a Python script to parse into JSON:

``` for line in file:

    date_match = re.match(r'^(\d{1,2}/\d{1,2}).\*?$', line.strip())
    if date_match:
        # construct a new workout entry 
        # continue

    exercise_match = re.match(r'^(\d+)x(\d+)\s+(\d+)\s+(.+)$', line.strip())
    if exercise_match:
        # insert new exercise into current workout
        # continue
```

Re: I keep turning my Google Sheets into phone-friendly webapps

#226

Post by zie »

hliyan wrote: post #71
zie wrote: post #50

I tried going all on on Google Sheets earlier this year. I used the Python API and like almost nothing worked consistently. I got 1 sheet to work well with like 1k rows and thought woohoo this is great! So I went all-in, put 25k rows in and Google pooped the bed. It gave errors all the time, rows and columns were funky. API issues galore. SQLite however handled 25k rows without any errors, always rock solid. I gave u…

If you have more than a few thousand records, this is the wrong tool for the job. I've used Google Sheets as a "database" for a few applications in the past. In each case, it was an internal tool that did not generate more than a few thousand records, if that.

I guess? 25k rows with 10 columns shouldn't be a big deal. LibreOffice, Excel, Numbers, they all handled this data without trouble.

It is 99% static data, it would be updated maybe once a year if that. The point was to give users something they were familiar with to look at the data, search it, etc. While being in the "cloud" so I only had to update one place whenever I do get tasked with an update and to handle authn/z easily with no hassles.

Anyways, I used SQLite and a very simple web frontend(it had 3 screens: search, table view and record view). Solved the problem and moved on. Search just filtered the table view.

Re: I keep turning my Google Sheets into phone-friendly webapps

#227

Post by ezst »

jayd16 wrote: post #200
ezst wrote: post #149

Earlier quoted context omitted.

That... Sounds scary.

Accounting in a spreadsheet is scary?

Accounting of your holiday's expenses or hobby project? Sure. For a whole business and all the legal and practical obligation that entails? Nope. Not a chance. Just give me a proper accounting software so I don't have to second-guess myself at every turn as to whether my code or my interpretation of the law is correct.

Re: I keep turning my Google Sheets into phone-friendly webapps

#228

Post by ezst »

liontwist wrote: post #180
ezst wrote: post #154

Earlier quoted context omitted.

If I want a database set up in minutes just to focus on the business side and nothing else, I simply fire up a new Django project (I suspect any other framework with an ORM and auto-generated CRUD UIs would be equally competent for that). I have nothing against Google Sheets, I really haven't put much thought into it in this context, but I would need some convincing that it's a better and easier way to kick things of…

I like to just start with a SQLite UI editor. You can just query a database and work with the results directly . In a dynamic language like python there is little advantage to loading rows into classes. That Django query language is so painful and opaque.

Practically, Django's admin *becomes* the SQLite UI editor you are referring to, I suspect. Starting with it, the amount of UI code, backend code or SQL code to be written becomes a matter of how far you want to stretch the PoC in either direction (more effort on the views for a prettier/more unique front-end, more controller code for more business logic/cases covered, more database work to assess how the data model will scale).

Re: I keep turning my Google Sheets into phone-friendly webapps

#229

Post by liontwist »

ezst wrote: post #228
liontwist wrote: post #180

Earlier quoted context omitted.

I like to just start with a SQLite UI editor. You can just query a database and work with the results directly . In a dynamic language like python there is little advantage to loading rows into classes. That Django query language is so painful and opaque.

Practically, Django's admin *becomes* the SQLite UI editor you are referring to, I suspect. Starting with it, the amount of UI code, backend code or SQL code to be written becomes a matter of how far you want to stretch the PoC in either direction (more effort on the views for a prettier/more unique front-end, more controller code for more business logic/cases covered, more database work to assess how the data model…

I’m saying I prefer to design a database with sql, views, and native applications rather than python classes and web interfaces.

Re: I keep turning my Google Sheets into phone-friendly webapps

#230

Post by dragonwriter »

sneak wrote: post #222
dragonwriter wrote: post #206

Earlier quoted context omitted.

> Apple’s own transparency report indicates they turn over data to the USG for over 100,000 different apple IDs each year in the no-warrant-or-probable-cause (FISA orders and NSLs) category. FISA “orders” are warrants and have the same requirement for probable cause as any search or seizure warrant (they aren't criminal warrants so the probable cause is not of there being evidence of a crime, but of the target being…

> FISA “orders” are warrants and have the same requirement for probable cause as any search or seizure warrant (they aren't criminal warrants so the probable cause is not of there being evidence of a crime, but of the target being an agent of a foreign power.) You put orders in quotes, but that’s what they are called, because it is illegal and inaccurate to call them warrants, because warrants per 4A are issued only…

> You put orders in quotes, but that’s what they are called, because it is illegal and inaccurate to call them warrants, because warrants per 4A are issued only upon probable cause.

Orders authorizing foreign intelligence surveillance purposes under FISA are warrants, and are often called warrants, and they, like all warrants, are issued only on probable cause. (It is not improper to call them “orders”, and they are often referred to that way, as well, it is just less specific; all warrants are [court] orders, but not all court orders, much less all orders more generally, are warrants.)

https://bja.ojp.gov/program/it/privacy-civil-liberties/autho...:

—quote—

Subchapter I of FISA established procedures for the conduct of foreign intelligence surveillance and created the Foreign Intelligence Surveillance Court (FISC). The Department of Justice must apply to the FISC to obtain a warrant authorizing electronic surveillance of foreign agents. For targets that are U.S. persons (U.S. citizens, permanent resident aliens, and U.S. corporations), FISA requires heightened requirements in some instances.

* Unlike domestic criminal surveillance warrants issued under Title III of the Omnibus Crime Control and Safe Streets Act of 1968 (the “Wiretap Act”) , agents need to demonstrate probable cause to believe that the “target of the surveillance is a foreign power or agent of a foreign power,” that “a significant purpose” of the surveillance is to obtain “foreign intelligence information,” and that appropriate “minimization procedures” are in place. 50 U.S.C. § 1804.

* Agents do not need to demonstrate that commission of a crime is imminent.

* For purposes of FISA, agents of foreign powers include agents of foreign political organizations and groups engaged in international terrorism, as well as agents of foreign nations. 50 U.S.C. § 1801

—end-of-quote—

Post reply on HN