Gus Wirth wrote:
Michael O'Keefe wrote:
Gus Wirth wrote:
Michael O'Keefe wrote:
I'm moving my business to Kearny Villa Road in the coming months,
and Cox told me they don't have cable in that location, that it
belongs to TWC. TWC tells me they don't have cable to the building
coz it's cost prohibitive.
I currently have a 1.5Mb/768kb DSL service, but I was hoping to get
much more. So now I am looking for alternatives.
Though I prefer to be able to 'touch the HW', I'm not opposed to
either co-lo somewhere or a virtual machine setup somewhere. The
only problem with that is that I routinely (at least nightly)
convert our inventory management system from a Paradox DB on Windows
to mySQL on Linux so my website is up to date (as is possible) with
what we have in stock. I also run my own Postfix and BIND.
Yes, I could ZIP/scp or rsync the DB over to the colo/Xen machine
and then do the conversion (or just ship the .sql files - 6 of 1,
half-dozen of the other)
But for arguments sake, does anyone have any data solutions
suggestions?
TWC referred me to SkyRiver (in Poway I think they said) that did
LoS data. I haven't looked into them yet.
You could make your Paradox database go live with a handy little
database connector called DBTCP <http://www.fastflow.it/dbtcp>. I
have a warehouse down in Otay Mesa using this with a Paradox
database backend that runs the warehouse operations and a PHP script
with the connector running on Apache and Linux. I got the Paradox
ODBC connector from WordPerfect Office 2002. If you do that there is
no need to schlep data from Paradox to MySQL, and a reasonably
designed web site won't use up too much bandwidth.
I don't use up "too much" bandwidth, though I wouldn't mind having
that problem !
At the moment, apache generates, on avg, 32kbps (so munin tells me)
It's the spikey lag that bothers me when ppl DL the large pictures of
the products, and my employees are trying to access vendor information
which is all hosted via HTTP now, rather that local CD's, like it used
to be.
munin tells me my eth0 does 90kbps on avg, with the addtion being SMTP
data (90% of it spam)
The other thing that bothers me is PacBell is too stupid to not import
their own IP addresses from RBL's and our IP got blocked (I don't know
why, they didn't tell us) and 1 day after getting it unblocked, becoz
of the nightly import, it got reblocked. I got fed up, so I route
outgoing SMTP through an SSH tunnel to get past their stupidity.
So I don't want PacBell on the premises either....
Then it sounds like what you need is a co-lo for most of your traffic
with something like DBTCP feeding back to your store to grab the
real-time inventory. Or is there a way to adapt the inventory software
you use to run with ODBC? If so, you could put everything on the co-lo
and run the ODBC connector of MySQL to the remote location. I suspect
your inventory software was written in either Paradox or a Borland[1]
product. In either case, they can be adapted to run on ODBC if you have
the source code. I still have my Borland Delphi and C++ Builder sitting
around.
Yes, DBTCP looks promising.
I had some other ODBC connectors previously, but they were time-limited
shareware, and I didn't find DBTCP in my previous searches. Then I found
the libpx package which allowed me to dump Paradox DB's to SQL.
I don't have the source code for the management system. It's a
proprietary system made by ADP. They've been saying for *years* that
they're going to port to SQL, but I'll be retired by then !
--
Michael O'Keefe | [EMAIL PROTECTED]
Live on and Ride an 06 BMW R12GS HP2 | [EMAIL PROTECTED] / |
I like less more or less less than |Work:+1 858 845 3514 / |
more. UNIX-live it,love it,fork() it |Fax :+1 858 845 2652 /_p_|
My views are MINE ALONE, blah, blah, |Home:+1 760 788 1296 \`O'|
blah, yackety yack - don't come back |Fax :+1 858 _/_\|_,
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
