9 ms·
Lotus 1-2-3
- tpmx 4y agoI got another stroke of luck, I found a third party printer driver on an old SUNET archive for the Siemens Highprint 7400. Remarkably, it had some ancient Codeview debugging data left in it. I quite like the anti-deletionists at the Academic Computer Club in Umeå, Sweden. I had a similar experience a while ago - they were only ones currently hosting a once (well, somewhat) ubiquitous file. https://ftp.sunet.se/ https://ftp.sunet.se/ SUNET is the name of the Swedish University NETwork. They operated ftp.sunet.se with a public archive starting 1990. In 2016 this academic computer club took over the hosting. They get the bandwidth from their university for free. Their machines are typically previous-gen donations from local companies. Oh, and the local university tends to cover the electricity costs as well. As well as the costs of the server room. Sysadmining the service is done by volunteers though.
- guestbest 4y agoOff topic, but the other day people were wondering why Microsoft did users stayed on the platform when operating systems like the Amiga, Mac and even NeXT existed and it was because the terminal user interface is good enough for many people. Great work by the author. I really like hearing about extending the lifespans of DOS applications.
- prometheus76 4y agoAnother reason is because the simple text-based interfaces and terminals are also much more responsive. Some people prefer a snappy response over constantly moving their hand between the keyboard and mouse.
- toast0 4y agoTypically, the TUIs are also really good at consistently handling input, so even when they do get behind in processing the input, you can keep typing, and it will buffer inputs and catch up. There's often an attention key which is not buffered, and will dump the input buffer and stop any operations in progress, in case something is stuck. Even if a GUI does buffer input, it's unusual for users to be comfortable clicking where the buttons will show up, before they do. More frequently, click processing is separate from whatever else, and early clicks (or taps) are ignored or directed elsewhere.
- bombcar 4y agoI remember watching clerks at Fry's Electronics I think it was - they had PCs with windows on them, but all they ran was some sort of terminal emulator to access the system mainframe or whatever. You could ask them for a pick slip for whatever, they'd turn around, ask your name, type everything in in seconds, and then turn to the next customer; the computer would slowly plug along through all the screens and then print out the slip. They knew all the commands that far ahead.
- toast0 4y agoYeah --- Fry's used to be all real terminals, but I guess they ran out of equipment, so they ran a terminal emulator in Windows instead (almost always full screen, but modal popups from the printer? would break it out so you could see it was Windows). And the sales and returns terminals were usually setup so you could see them work. Cash registers were under the same system, but you usually couldn't see those. Word on the street was one of the Fry brothers had written that system, I think the server was a PC in the store somewhere (they did have some ability to check other store inventory, but I don't know how realtime that was) Airline service desks and vehicle/driver licensing are also popular places to have a well developed TUI along with experienced operators that will queue up a large buffer of inputs.
- bombcar 4y agoAt a company years ago we had a GUI that worked "well enough" but the dirty secret was it just sent keystrokes to an older TUI program that the C-level had decided was "too old looking and slow". A TUI isn't that far from an actual API, after all.
- xp84 4y agoIt always warms my heart to see these classic TUIs on a screen at a place like an airline service desk or a store. (Same as the non-IP Nortel Norstar phone systems that are 25 years old but still work that are in most supermarkets and department stores)
- masfuerte 4y ago
- kjellsbells 4y agoThis is massively important, especially for line of business apps or tools that the user touches hundreds pf times a day. GUIs are great when there are multiple, equally likely paths that the user could take. But LOB apps tend not to be like that: there is a mainline path (or very small number of paths) that dominates all others, and apps that let the user keystroke/tab/enter their way through these hot paths are waaaay fast. For US people, look at how fast the employee in your local Costco can look you up on their ancient-looking text app. You can do this in a GUI, or at least, you could in native apps, to some extent, with a series of tab presses to traverse the interface, and in the peak VB5 era this wast kinda ok, but not great, and webapps are a hot mess for this use case. If I'm shopping for flights, a gui webapp is great: lots of paths are valid, and i can poke around. If I'm a gate agent looking for the last seat on the plane out of O'Hare, I want speed.
- bombcar 4y agoPeople forget that back in the days of Dos and early MacOS, people rarely switched - the waves were new people coming into the market that would often sway which was burning up the world. Software was expensive back then, too, many hundreds of dollars that you really really wanted to keep running.
- hnlmorg 4y agoThe way I remember it was that people often did use other platforms but Microsoft won largely because IBM lost control of the PC market allowing for hundreds of cheap clones. It wasn’t until the mid 90s when PCs started to feel like the more capable platform. It’s also worth noting that there is a reason Microsoft offers heavy subsidies for education: it’s because if you indoctrinate people into your platform early on then they’re likely to keep buying your platform for years to come because change is scary. Edit: just to add some context, this is the point of view from England. Sounds like Apple had (and possibly still has?) a bigger presence in schools in the US. Whereas over here Apple machines were relatively uncommon compared to many of their counterparts.
- bombcar 4y agoWhich was funny to me because it wasn't until well past 2000 that any of my educational systems were Windows; grade school was Apple IIs and early Macs (one was color!) and high school had higher end Macs. Cheap clones able to run 1-2-3 was a big part of it, but the real lightning bolt for everyone I knew was Windows 95 and the Internet. And most of the kids I knew would push their parents towards the Windows for the games.
- hnlmorg 4y agoIn U.K. it was really common for people to have 8-bit micros even into the late 80s. Typically Amstrad and Commodores (with machines from Sinclair before that) while schools had BBC Micros (from Acorn). Though there was a plethora of machines around at that time that most people have since forgotten about, like the Dragon 32 / 64. Europe, and the U.K. particularly, had a really strong computer hardware industry in those days. In fact France has the Minitel which is itself a really fascinating technology and shaped early French computing trends in a differ way to England and USA too. Going back to the U.K., you’d see a few people, usually people with a little more money, but Atari or Amiga machines but more often people jumped from C64 or Amstrad CPC micro computers to IBM-compatible PCs. There definitely were people who had an Apple Mac, but it wasn’t the norm where I lived. Showing my age a little here, but my high school still ran Windows 3.x (I don’t think it was even 3.1. Pretty sure it was 3.0 on 286s). It was all Microsoft Office too. I ran Lotus at home but Microsoft Word and Excel had already conquered the schools, at least from what I saw. But we had Corel Draw instead of PowerPoint. Not sure why. Maybe PowerPoint hadn’t been released yet?
- cameldrv 4y agoAnd price, and gobs of network effects. Macs were much more expensive than PCs, and if you were working in an office with multiple computers, being the only one with a mac was a huge pain in ways that don't matter today. The main way to transfer files in the 80s was floppy disks. Most PCs in the 80s had only 5.25" floppies, and Macs had 3.5". Even if you had a 3.5" drive though on your PC, the Mac had a much different format. There was some software that let you read Mac disks on a PC, but it was somewhat flakey, and then you were left with the fact that the base file format on the Mac with resource and data forks was much different, and then of course you were probably using different spreadsheet and word processing software. Overall it was just barely possible to share files if you really worked at it. What you tended to see was that most everyone used PCs except certain industries/jobs that needed the graphical capabilities of the Mac. For example, if you were in a newsroom, everyone would be using Macs because there really wasn't good desktop publishing software for the PC until about the early nineties. The Amiga had a niche in video production because there really wasn't anything comparable to the video toaster for the Mac or PC until much later. You'd also see various types of workstations used for CAD, and in the nineties, SGI was the only game in town for high end 3D graphics. Hardly anyone bought a NeXT because they were so expensive and therefore didn't have enough software. They were pretty good for rapidly developing GUI software though, so there were a few companies, specifically banks, that used some of them for internally developed software.
- Paul-Craft 4y ago> Hardly anyone bought a NeXT because they were so expensive and therefore didn't have enough software. They were pretty good for rapidly developing GUI software though, so there were a few companies, specifically banks, that used some of them for internally developed software. Famously, id Software also developed Doom on NeXTSTEP. https://doomwiki.org/wiki/NEXTSTEP https://doomwiki.org/wiki/NEXTSTEP
- cameldrv 4y agoAlso the original web browser, WorldWideWeb was on NeXT, but hardly anyone used it because hardly anyone had a NeXT.
- santoshalper 4y agoI think it was a couple of things: 1. GUIs were mostly pretty terrible back then. Yes, even on a Mac. You can't tell from screenshots, but GUIs were incredibly slow and clunky for daily use. 2. Clone PCs were much more affordable at a time when the cost of a computer was very high relative to now. When adjusting for inflation, a decent computer then would be $7,000-$8,000 in 2023 dollars.
- DerekL 4y agoOthers have mentioned the ways that DOS was good enough or even better for some applications. One of the main strengths of a GUI wasn't being graphical, it was that every program had a similar interface. If your work just uses one program, DOS wasn't bad. But remember that the people who use computers aren't the people buying those computers. They're purchased by the boss, and the boss isn't going to spend a single dollar for a better user experience, much less the hundreds or thousands it would have cost. This still applies today to enterprise software.
- jasim 4y agoCan anyone explain the deep nostalgia and longing for old DOS era software, and in particular VGA text mode interfaces? I love staring at these screenshots and spinning up a DOSBox every now and then and going thru 1-2-3, FoxPro, WordStar and so on. I don't know what I'm looking for from them, does anyone else have a clue?
- bombcar 4y agoIt's a limited interface (80x25, 16 or 256 colors) and major companies spend millions of dollars over 20+ years perfecting the interface for those things. They were top tier and felt humanly understandable.
- xp84 4y agoTo illustrate: In a DOS or terminal interface, a date field usually expected a certain format, made that format obvious in the UI, and you'd type the date with probably 6 keystrokes (numbers) (and it'd probably jump the focus right to the next field if you needed to enter more). And likewise, good software would find a reasonable way to fit everything possible on one screen. With 'modern' web-based business software, most of them implement a date field with a pop-up mousing widget. You may or may not be "allowed" to type at all, or it may not be obvious how to, and you might need 47 mouse clicks and 15 seconds to enter a DOB in the 1970s. And screens are usually not laid carefully out at all, so even with small amounts of info on the screen, there may be plenty of whitespace, necessitating scrolling back and forth constantly. A phone number field, likewise, may throw errors for using or not using the "expected" punctuation. Etc. Stuff like that would be considered an absolute failure in the old text interfaces but it's the norm now that UIs are clunky and inefficient. PS: None of this would be difficult in the web stack, it seems like the "UI/UX" designers (when they even exist) care exclusively about aesthetics.
- guessbest 4y agoDOS or more specifically MS-DOS was the platform on which the TUI, terminal user interface, applications ran. Because MS-DOS lacked universal drivers for printers and networking as well as being single tasking, it was up to vendors to provide the printer drivers, network stack as well as TSR, Terminate-and-stay-resident, programs to allow switching between applications. For most people a computer was just a function of their job and not a career, so using a single tasking program to edit a spreadsheet and sending it to someone on portable storage like a 3.5" floppy drive seemed normal. Most meetings were in person and rarely did meetings happen over group calls. MS-DOS represents that world for the majority of people working with computers in the 80's. Also, there was smoking indoors.
- qingcharles 4y agoThis man is doing God's work. Bless him.
- josteink 4y agoThis is the most amazing hacker story I’ve read in a good while. Can’t wait to hear how this ends up eventually!
- bombcar 4y agoSpeaking of Lotus 1-2-3, the best computer I have ever owned was the HP 200 LX Palmtop - https://www.palmtoppaper.com https://www.palmtoppaper.com It was about the size of a graphing calculator, and ran MS-DOS 5.0 with a black and white CGA display, and had Lotus 1-2-3 and rudimentary task-switching. Simply phenomenal for 1994. Nothing has ever really come close; maybe someday I'll modify one so I can use the keyboard and replace the screen with a modern phone.
- GeorgeTirebiter 4y agoBeat me to it! ;-) I continue to use my (three!) HP 200 LXs in different parts of my lab for different reasons. The most 1-2-3 stuff is for analyzing S Parameters and other RF tasks (conversions, ratios, formulas, Smith Charts). Two AA batteries power it for a least a month; you could recharge NiMH with the built-in charger if you wanted. I use the PCMCIA card slot to hold a battery-backed SRAM, allowing complete backup (via automatic macros) of the entire machine (dead main batteries are not killers, here in the pre-FLASH world). And, the comm -- you can plug a special cable in to get 115,200 serial port. And you have IrDA --- I wrote the very first IrDA-compatible 'stack' on that machine (and at the time sold compatible discrete IrDA HW, so you could attach to another end, e.g. a PC). Sorry to highjack a 1-2-3 thread with praise for the HP 200 LX, but that was (is) one HELL of an awesome machine, still in use in my lab to this day.
- sanqui 4y agoI don't use my HP 200LX much, but one of the reasons is definitely the constant risk of data loss. Are those backup macros available anywhere?
- bombcar 4y agoThey're probably somewhere in the archives of https://www.palmtoppaper.com https://www.palmtoppaper.com The simplest ones were just batch files that copied things around.
- thelastparadise 4y ago
- russnewcomer 4y agoSomewhere between 2010 and 2012 when doing small business IT support, for a client, I spent some time installing 1-2-3 on an old, mostly disused machine in a corner of their office, then connecting to the machine via LogMeIn on an iPad (I think DosBOX because it better supported something on LogMeIn, I honestly don't remember why not CMD.EXE) so that this customer, a medium sized construction sub-contractor, could continue to use the 1-2-3 based estimation spreadsheet that had been developed in the early (yes, early, it might have been converted from visicalc) 80s. I offered to instead convert it to Excel since it wasn't really that complicated, but the response was basically "That's probably better, but I've been doing this since the 70s and I'm going to retire soon, I don't want to learn more new things that I don't care about instead of getting jobs done as fast as possible." It's not that 1-2-3 or a TUI was better, but that if you know it and you don't care about it, you care about it. Worse is better. And so it goes with apologies to Mr. Richard Gabriel, but that experience helped me more deeply understand what software should do is do important things for people, not do things better.
- thisgoodlife 4y agoIf I were the customer, I’d reject your proposal too. The old software has been working fine for 40 years, why would I want to find someone to rewrite it?
- jandrese 4y agoIn this case it would be to prepare for the inevitable death of the last machine in the office that can actually run it.
- icedchai 4y agoWith emulation, it can run forever.
- squarefoot 4y agoAnd faster, safer and future proof. I wouldn't be surprised at all if most 30+ years old software ran better on modern machines under a VM than say on 15 years old hardware without emulation.
- squalo 4y agoMurdered by IBM (I've been murdered)
- KMnO4 4y agoI’m too young for Lotus 1-2-3. Or at least, I should have been. I worked at a factory in 2011 that still used Lotus on their ancient dinosaur because why fix what wasn’t broken? The task was mostly just to record the values measured from a QC device in a spreadsheet, and print out a report for each batch. Since the computer didn’t have USB, printing involved saving the PDF to a floppy disk, running it across the factory to the printer, and inserting it into a USB-Floppy reader connected directly to the modern office printer. Honestly, I was really impressed by how functional Lotus was for such old software. The majority of tasks I was used to in modern Excel were doable in 1-2-3, and it could even do several things that still aren’t possible on Google Sheets.
- aleph_minus_one 4y ago> The majority of tasks I was used to in modern Excel were doable in 1-2-3 Work for a few years in the finance or insurance industry, and this opinion of yours will likely change: people in these industries have a tendency to (ab)use functionalities of modern Excel a lot. :-)
- yjftsjthsd-h 4y agoSo that's another point in favor of 1-2-3;)
- chasil 4y agoIIRC, Excel implemented the 1-2-3 keyboard menu for a time. The Windows port of 1-2-3 certainly did.
- phoe-krk 4y agoLotus 1-2-3 was on the frontpage six days ago[0]; this is a different article, about a new rendering driver for it, supporting larger terminals! [0] https://news.ycombinator.com/item?id=35807639 https://news.ycombinator.com/item?id=35807639
- helloooooooo 4y agoSame author though, Tavis Ormandy.
- dang 4y agoThanks! Macroexpanded: Lotus 1-2-3 for Linux - https://news.ycombinator.com/item?id=35807639 https://news.ycombinator.com/item?id=35807639 - May 2023 (73 comments) Also related: Original killer PC spreadsheet Lotus 1-2-3 now runs on Linux natively - https://news.ycombinator.com/item?id=31583982 https://news.ycombinator.com/item?id=31583982 - June 2022 (1 comment) Lotus 1-2-3 For Linux - https://news.ycombinator.com/item?id=31455968 https://news.ycombinator.com/item?id=31455968 - May 2022 (83 comments) Lotus 1-2-3 arbitrary resolution - https://news.ycombinator.com/item?id=26316637 https://news.ycombinator.com/item?id=26316637 - March 2021 (123 comments) Lotus 1-2-3 DOS Development Encyclopedia - https://news.ycombinator.com/item?id=26312681 https://news.ycombinator.com/item?id=26312681 - March 2021 (1 comment) Lotus 1-2-3 - https://news.ycombinator.com/item?id=26304542 https://news.ycombinator.com/item?id=26304542 - March 2021 (1 comment) Rediscovering Lotus Agenda (MS-DOS, 1989) - https://news.ycombinator.com/item?id=24862343 https://news.ycombinator.com/item?id=24862343 - Oct 2020 (11 comments)
- hggh 4y agohttps://hn.algolia.com/?q=https%3A%2F%2Flock.cmpxchg8b.com%2Flotus123.html https://hn.algolia.com/?q=https%3A%2F%2Flock.cmpxchg8b.com%2...
- joecool1029 4y agoI added it to the Gentoo GURU overlay (still pending on dev branch). Will fit along with DBF/libdbf as formerly common 90's software available to install. EDIT: Oh wait, this is lotusdrv. I haven't added that yet. Added the previously discussed linux native version of lotus123r3.
- jpcosta 4y agoThis is fascinating, but at the same time I got to ask. Wouldn't it easier for a person as experienced as Tavis Ormandy to simply write a console version of a spreadsheet software from scratch using a modern stack?
- bombcar 4y agoYes and no - 1-2-3 is an extensively advanced piece of software that took thousands of man hours to get where it was. You could write 20% of it in a few days, maybe 50% in a month, but that last bit would take … thousands of man hours.
- yazantapuz 4y agoYes, but the result won't be as polished as 1-2-3 or QP, both of which have tons of developer time behind).
- jedberg 4y agoI assume the OP likes working in the terminal because like working with a keyboard. If that's the case, they could use the old Windows version of 1-2-3, which was optimized for terminal users by allowing all the old slash commands, but can use the full screen. They could even use an old Windows version of Excel, which also supported the Lotus slash commands, to help transition users over.
- banana_giraffe 4y agoRandom trivia: Excel still uses "/" to bring up menu. At some point the shortcuts for "Alt" and "/" converged to Excel specific shortcuts, but my fingers still use "/" for whatever reason.
- chx 4y agoNote the author. This is Tavis Ormandy, of Google Project Zero fame.
- fsckboy 4y agoatm I can't seem to find that lotus ftp site he mentions, but it was mirrored by archive.org https://archive.org/details/2012_11_24_ftp_lotus_com https://archive.org/details/2012_11_24_ftp_lotus_com
- jmmv 4y agoI don’t remember Lotus 1-2-3 much, but WordPerfect 5.1 was glorious. I wonder if there is something similar to it today? (I’m happy with Markdown and Emacs, but it’s not the same.) Also, its “reveal codes” feature (or whatever it was called) made understanding HTML later on trivial.
- gadders 4y agoLotus 1-2-3 did also have a wysiwyg mode. That might have given him more columns.
- wkat4242 4y agoI'm surprised he uses the DOS version here? Of course that has limited text resolution support. This is the same guy that manages the Linux ports of the old Unix version. Why not use that?