News for hackers. Stuff that matters.
Re:SQLite 3.7.16 Released by ericcholis on Tuesday March 19, 2013 @09:03AM (#5400582)
Coming from the FoxPro days, I'm a huge fan of SQLite.
Re:SQLite 3.7.16 Released by JohnBooty on Tuesday March 19, 2013 @10:16AM (#5400969)
I didn't imagine I'd ever see FoxPro mentioned on Hacker News. That's like seeing... a Gnome vs. KDE debate on a FoxPro forum.
Re:SQLite 3.7.16 Released by malkia on Tuesday March 19, 2013 @10:28AM (#5401053)
I had an exam in Ashton Tate's dBase in the last year at my high school (this was a special mathematical high school in Bulgaria, every big city had one such school or more)
Re:SQLite 3.7.16 Released by Sami_Lehtinen on Tuesday March 19, 2013 @11:00AM (#5401254)
What about Clipper and dB3?
Re:SQLite 3.7.16 Released by bsg75 on Tuesday March 19, 2013 @01:01PM (#5402091)
Started my career on dBase II, then III, then Paradox, then Foxpro (and VFP). Eventually on to DB2/2 (OS/2), Sybase, MSSQL, now all PostgreSQL.

The FoxPro / xBase market was very nice to me for about 6 years. I am happily surprised to see this still exists: http://www.dbase.com/

Re:SQLite 3.7.16 Released by protomyth on Tuesday March 19, 2013 @03:15PM (#5402941)
At my first job, I had a foxbase database (government built), Turbo C 2.01 (make sure to patch the FP), and a Postscript printer. We needed some reports and graphs to satisfy other agencies, what fun.
Re:SQLite 3.7.16 Released by daliusd on Tuesday March 19, 2013 @09:23AM (#5400684)
No idea what's FoxPro, but I'm huge fan of SQLite as well.

The only complain (not sure to whom) I have is that WebSQL have not got proper attention because SQLite is the only solution.

Re:SQLite 3.7.16 Released by pmelendez on Tuesday March 19, 2013 @09:27AM (#5400713)
Re:SQLite 3.7.16 Released by genwin on Tuesday March 19, 2013 @01:02PM (#5402102)
Thanks for the blast from the past! FoxPro was leading edge in its time. I'm also a fan of SQLite; it works great for my website. Who needs bigger iron (on a single machine anyway) when SQLite can insert a million+ rows a second?
Re:SQLite 3.7.16 Released by snaky on Tuesday March 19, 2013 @03:14PM (#5402935)
FoxPro 2.0/DOS was really disruptive product back then. And it was addictive. My academic advisor used to using FoxPro as his primary text editor.

But real guys preferred Clipper due the advanced abilities such as eval.

Re:SQLite 3.7.16 Released by timjahn on Tuesday March 19, 2013 @04:27PM (#5403393)
I used to use it as a local database for desktop (and CD-ROM based) Windows apps I created with Flash, wrapped in a SWFStudio wrapper. :)
Re:SQLite 3.7.16 Released by pmelendez on Tuesday March 19, 2013 @09:26AM (#5400707)
I am curious... why do you find sqlite similar to FoxPro? I thought the inner engines were quite different
Re:SQLite 3.7.16 Released by ericcholis on Tuesday March 19, 2013 @09:51AM (#5400845)
Actually, rather similar. Visual FoxPro used SQL syntax for large majority of it's database and free table operations. Some commands were slightly different, and allowed you to use VFP specific commands in them. But, transitioning a VFP app to use a SQL backend was relatively simple.

Actually, my shop still runs a few VFP tasks that connect to various MySQL backends as well as JSON API services.

Side note, there is a very useful Python library for working with VFP xBase (.dbf) tables: https://pypi.python.org/pypi/dbf

Re:SQLite 3.7.16 Released by meepmorp on Tuesday March 19, 2013 @02:22PM (#5402639)
I thought you meant real FoxPro - like 2.x for DOS/Unix.

Now, that was a desktop database development system. Lightning fast, portable between SCO and DOS, easy to work with. Made clipper and dBase look like pokey hunks of poop in comparison. That and netware 3.12, plus some low powered machines with token ring cards for clients - golden days, I tell you.