TIP: Click on subject to list as thread! ANSI
echo: public_domain
to: Paul Edwards
from: Paul Markham
date: 1994-02-20 23:09:02
subject: how far do databases go

PE> I was thinking, you could actually use SQL to read the *.PKT format too,

 PE> couldn't you?  Sure, it's yet another "database" format,
but whether it's

 PE> dBase, Clipper, Jam, Squish, *.MSG, *.PKT, they're all just database

 PE> formats right, and if you want to convert from one to the other, you just

 PE> need to set up the interface to SQL properly, right?  BFN.



Yes, you can consider any file format as a database and write an SQL engine
to retrieve the data.



There's no reason why you couldn't write an SQL engine that knows how to
read and write various formats.



One thing you'll need to take into account: you need some sort of data
dictionary to specify what fields are in the record and where they are. In
SQL you would just say "SELECT NAME, ADDRESS FROM USERS" and it
would figure out where the name and address fields are in the users table.





Paul



--- GoldED/2 2.42.G1114

* Origin: It's life Jim, but not as we know it (3:711/934.1)
SEEN-BY: 635/514 640/305 711/809 934
@PATH: 711/934

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.