5 ms·

> A lot of classic software essentially worked more like a database. In the last 10-15 years it's all moving to an algorithm. You just described what I missed

> A lot of classic software essentially worked more like a database. In the last 10-15 years it's all moving to an algorithm. You just described what I missed about the older software. Older software gives users control over sorting and show data in a tabular format. Modern software sorts data with an algorithm, with ads mixed in, and shows data in a card format, making it a lot less usable.

TeMPOraL 2y ago
Exactly. My related observation: half of the SaaS products I see would be more useful and ergonomic for the user if they were implemented as an Excel sheet. (I actually worked for one of such "better off as an .xls file" startup in the past, and its main competitor was an incumbent that sold the same stuff as an Excel extension. Trying to replace that with a React app is not a worthwhile use of life.) Algorithms are fine. I'll happily apply the most advanced ones I can get. The problem is with who applies them to what - as you and GP said, it's about user control - or, currently, lack of.
- llm_trw 2y ago
  Excel is great until it you need to do something that takes up more space than a single screen. Then it isn't. Sending sqlite databases to the users which they can interact with using both sql and a viewer is where it's at.
  - jkaplowitz 2y ago
    I wonder if being a more powerful backing data store for Excel is one of the remaining reasonable uses for Microsoft Access, at least for users of the Windows desktop version of Office? Access is still included in many editions of that (although not on Mac or web or mobile). Officially it’s even still supported and not deprecated, although of course it’s very much not emphasized by MS any more. Other options might be SQL Server Express or SQL Server Express LocalDB, the latter of which seems conceptually very much like SQLite within the MS ecosystem, and both of which are usable for production purposes at no cost within the technical limitations that differentiate them from paid editions.
- samarthr1 2y ago
  The SaaS I am now working for is a react app + some fancy intelligence. We are not front-end people, so the app is built with the expectation that people will be doing their filtering, searching and using the intelligence we provide, but in their home turf (excel). Our app also lets users "track" certain events, and we do not use push notifications, rather we respect our user's attention and email them a short summary, and link to a csv that they can use!
brookst 2y ago
> Older software gives users control over sorting and show data in a tabular format I'm old and tend to agree, but I suspect this is similar to "you used to have a knob on the TV that showed the channel it's on".
- watwut 2y ago
  Not every change is for the better. You gotta admit that TVs used to be able to switch channels much faster then they do now. And analogue controls in cars are safer and better then touch screens for everything. A lot of change is for the better, but quite a lot is a regression.
  - brookst 2y ago
    "Better" and "regression" are purely subjective. I have access to around 1000 "channels", if you include live broadcasts and network-like apps. How exactly were old TVs better at helping navigate that?
    - kedean 2y ago
      Modern TV interfaces are way better at navigating 1000 channels, but whether or not having 1000 channels available through one TV interface is highly debatable. It's also not a given that the current way most TVs use is anywhere close to the optimal one (especially when you have multiple devices that all have to work together because the cable provider insists on their own box, made even worse when a helpful family member installs a sound system with its own dedicated remote).
    - PaulHoule 2y ago
      For one thing, the clicker seems to work instantly for analog TV because it will sync up on the next frame, which is 0.03 sec which is less than the 0.2 sec it takes the human mind to perceive two events as two different events. With digital broadcast TV and cable whenever you switch to a different carrier there is a long delay (at least 0.5 sec) for the radio and the rest of the processing train to sync up. With streaming you have to do multiple network round trips to establish a stream. Either way you don't have the immediacy that old TVs had. The question of UI in modern TV is interesting. 15 years ago the 500 channel problem looked difficult, my impression was that Comcast Xfinity (2010) was the first really good STB interface for the digital age. I have a NVIDIA Shield which has an Android TV interface that convincingly makes FAST services like Pluto, Plex and Tubi look like linear TV on an STB. What you find though is that going "back" from one of those channels can put you, disorientingly, in the app for those channels, and also that you can usually navigate better if you start out with the FAST app (and have a more consistent experience watching FAST on a computer, tablet or XBOX) Except for those things which, for some reason, are easy to find in Android TV but hard in the app.

TeMPOraL 2y ago

Exactly. My related observation: half of the SaaS products I see would be more useful and ergonomic for the user if they were implemented as an Excel sheet. (I actually worked for one of such "better off as an .xls file" startup in the past, and its main competitor was an incumbent that sold the same stuff as an Excel extension. Trying to replace that with a React app is not a worthwhile use of life.) Algorithms are fine. I'll happily apply the most advanced ones I can get. The problem is with who applies them to what - as you and GP said, it's about user control - or, currently, lack of.

llm_trw 2y ago
Excel is great until it you need to do something that takes up more space than a single screen. Then it isn't. Sending sqlite databases to the users which they can interact with using both sql and a viewer is where it's at.
- jkaplowitz 2y ago
  I wonder if being a more powerful backing data store for Excel is one of the remaining reasonable uses for Microsoft Access, at least for users of the Windows desktop version of Office? Access is still included in many editions of that (although not on Mac or web or mobile). Officially it’s even still supported and not deprecated, although of course it’s very much not emphasized by MS any more. Other options might be SQL Server Express or SQL Server Express LocalDB, the latter of which seems conceptually very much like SQLite within the MS ecosystem, and both of which are usable for production purposes at no cost within the technical limitations that differentiate them from paid editions.
samarthr1 2y ago
The SaaS I am now working for is a react app + some fancy intelligence. We are not front-end people, so the app is built with the expectation that people will be doing their filtering, searching and using the intelligence we provide, but in their home turf (excel). Our app also lets users "track" certain events, and we do not use push notifications, rather we respect our user's attention and email them a short summary, and link to a csv that they can use!

brookst 2y ago

> Older software gives users control over sorting and show data in a tabular format I'm old and tend to agree, but I suspect this is similar to "you used to have a knob on the TV that showed the channel it's on".

watwut 2y ago
Not every change is for the better. You gotta admit that TVs used to be able to switch channels much faster then they do now. And analogue controls in cars are safer and better then touch screens for everything. A lot of change is for the better, but quite a lot is a regression.
- brookst 2y ago
  "Better" and "regression" are purely subjective. I have access to around 1000 "channels", if you include live broadcasts and network-like apps. How exactly were old TVs better at helping navigate that?
  - kedean 2y ago
    Modern TV interfaces are way better at navigating 1000 channels, but whether or not having 1000 channels available through one TV interface is highly debatable. It's also not a given that the current way most TVs use is anywhere close to the optimal one (especially when you have multiple devices that all have to work together because the cable provider insists on their own box, made even worse when a helpful family member installs a sound system with its own dedicated remote).
  - PaulHoule 2y ago
    For one thing, the clicker seems to work instantly for analog TV because it will sync up on the next frame, which is 0.03 sec which is less than the 0.2 sec it takes the human mind to perceive two events as two different events. With digital broadcast TV and cable whenever you switch to a different carrier there is a long delay (at least 0.5 sec) for the radio and the rest of the processing train to sync up. With streaming you have to do multiple network round trips to establish a stream. Either way you don't have the immediacy that old TVs had. The question of UI in modern TV is interesting. 15 years ago the 500 channel problem looked difficult, my impression was that Comcast Xfinity (2010) was the first really good STB interface for the digital age. I have a NVIDIA Shield which has an Android TV interface that convincingly makes FAST services like Pluto, Plex and Tubi look like linear TV on an STB. What you find though is that going "back" from one of those channels can put you, disorientingly, in the app for those channels, and also that you can usually navigate better if you start out with the FAST app (and have a more consistent experience watching FAST on a computer, tablet or XBOX) Except for those things which, for some reason, are easy to find in Android TV but hard in the app.