Author Topic: Do you remember "dBase" ??  (Read 7682 times)

0 Members and 1 Guest are viewing this topic.

Offline SeanB

  • Super Contributor
  • ***
  • Posts: 16272
  • Country: za
Re: Do you remember "dBase" ??
« Reply #25 on: December 09, 2017, 02:37:37 pm »
Sender is an older organisation, probably still using a mini or even an old mainframe, and the data export using a PC running DOS is the most modern method, other than getting a weekly pile of line printed wide format paper to enter the data from.
 

Offline bd139

  • Super Contributor
  • ***
  • Posts: 23018
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #26 on: December 09, 2017, 08:34:07 pm »
Yep spot on. I sent an email to our account manager earlier and got a reply. It's an AS/400 and a rackmount supermicro PC running FreeDOS that dumps data out via scraping 5250 and farts it out over zmodem to us. They never got the source code for it from the contractor and it's a MS PDS 7 program from the dark ages. Apparently they are going to replace it when they get rid of the AS400, so never because they paid out for two loads of outsourcers to try and rewrite their software in Java and it never worked.
 

Offline TK

  • Super Contributor
  • ***
  • Posts: 1722
  • Country: us
  • I am a Systems Analyst who plays with Electronics
Re: Do you remember "dBase" ??
« Reply #27 on: December 09, 2017, 09:27:11 pm »
I wrote a savings account application in dBase II (CP/M) for a small financing and travel agency company after high school, it helped me buy my first PC XT Clone without monitor (I had to hack a black and white TV to bypass the RF tuner and input directly composite video).  During college, I wrote and maintained another dBase II application (Patient record database) for a doctor, this time with MS-DOS and 20MB hard disk.  For maintenance I visited the doctor's office once a month to backup the information to floppy (long long hours to backup 20MB to a bunch of 5.25" diskettes).  On MS-DOS I used a TSR tool to design the screens of the application.  With this tool, I had the screens designed and resided outside the dBase II programs.  I don't remember the name of the tool...

dBase II gives me very good memories.  I restored a Kaypro II just to load dBase II from a CP/M machine.
 

Offline stj

  • Super Contributor
  • ***
  • Posts: 2153
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #28 on: December 10, 2017, 09:44:52 am »
Yep spot on. I sent an email to our account manager earlier and got a reply. It's an AS/400 and a rackmount supermicro PC running FreeDOS that dumps data out via scraping 5250 and farts it out over zmodem to us. They never got the source code for it from the contractor and it's a MS PDS 7 program from the dark ages. Apparently they are going to replace it when they get rid of the AS400, so never because they paid out for two loads of outsourcers to try and rewrite their software in Java and it never worked.

how big are the transfers??

a pie or mid-end Nucleo board could grab serial and repackage it for transmission over the net.
only curious.
they are better off with simple hardware running freedos than some 8core overheating spyware infested shit that needs sevicing every 6 months to see if the psu caps are leaking!!  >:D

i know a massive financial org that got a new it manager some years back, he binned all the ibm mini-computers running unix and spent 200,000 on quadcore dell machines w/support, and the same again on software licenses.
it took 2 years to get the junk actually running, and it still wont run aswell as the old stuff did. |O

why did he do it? because he was an M$ guy.
why does he STILL have his job? because he is from the small tribe we arent supposed to mention.
 

Offline rrinker

  • Super Contributor
  • ***
  • Posts: 2046
  • Country: us
Re: Do you remember "dBase" ??
« Reply #29 on: December 10, 2017, 05:19:01 pm »
Apple was blaming Microsoft for copying the idea of mouse, icons, windows, etc.  Ignoring the blatant fact that all the concepts came, fully-developed, from the Xerox Palo Alto Research Center (PARC).  Typical corporate jingoism which is something that Apple perfected.  Cue the Apple fanboys.

My employer uses a compulsory "nanny monitor" software on our PCs to monitor our computer use, keystrokes, and mouse movements.  And to enforce "micro-breaks" every 10 minutes and full breaks every hour or so. Complete with suggested exercises for desk-jockeys to prevent RSI (repetitive strain injury).  One of the suggestions is to learn the keyboard shortcuts to reduce use of the mouse.

 Funny you should mention the nanny monitor software. At one of my jobs, where my primary task was working on the FoxPro application that more or less ran the entire place, we purchased another company and it was determined that the fastest way to integrate their data with ours was to hire a bunch of temp works to actually key it all in. One of the other programmers (there were 3 of us) and I wrote up a double-blind data entry form that also tracked keystroke rates and error rates. The first night of this data entry, they had about 20 people all set up and keying away. Standard 80/20 rule revealed itself rather quickly, 20% of the people did 80% of the work. Second night they retained only 10 of the people, with no reduction in total number of entries completed.
 
 

Offline bd139

  • Super Contributor
  • ***
  • Posts: 23018
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #30 on: December 10, 2017, 07:39:26 pm »
Yep spot on. I sent an email to our account manager earlier and got a reply. It's an AS/400 and a rackmount supermicro PC running FreeDOS that dumps data out via scraping 5250 and farts it out over zmodem to us. They never got the source code for it from the contractor and it's a MS PDS 7 program from the dark ages. Apparently they are going to replace it when they get rid of the AS400, so never because they paid out for two loads of outsourcers to try and rewrite their software in Java and it never worked.

how big are the transfers??

a pie or mid-end Nucleo board could grab serial and repackage it for transmission over the net.
only curious.
they are better off with simple hardware running freedos than some 8core overheating spyware infested shit that needs sevicing every 6 months to see if the psu caps are leaking!!  >:D

i know a massive financial org that got a new it manager some years back, he binned all the ibm mini-computers running unix and spent 200,000 on quadcore dell machines w/support, and the same again on software licenses.
it took 2 years to get the junk actually running, and it still wont run aswell as the old stuff did. |O

why did he do it? because he was an M$ guy.
why does he STILL have his job? because he is from the small tribe we arent supposed to mention.

Transfers are about 200K. Hardly anything. It is plain text so that's a reasonable chunk of data.

I am just in the process of digging an MS partner out of the shite after they hit the performance wall and have just over 5.5 million lines of C# in one monolithic blob. They couldn't scale out due to shitty architecture and somewhat relied on the laws of physics being pushed hard to scale up. When you start spending £500k on SQL Server licenses you know you've fucked up somewhere. Slowly moving it all over to lots of little loosely coupled bits of software on Linux + postgresql + python + go + rabbitmq on AWS.
 

Offline Howardlong

  • Super Contributor
  • ***
  • Posts: 5315
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #31 on: December 10, 2017, 08:15:13 pm »
Microsoft pulled the rug from under the feet of many orgs by the way they remarketed and relicensed SQL Server Enterprise about three years ago. They’ve lost a lot of credibility from that, and they’ve had to recind a little by enabling some previously Enterprise features in the Standard edition. The damage has already been done though. SQL Server does scale, but you need expensive Enterprise fratures to achieve it. [My evidence is from rebuilding and re-engineering in execess of 300 SQL Server instances in the past couple of years, many downgrading from Enterprise to Standard].

Regarding still using dBase files, this sounds a bit like what Bernie Madoff got up to, keeping old systems for fear that upgrading them would reveal too much.

I remember Clipper and dBase very well. Microsoft buying out Foxpro was the next step in lineage and general business acceptance away from the big iron.
 

Offline bd139

  • Super Contributor
  • ***
  • Posts: 23018
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #32 on: December 10, 2017, 08:20:23 pm »
Yes this is one of those unfortunate companies who was screwed by the changes. I always warn people never to use any feature of their DBMS that aren’t portable as there’s no guarantee you’ll be able to afford them later or the product will scale with your business. This lot have CLR stored procedures, all sorts. Everything bad you could do they did it. Then again I’m being paid for them to ignore my advice so meh.
 

Offline DimitriP

  • Super Contributor
  • ***
  • Posts: 1288
  • Country: us
  • "Best practices" are best not practiced.© Dimitri
Re: Do you remember "dBase" ??
« Reply #33 on: December 10, 2017, 09:08:11 pm »
Quote
i know a massive financial org that got a new it manager some years back, he binned all the ibm mini-computers running unix and spent 200,000 on quadcore dell machines w/support, and the same again on software licenses.

So the "manager" has a brand new shiny paragraph on his resume for a "completed project", Dell got some $$$ out of the deal and so did M$.  Good the the economy, some  would call it a "win-win".
Yes that was sarcasm Sheldon.


Quote
it took 2 years to get the junk actually running, and it still wont run aswell as the old stuff did.
Yeah, but they are now running "new" stuff. New is always good. As for the users..they neither know or understand anything "IT" so  "f^ck 'em".

Quote
why did he do it? because he was an M$ guy.
M$ can be very convincing, in most cases the guy or gal gets to keep his/her job. The project becomes such a tangled mess that even if you got rid of them, you'll have a hard time finding somene else to take it on, without another round of "overhauling ie throwing out everyting that stands in their way so they can complete the project using their version and understanding  of "best practices" that are in effect that week.

Quote
because he is from the small tribe we arent supposed to mention
This one went over my head, I'm not up on on all PC puns :)
I don't  follow #inclusion on twitter either :)


   If three 100  Ohm resistors are connected in parallel, and in series with a 200 Ohm resistor, how many resistors do you have? 
 

Offline Howardlong

  • Super Contributor
  • ***
  • Posts: 5315
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #34 on: December 10, 2017, 10:18:33 pm »
Yes this is one of those unfortunate companies who was screwed by the changes. I always warn people never to use any feature of their DBMS that aren’t portable as there’s no guarantee you’ll be able to afford them later or the product will scale with your business. This lot have CLR stored procedures, all sorts. Everything bad you could do they did it. Then again I’m being paid for them to ignore my advice so meh.

Problem is that database agnostic almost certainly will be a compromise, usually in terms of performance. While I agree CLR should be avoided, for some low level procedural stuff such as tightly iterative or non-standard string manipulation operations it’s pretty much the only way to make it perform inside a set based database operation.

The use of CLR is much more a problem of maintenance in my experience. You need a reasonably switched on person who understands the nuts and bolts of both the database engine and C#, and why it makes sense in some very limited use cases. There are frustratingly very very few procedural coders these days who understand enough or even think about set based operations on databases and how they're likely to perform, but project managers think all coders can think in a set based way, but in my experience usually they can’t particularly when it comes to understanding why something runs slowly.

The problem domain remains largely the same as it’s always been though, get your algorithms right up front, unit test them on a representative dataset, and everything else should reasonably easily fall into place. With so much abstraction nowadays, the performance thing tends to be addressed when it’s too late. Coders nowadays increasingly think of everything as a magic black box and then blame everything on “network” or “database” when their projects don’t perform, rather than their algorithms.

The main difference now is that today’s massively distributed systems add further dimensions of complexity, security and indeterminism that simply weren’t there 20 years ago. So, as well as good algorithms, you need good technical architects, or systems designers and integrators as we used to call them.

 

Offline stj

  • Super Contributor
  • ***
  • Posts: 2153
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #35 on: December 11, 2017, 12:30:57 am »
the biggest problem i have seen is company's needing data convertors/formatters to bridge between applications.
so instead of employing a 16year old coder to write some scripts, they go to some expensive outsourcing agency.
they go to a programmer and get the software written in Dot.Java-Pro 6.5 or something,
then supply it to the company without the sourcecode at very high cost.

5 years later - well you know how it goes!!
 

Offline bd139

  • Super Contributor
  • ***
  • Posts: 23018
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #36 on: December 11, 2017, 12:48:02 am »
Yes this is one of those unfortunate companies who was screwed by the changes. I always warn people never to use any feature of their DBMS that aren’t portable as there’s no guarantee you’ll be able to afford them later or the product will scale with your business. This lot have CLR stored procedures, all sorts. Everything bad you could do they did it. Then again I’m being paid for them to ignore my advice so meh.

Problem is that database agnostic almost certainly will be a compromise, usually in terms of performance. While I agree CLR should be avoided, for some low level procedural stuff such as tightly iterative or non-standard string manipulation operations it’s pretty much the only way to make it perform inside a set based database operation.

The use of CLR is much more a problem of maintenance in my experience. You need a reasonably switched on person who understands the nuts and bolts of both the database engine and C#, and why it makes sense in some very limited use cases. There are frustratingly very very few procedural coders these days who understand enough or even think about set based operations on databases and how they're likely to perform, but project managers think all coders can think in a set based way, but in my experience usually they can’t particularly when it comes to understanding why something runs slowly.

The problem domain remains largely the same as it’s always been though, get your algorithms right up front, unit test them on a representative dataset, and everything else should reasonably easily fall into place. With so much abstraction nowadays, the performance thing tends to be addressed when it’s too late. Coders nowadays increasingly think of everything as a magic black box and then blame everything on “network” or “database” when their projects don’t perform, rather than their algorithms.

The main difference now is that today’s massively distributed systems add further dimensions of complexity, security and indeterminism that simply weren’t there 20 years ago. So, as well as good algorithms, you need good technical architects, or systems designers and integrators as we used to call them.

Agree entirely. 

Especially about the lack of understanding. I throw people at Joe Celko's classic "SQL For Smarties" before they're allowed to touch our stuff. And then they get reviewed.

The cancer of any large MSFT stack though is the object-relational-mapper. This appears to turn into an adhoc 17-join table-scan filled cthulhu generator. Fusion IO made it shut up but that just made people assume that there was more juice to squeeze by ambling into a problem like a drunken zombie.
 

Offline Howardlong

  • Super Contributor
  • ***
  • Posts: 5315
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #37 on: December 11, 2017, 06:18:23 am »
ORM is of little practical use in enterprise scale databases, it’s that same black box mentality where you’re so abstracted from what’s really going on, you’ve lost control, and when it performs well it’s by luck rather than design. They’ve tried to relieve the developer having to know or think about how databases work.

You can throw RAM and tiered storage at he problem, but that’s just a sticking plaster. Hardware vendors love it. As before it’s down to those pesky technical designs and clever algorithms that will save you.

17 table joins written by a human who knows what they’re doing can be reasonable, as long as it is written in a readable and maintainable way, but it’s at the extreme end of what can be able to be written in a readable way. When it’s machine generated, all bets are off.

A company I worked with hit a 256 table join limit with a human-written query. This was the result of a utopian manager who thought everything should be set based with no procedural stuff. Of course, a 256+ table join is impossible to maintain, it’s completely unreadable, and guess what it doesn’t perform.

Nowadays I regularly deal with 60+ table joins from code generators, the result of well meaning designers and managers who’ve taken code re-use to a whole new level. Just to parse and compile these queries takes tens of seconds. I have to concoct manually manicured plan guides for each build and use case as they bolt on more stuff each build: plan guides are even less maintainable than crap queries. That effort in itself rather negates the whole purpose of code re-use.
 

Offline GlennSpriggTopic starter

  • Super Contributor
  • ***
  • Posts: 1259
  • Country: au
  • Medically retired Tech. Old School / re-learning !
Re: Do you remember "dBase" ??
« Reply #38 on: December 13, 2017, 01:06:58 pm »
We still have a client who sends us DBF files once a week. This is using zmodem on a 14.4k dialup.
No idea what the hell they are sending this from.  We dared not ask but they pay us a metric fuck ton of cash to keep this alive. Everyone else is using CSVs and SFTP.
We actually bought some Hayes modems off eBay incase the current one packs in.

Ha!!  :) .  I liked the "Metric F@#$ Ton of Cash" part....   :)
Not knowing what services your company offers, and the nature of the 'business' sending the data to you,
it would be hard to ascertain the reasoning behind their 'methodology'  :)
Maybe they are just 'Old-School' and like it that way. Maybe they think it is 'safer' that way, avoiding more modern 'norms'.

Interestingly, where I am, in Australia, (not completed Nationally yet), we are now on the new "A.B.N.", (Australian
Broadband Network), which is all new 'Fibre-To-The-Node' as a minimum. There are NO 'Land-Lines' as such, when on
this new fully digital system, and the 'equivalent' to a 'Land-Line' is the new Routers using something like 'V.O.I.P' !!!
So the OLD 'Dial-Up' Modems would instantly fail miserably now  :)

However, Aahhh.... don't you miss the 'Old' "Beep-beep-screech-beep-screech-screech" of the old analog 'Modems',
before they decide to 'handshake' with each other and then go mysteriously 'silent' as they continued to 'converse',
at a whopping 75 or 150 K-bits / sec... Sigh.  And the 'Voyager Space Probe sent an 'LP' Record for our Alien friends !!  :D

BUT... all this 'old' stuff still works in theory/practice, and was simple xxx, just lost now in the youthful hands of smartphones  :)
Diagonal of 1x1 square = Root-2. Ok.
Diagonal of 1x1x1 cube = Root-3 !!!  Beautiful !!
 

Offline shawty

  • Regular Contributor
  • *
  • Posts: 90
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #39 on: December 13, 2017, 03:48:59 pm »
Oh boy do I remember dBase :-)

First DB I ever used when I first started at college.

I hear all the MS arguments and such above now though, even if most of the work I do these days is M$ orientated.

That said, where possible, these days I try to persuade people to use PostgreSQL, which if anyone knows their DB history is actually the Farther of MS-SQL server, in a weird sort of Darth Vader/Star wars way.

Another fact quite a lot of folks don't relise these days however, is the Ashton Tate DBF (dBase) file format still lives on.  Anyone who deals with a lot of GIS/Mapping data, will use DBF files every day, as the file format is used to hold column orientated "data attributes" in the ESRI Shape file format.  If you download any SHP file archive from the internet, you'll find inside an SHP file, a DBF file and usually a PRJ and a few others.

The SHP holds the geographic points data, the DBF holds the attributes table, and the others are all just meta data with stuff like Projection system definitions and such like in.

It was without doubt though a hell of a database in it's time.  Iv'e probably still got a copy in one of my many boxes of floppy disks up int he loft.


Meh....
 
The following users thanked this post: GlennSprigg

Offline woody

  • Frequent Contributor
  • **
  • Posts: 290
  • Country: nl
Re: Do you remember "dBase" ??
« Reply #40 on: December 13, 2017, 04:00:41 pm »
Quote
However, Aahhh.... don't you miss the 'Old' "Beep-beep-screech-beep-screech-screech" of the old analog 'Modems',
before they decide to 'handshake' with each other and then go mysteriously 'silent' as they continued to 'converse',
at a whopping 75 or 150 K-bits / sec... Sigh.

BUT... all this 'old' stuff still works in theory/practice, and was simple xxx, just lost now in the youthful hands of smartphones  :)

Kill two birds with one stone and install the training sound as your ringtone. I did  8)
 
The following users thanked this post: GlennSprigg

Offline Howardlong

  • Super Contributor
  • ***
  • Posts: 5315
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #41 on: December 13, 2017, 05:20:51 pm »

That said, where possible, these days I try to persuade people to use PostgreSQL, which if anyone knows their DB history is actually the Farther of MS-SQL server, in a weird sort of Darth Vader/Star wars way.


Not sure I understand the reference here, SQL Server was originally a Sybase product, and MS and Sybase shared source code and co-developed it.

An anecdote I have from an acquaintance of mine who was one of the MS SQL Server devs at the time MS and Sybase parted ways around the mid 1990s, regards part of the agreement to share the final codebase. MS responded by supplying Sybase with a fully functional and compiling build, but with all the white space and comments removed. I can’t remember if they mangled identifiers too, I wouldn’t be surprised, that is (or at least was) the kind of mentality that pervaded in Microsoft at that time. They even awarded trophies internally for pinching third party IP, badges of honour if you like.
 

Offline bd139

  • Super Contributor
  • ***
  • Posts: 23018
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #42 on: December 13, 2017, 05:41:15 pm »
Indeed. Postgres was derived from Ingres, a product which I have had the misfortune of using. SPARCstation 2, 16Mb RAM, SunOS 4, swapping 100% of the time!
 

Offline boffin

  • Supporter
  • ****
  • Posts: 1027
  • Country: ca
Re: Do you remember "dBase" ??
« Reply #43 on: December 25, 2017, 01:15:17 am »
dBaseII on a CP/M system... (8" floppies and all...)
Yup, I remember
 

Offline shawty

  • Regular Contributor
  • *
  • Posts: 90
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #44 on: December 27, 2017, 04:09:23 pm »

That said, where possible, these days I try to persuade people to use PostgreSQL, which if anyone knows their DB history is actually the Farther of MS-SQL server, in a weird sort of Darth Vader/Star wars way.


Not sure I understand the reference here, SQL Server was originally a Sybase product, and MS and Sybase shared source code and co-developed it.

An anecdote I have from an acquaintance of mine who was one of the MS SQL Server devs at the time MS and Sybase parted ways around the mid 1990s, regards part of the agreement to share the final codebase. MS responded by supplying Sybase with a fully functional and compiling build, but with all the white space and comments removed. I can’t remember if they mangled identifiers too, I wouldn’t be surprised, that is (or at least was) the kind of mentality that pervaded in Microsoft at that time. They even awarded trophies internally for pinching third party IP, badges of honour if you like.

As bd139 pointed out, postgres derived from Ingres, and the code base for Sybase also came from Ingres, and since SQL Server came out of the Sybase code base, they both technically started off as Ingres.

However, the code that came from Ingres, that eventually became Postgres, didn't immediately become Postgres, it went through a few different itterations, some of which was forked back into Sybase, and ultimately made it into SQL Server.

So SQL Server is a product of Ingres=>Sybase=>SQL Server but also partly a product of Ingres=>PG97V1(Or what ever it was called)=>Sybase=>MS-SQL and also PG97V2 & V3 too, before all 3 products then went their ultimate final ways with Sybase becoming the base code for the ASX00 series of Database Servers, MS-SQL going off on it's own, and the early forked Ingress code bases, that fed back into Sybase, getting merged into what we now know as Postgres.

So Postgres is part brother and part farther to MS-SQL and for that matter Sybase too.

It hurts my head trying to think about it, I remember when I wrote my book on Postgres, that I had to speak to a number of members of the postgres team, to try and understand the DB's history, and it hurts their heads just as much as mine. :-)  (Hence the Darth Vader reference)

Meh....
 

Offline bd139

  • Super Contributor
  • ***
  • Posts: 23018
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #45 on: December 27, 2017, 05:16:39 pm »
Interesting history lesson that - thank you :)

 

Offline Howardlong

  • Super Contributor
  • ***
  • Posts: 5315
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #46 on: December 27, 2017, 07:54:49 pm »
Indeed, you live and learn. Just when you thought you knew everything about it: my SQL Server experience goes back to 1991, and apart for a couple of years here and there I’ve used it fairly intensively ever since.

I’m not sure how much Sybase is used these days, I haven’t touched it for about eight years or so. Never had the pleasure of Ingres or Postres, but have had to deal with Oracle in two intensive periods of my career, I never really gelled with Oracle, I found it very difficult when I’d spent so much time with one particular strain of database engine, you need to think very significantly differently in terms of physical configuration and deployment.
 

Offline bd139

  • Super Contributor
  • ***
  • Posts: 23018
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #47 on: December 27, 2017, 09:13:45 pm »
Very true. I’m a big fan of PostgreSQL. It just works out of the box with minimal tuning in most circumstances. SQL server is a close second. It’s amazing what you can throw at these.

One thing I am forever attempting to get our DBA team to do is start with default configuration and make changes only with measurable outcomes. We have a lot of voodoo cargo cutting going on. That is the only similarity between all database engines :)

I did a few years of oracle. Well to be precise, Oracle did a few years of me. Getting a working 8i install on HP/UX consumed about £50K of cash on consultancy and wall clock time. They run SQL Server now...

I’ve never seen a production sybase deployment. I have been assured that they do exist :)
 

Offline shawty

  • Regular Contributor
  • *
  • Posts: 90
  • Country: gb
Re: Do you remember "dBase" ??
« Reply #48 on: December 28, 2017, 12:38:59 am »
All sounds a bit like my Career too :-)

I used a LOT of Sybase & Ingress in my early career as a national infrastructure engineer for Orange UK.  Most of the back end databases  (Well in the billing and financial side anyway) where all running on IBM & HP-UX systems.

In the Network OPS trenches where I was stationed however, we had all sorts of weird and wonderful stuff, such as the MML Interface for the Nokia DX200 GSM Systems that interfaced directly to the Subscriber Location Registry and IMEI databases.

Once I left GSM however and started going more into pure software development, I came across mostly Oracle stuff in big enterprises, MS-SQL in Ms based enterprises (No surprise there) and MySql pretty much everywhere else.

Oracle, well I'd rather do damage to myself with a rusty spoon, than use that pile of ((*^(&*^()*& , MS-SQL, it's bearable, esp if your using dotnet, and MySql.... please for the love of god will someone just kill it :-)  kill it with fire....

Then I started doing a lot of GIS and Mapping work, and got introduced to Postgres, and that was it, it's my DB of choice where ever I can now, and for portable deployments, SQLite.

Both PG & SQLite can be configured to be simple features GIS specification Level 1, which essentially means if you have a GIS app that can run on Postgres+PostGis, then it should also run unmodified on SQlite+Spatialite.

And now with dotnetcore and the trully cross platform C# runtime, I also try to use Postgres on MS systems in preference to MS-SQL server, simply because I get the best of all worlds....
Meh....
 

Offline GlennSpriggTopic starter

  • Super Contributor
  • ***
  • Posts: 1259
  • Country: au
  • Medically retired Tech. Old School / re-learning !
Re: Do you remember "dBase" ??
« Reply #49 on: December 29, 2017, 01:16:15 pm »
Thank you ALL again.... for your myriad of interesting & very varied comments !
The main 'upshot' being that originally, things were a lot simpler, and simply worked !
And using MINISCULE resources, on the most basic of systems. Of course, 'we' need to
'progress', and expand/diversify from the 'old', as depicted in many of these responses.
However, even today, we should keep the Adage going...  "K.I.S.S." (Keep It Simple Stupid).
We seem to keep 'Reinventing-the-wheel', though in many languages  :)
Diagonal of 1x1 square = Root-2. Ok.
Diagonal of 1x1x1 cube = Root-3 !!!  Beautiful !!
 


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf