Re: [GENERAL] To BLOB Or Not To BLOB

2000-04-17 Thread chewie
How do I start this? There are so many different ways to look at this question. Do I save files inside the database, or do I simply use the database as a tool to query information about a given file, it's properties, etc. Instead of making general statements, let me pick specific examples.

Re: [GENERAL] To BLOB Or Not To BLOB

2000-04-17 Thread Stephen Davies
G'day. I do a lot of work with the BASIS textual/multi-media RDBMS package and run into this question all the time. There is one pretty basic answer: If you leave BLOBS lying around in the file system - particularly if it is a Novell etc file system - people move them and the links get

RE: [GENERAL] excell to postgres

2000-04-17 Thread Chris Carbaugh
If you really want to save the user some work/confusion, investigate what you can do with VB under XL. I would think XL allows you to set some options when export as CSV, with VB, you could write your own Save function. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [GENERAL] excel to postgres

2000-04-17 Thread Hal Snyder
"Chris Carbaugh" [EMAIL PROTECTED] writes: If you really want to save the user some work/confusion, investigate what you can do with VB under XL. I would think XL allows you to set some options when export as CSV, with VB, you could write your own Save function. How messy to Save to a

Re: [GENERAL] Connecting website with SQL-database.....

2000-04-17 Thread Manuel Lemos
Hello J.Post, On 17-Apr-00 12:26:41, you wrote: I've been looking on the internet for 2 hours for information how to connect my SQL database to my website. I didn't find what I was looking for, this is my problem I have got a form on my site, that can be filled in by visitors. I

Re: [GENERAL] excell to postgres

2000-04-17 Thread Fabrice Scemama
I'm a Linux user. I've been using xlHTML and a home-made HTML2DBF rather than ODBC with Perl's DBD::Proxy and DBD::ODBC because, to be able to use ODBC, you need people to *name* the table they create when using Excel. Well, they never do so. Sometimes, they will name a table with 256 columns and

Re: [GENERAL] excel to postgres

2000-04-17 Thread Tom Cook
On 17 Apr 2000, Hal Snyder wrote: "Chris Carbaugh" [EMAIL PROTECTED] writes: If you really want to save the user some work/confusion, investigate what you can do with VB under XL. I would think XL allows you to set some options when export as CSV, with VB, you could write your own

Re: [GENERAL] excel to postgres

2000-04-17 Thread Andrew Perrin - Demography
Sure, VB works, as would perl with DBD::ODBC module. I've been using that technique for porting a database from access to postgres, and it should work equally well with excel-based ODBC connections. Disadvantage to the original poster is that it does require a Windows machine to read the Excel

[ANNOUNCE] PostgreSQL book completed though chapter 14

2000-04-17 Thread Bruce Momjian
I have completed the first draft of my book through chapter 14. New chapters include: Chapter 11, Performance: Indexes, CLUSTER, VACUUM, EXPLAIN Chapter 12, Controlling Results: LIMIT, Cursors Chapter 13, Table Management: Temporary tables, ALTER TABLE,

Re: [GENERAL] excel to postgres

2000-04-17 Thread Tom Cook
On Mon, 17 Apr 2000, Andrew Perrin - Demography wrote: Sure, VB works, as would perl with DBD::ODBC module. I've been using that technique for porting a database from access to postgres, and it should work equally well with excel-based ODBC connections. Disadvantage to the original poster