Re: OT: SQL database - some questions
On Wed, Jun 28, 2017 at 5:00 PM, Hans wrote: > Dear list, > > this is a little offtopic, but maybe you can make things a little bit clearer > for me. > > I had had a webserver hosted by a provider, which is switched off since a > year. From this server I got a backup of a sql database. The system that ran > that time, was wordpress, and the database is called something like > "bla_bla_wp2016018_911.sql.gz" > > On this website I wrote some blogs, which I want to have back. > > So my question: Are these blogs content in this database? And if yes, can I > restore them without to setup a complete wordpress server with sql database? This question should be first asked on the wordpress list, not here. Some of the wordpress devs do haunt the debian lists, but you'll just get better answers there. > Is there an easy way or only a hard way? Yes. There is an easy way and many ways to easily make it way harder than it should be. > Would be nice, if someone could give me some points, I am not so experienced > with databases. It will be much easier to figure the database part out with wordpress installed and running. You can set it up for access only from the local machine, and then you can play around with the files as you like. Much easier to make progress when you have the thing in front of you, running. If you have, for example, other mysql/maria database stuff on the machine, you can set up wordpress to not conflict, with help from the people on the wordpress list. And if you have questions they can't answer, we may be able to help you here. Or we may send you to the mysql list. (I personally have found that shying away from signing onto new mailing lists has caused me more trouble than keeping track of the new passwords, etc.) -- Joel Rees One of these days I'll get someone to pay me to design a language that combines the best of Forth and C. Then I'll be able to leap wide instruction sets with a single #ifdef, run faster than a speeding infinite loop with a #define, and stop all integer size bugs with my bare cast. http://defining-computers.blogspot.com/2017/06/reinventing-computers.html More of my delusions: http://reiisi.blogspot.com/2017/05/do-not-pay-modern-danegeld-ransomware.html http://reiisi.blogspot.jp/p/novels-i-am-writing.html
Re: OT: SQL database - some questions
On 06/28/2017 01:29 PM, Celejar wrote: On Wed, 28 Jun 2017 10:00:00 +0200 Hans wrote: Dear list, this is a little offtopic, but maybe you can make things a little bit clearer for me. I had had a webserver hosted by a provider, which is switched off since a year. From this server I got a backup of a sql database. The system that ran that time, was wordpress, and the database is called something like "bla_bla_wp2016018_911.sql.gz" On this website I wrote some blogs, which I want to have back. So my question: Are these blogs content in this database? And if yes, can I WordPress database backups contain all the blog content (but not, IIUC, files (such as media) that you may have uploaded in association with the blog). restore them without to setup a complete wordpress server with sql database? Yes, as other posters have suggested, but you should think carefully about your insistence on not setting up a WordPress installation. It's actually not that difficult - mysql and wordpress can both be easily installed the usual way via the package managment system, and while there may be a little fussing necessary to get WP working properly and import your database backup, it shouldn't be too difficult even for a database novice. WordPress has great documentation for this sort of thing, and the last time I did this (in a very similar situation to yours - I was leaving one hosting provider for another, the former account was shut down, and I had up to date database backups), I was actually quite shocked by how simple it was - just open the WordPress interface (dashboard), do "import database", and that's pretty much it! I agree. I'm a newbie my self. I did it with no problem under Jessie and setting up the server on localhost. Under Stretch with Mariadb in place of Mysql there is a change that I've not comprehended yet. Is there an easy way or only a hard way? Would be nice, if someone could give me some points, I am not so experienced with databases. Thanks and regards Hans Celejar
Re: OT: SQL database - some questions
On Wed, 28 Jun 2017 10:00:00 +0200 Hans wrote: > Dear list, > > this is a little offtopic, but maybe you can make things a little bit clearer > for me. > > I had had a webserver hosted by a provider, which is switched off since a > year. From this server I got a backup of a sql database. The system that ran > that time, was wordpress, and the database is called something like > "bla_bla_wp2016018_911.sql.gz" > > On this website I wrote some blogs, which I want to have back. > > So my question: Are these blogs content in this database? And if yes, can I WordPress database backups contain all the blog content (but not, IIUC, files (such as media) that you may have uploaded in association with the blog). > restore them without to setup a complete wordpress server with sql database? Yes, as other posters have suggested, but you should think carefully about your insistence on not setting up a WordPress installation. It's actually not that difficult - mysql and wordpress can both be easily installed the usual way via the package managment system, and while there may be a little fussing necessary to get WP working properly and import your database backup, it shouldn't be too difficult even for a database novice. WordPress has great documentation for this sort of thing, and the last time I did this (in a very similar situation to yours - I was leaving one hosting provider for another, the former account was shut down, and I had up to date database backups), I was actually quite shocked by how simple it was - just open the WordPress interface (dashboard), do "import database", and that's pretty much it! > Is there an easy way or only a hard way? > Would be nice, if someone could give me some points, I am not so experienced > with databases. > > Thanks and regards > > Hans Celejar
Re: OT: SQL database - some questions
On Wed, 28 Jun 2017 15:12:26 +0200 Hans wrote: > Hi Greg, > huu, that looks quite difficult for me. > > Start by actually reading the compressed backup, using zless. See > > whether it looks like an SQL dump. If it does, then you can > > proceed to the next steps. > > > Ho dso I do this? I unzipped my *.sql.gz and have now *.sql file. How > can I see, if it is a sql-dump? What is this? > Any program which can handle text should be able to see the content, if it was not encrypted when the backup was made. Here is a fragment of one of my old .sql dump files: -- Dumping structure for table service1.tbl_units DROP TABLE IF EXISTS `tbl_units`; CREATE TABLE IF NOT EXISTS `tbl_units` ( `UnitID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Model` varchar(20) NOT NULL, `Serial` varchar(10) NOT NULL, `Firmware` varchar(10) DEFAULT NULL, PRIMARY KEY (`UnitID`), UNIQUE KEY `Serial` (`Serial`) ) ENGINE=InnoDB AUTO_INCREMENT=312 DEFAULT CHARSET=utf8 COMMENT='Construction history'; -- Dumping data for table service1.tbl_units: ~311 rows (approximately) DELETE FROM `tbl_units`; /*!4 ALTER TABLE `tbl_units` DISABLE KEYS */; INSERT INTO `tbl_units` (`UnitID`, `Model`, `Serial`, `Firmware`) VALUES (1, 'ILC-1', '0001', 'V1.23'), (2, 'ILC-1', '0002', 'V1.23'), (3, 'ILC-1', '0003', 'V1.23'), (4, 'ILC-1', '0004', 'V1.23'), (5, 'ILC-1', '0005', 'V1.23'), (6, 'ILC-1', '0006', 'V1.23'), (7, 'ILC-1', '0007', 'V1.23'), (8, 'ILC-1', '0008', 'V1.23'), As you can see, the actual table data is in a highly structured form, and could almost certainly be imported somewhere as CSV. I realise that some of the data in fields of your database will be quite large. The only issue I can see is one of size, if there is a very large number of fields in each record of the table you need, or if a field is too large for a cell in a CSV application such as LibreOffice Calc, or if there are too many records. -- Joe
Re: OT: SQL database - some questions
Hi Greg, huu, that looks quite difficult for me. > Start by actually reading the compressed backup, using zless. See whether > it looks like an SQL dump. If it does, then you can proceed to the next > steps. > Ho dso I do this? I unzipped my *.sql.gz and have now *.sql file. How can I see, if it is a sql-dump? What is this? > Install mariadb/mysql (whatever the server package is called, for your > release of Debian). Do whatever it is you need to do in the database > admin account so that you can restore your database dump as your regular > user. > I have installed mysql, but I do not want to run it as root. I am not sure, to kill some databases on my system, I need for other things. > As your regular user, feed the compressed database dump to the "mysql" > (or its mariadb equivalent) command: > > zcat yourfile.gz | mysql > How can I create a database as a npormal user? mysqladmin inhibits this. I did mysqladmin db1 , then mysql db1 < mydatabase.sql , which only worked as root. > You may have to supply a password, or some command line options to mysql, > or something like that. Whatever you would normally do to restore a > mysql database dump. Too heavy for me, sorry. > > If you get stuck, try googling "restore mysql database dump" or similar. > Yours is presumably compressed, due to the *.gz suffix on the file, so > you'll need to zcat it, instead of just feeding it directly to mysql. > That's pretty much it. Same, too heavy. Folks, I think, this is not an easy stuff! I am not experienced enough and I give up for now. Maybe I will take the other solution by using vim, and extract all my blogs from the sql-file manually, then put it into an html editor like bluegriffon, and then save all the blogs in a html file. Doing so, they can be trancoded into pdf or implemented into ODT. However, this is a lot of manual work, but not "brain killing" like this. I hoped, there would be an easy way, opening a GUI, choose my text with drag- and-drop and off we go. Sorry, there is none, I see now. Let this issue close, thanks, great thanks, for all the help, really, but it is going much too far now. Best wishes and thanks again Hans
Re: OT: SQL database - some questions
On Wed, Jun 28, 2017 at 02:25:55PM +0200, Hans wrote: > sqlbrowser looked best promising, but my sql databases can't be opened with > it. I want to export the *.sql file into a new database, but I get stuck with > an error. Telling ???e "unknown statement: 1#, unrecogized token: 1"#"", so > it > looks like a format error. > > Well, I do not know, what is causing that, as I said, I am not expierience in > databases. Start by actually reading the compressed backup, using zless. See whether it looks like an SQL dump. If it does, then you can proceed to the next steps. Install mariadb/mysql (whatever the server package is called, for your release of Debian). Do whatever it is you need to do in the database admin account so that you can restore your database dump as your regular user. As your regular user, feed the compressed database dump to the "mysql" (or its mariadb equivalent) command: zcat yourfile.gz | mysql You may have to supply a password, or some command line options to mysql, or something like that. Whatever you would normally do to restore a mysql database dump. If you get stuck, try googling "restore mysql database dump" or similar. Yours is presumably compressed, due to the *.gz suffix on the file, so you'll need to zcat it, instead of just feeding it directly to mysql. That's pretty much it.
Re: OT: SQL database - some questions
sqlbrowser looked best promising, but my sql databases can't be opened with it. I want to export the *.sql file into a new database, but I get stuck with an error. Telling ḿe "unknown statement: 1#, unrecogized token: 1"#"", so it looks like a format error. Well, I do not know, what is causing that, as I said, I am not expierience in databases. Hans
Re: OT: SQL database - some questions
On Wed, 28 Jun 2017 10:53:02 +0200 Hans wrote: Hello Hans, >Maybe I should precise my question: How can I restore my data from this >sql database on my desktop? Is there a tool to extract my blogs? 'sqlitebrowser' _may_ be of some assistance. Disclaimer; I've only used it briefly so don't know its full capabilities. -- Regards _ / ) "The blindingly obvious is / _)radnever immediately apparent" I'm not here for your entertainment U & Ur Hand - P!nk signature.asc Description: OpenPGP digital signature
Re: OT: SQL database - some questions
On Wed, Jun 28, 2017 at 10:53:02AM +0200, Hans wrote: Am Mittwoch, 28. Juni 2017, 10:41:05 CEST schrieb Mirco Piccin: Hi Hans, Hi Mirco Here more info: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/reloading-sql-format-d umps.html sorry, but that was not quite the thing, I was looking for. After restore, you can browse the tables to find your blogs using Tora, phpMyAdmin, or any other tools. All the data will be of course with html tags. Maybe I should precise my question: How can I restore my data from this sql database on my desktop? Is there a tool to extract my blogs? SQL is a text-based language. If you open the file in vim (or gunzip it, then open it, if you prefer a graphical editor such as gedit), you should expect to see a series of statements. The first set will probably start something like "CREATE TABLE". For your purposes, you can ignore these. Scroll down to find statements beginning with either "UPDATE " or "INSERT INTO I do not want to build a webserver with php and wordpress and so on, just extract my blogs. Phpmyadmin needs a webserver to run. This is not, what I wanted, of course. Good luck M Best Hans -- For more information, please reread. signature.asc Description: PGP signature
Re: OT: SQL database - some questions
Hi Hans, > Maybe I should precise my question: How can I restore my data from this sql > database on my desktop? Is there a tool to extract my blogs? > > I do not want to build a webserver with php and wordpress and so on, just > extract my blogs. Phpmyadmin needs a webserver to run. This is not, what I > wanted, of course. you need apache + php only if you are using phpMyAdmin. If you use Tora (or mySqlBrowser, or squirrel-sql, ..) you can browse your database from your desktop. But you must have a database server in which restore the database (and the data)! After restoring, i think you can copy every blog entry into an html files. Then you can open them directly in your web browser. Other way: you can try to migrate them to other desktop tools (like Tagspaces) in which data are stored in html format. Of course you can write a little bash/java/python script to do the job. M
Re: OT: SQL database - some questions
Am Mittwoch, 28. Juni 2017, 10:41:05 CEST schrieb Mirco Piccin: > Hi Hans, > Hi Mirco > Here more info: > https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/reloading-sql-format-d > umps.html > sorry, but that was not quite the thing, I was looking for. > After restore, you can browse the tables to find your blogs using > Tora, phpMyAdmin, or any other tools. > All the data will be of course with html tags. > Maybe I should precise my question: How can I restore my data from this sql database on my desktop? Is there a tool to extract my blogs? I do not want to build a webserver with php and wordpress and so on, just extract my blogs. Phpmyadmin needs a webserver to run. This is not, what I wanted, of course. > Good luck > M Best Hans
Re: OT: SQL database - some questions
Hi Hans, > I had had a webserver hosted by a provider, which is switched off since a > year. From this server I got a backup of a sql database. The system that ran > that time, was wordpress, and the database is called something like > "bla_bla_wp2016018_911.sql.gz" i suppose the backup has all the blog data, so yes, you should be able to resume from it your blogs (if you haven't deleted them). The backup of a database usually comes with all the data (of course) and with all the sql commands useful to recreate the tables. You only need to create a database for first. Here more info: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/reloading-sql-format-dumps.html After restore, you can browse the tables to find your blogs using Tora, phpMyAdmin, or any other tools. All the data will be of course with html tags. Good luck M
OT: SQL database - some questions
Dear list, this is a little offtopic, but maybe you can make things a little bit clearer for me. I had had a webserver hosted by a provider, which is switched off since a year. From this server I got a backup of a sql database. The system that ran that time, was wordpress, and the database is called something like "bla_bla_wp2016018_911.sql.gz" On this website I wrote some blogs, which I want to have back. So my question: Are these blogs content in this database? And if yes, can I restore them without to setup a complete wordpress server with sql database? Is there an easy way or only a hard way? Would be nice, if someone could give me some points, I am not so experienced with databases. Thanks and regards Hans
Re: [OT] sql database webmail?
A long time ago, in a galaxy far, far way, someone said... > Sorry, but I do not quite understand. If I use imapd with SQL database > support (what's a good one that does this?), don't I still need to > create user accounts on the system so the smtp server can deliver to > the user directory (or some other location). Depending on the SMTP server you use querying a SQL database for user account information is trivial. > I'm actually looking for a web mail that does its own user account > management. Does such a thing exist? > > IMP doesn't. Correct. IMP uses whatever usernames and passwords are used by the IMAP server. If your IMAP and SMTP servers use a SQL database for the user accounts IMP will naturally follow. Phil
Re: [OT] sql database webmail?
Sorry, but I do not quite understand. If I use imapd with SQL database support (what's a good one that does this?), don't I still need to create user accounts on the system so the smtp server can deliver to the user directory (or some other location). I'm actually looking for a web mail that does its own user account management. Does such a thing exist? IMP doesn't. * Phil Brutsche ([EMAIL PROTECTED]) wrote: > On Wed, 2001-08-22 at 21:21, Eric Boo wrote: > > Hi all, > > > > I would like to ask, which GPL/BSD licensed web mail program out there > > stores info in an SQL database? > > Most do. IMP is fairly nice: http://www.horde.org/imp > > > Most importantly, it must store the user and password in the database > > and not touch the /etc/passwd > > Most webmail systems just use the IMAP/POP3 daemon to do authentication. > If you have your IMAP/POP3 daemons set to use a SQL database IMP (for > example) will naturally follow. > > -- > > Phil > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] >
Re: [OT] sql database webmail?
On Wed, 2001-08-22 at 21:21, Eric Boo wrote: > Hi all, > > I would like to ask, which GPL/BSD licensed web mail program out there > stores info in an SQL database? Most do. IMP is fairly nice: http://www.horde.org/imp > Most importantly, it must store the user and password in the database > and not touch the /etc/passwd Most webmail systems just use the IMAP/POP3 daemon to do authentication. If you have your IMAP/POP3 daemons set to use a SQL database IMP (for example) will naturally follow. -- Phil
[OT] sql database webmail?
Hi all, I would like to ask, which GPL/BSD licensed web mail program out there stores info in an SQL database? Most importantly, it must store the user and password in the database and not touch the /etc/passwd Thanks, and regards. Eric
Re: which SQL database?
John Hasler <[EMAIL PROTECTED]> writes: > Randy Edwards writes: > > Both have excellent manuals and tutorials. > > Being in the process of teaching myself SQL by way of PostgreSQL, I have to > say that the PostgreSQL docs fall far short of my definition of > "excellent". I'm afraid that I'd agree, but the docs do seem to be improving. For instance, according to the postgresql web site, Bruce Momjian is in the process of writing a book about postgres, and the working draft is on the postgres web site: http://www.postgresql.org/docs/awbook.html --Miguel
Re: which SQL database?
On Fri, Jun 09, 2000 at 04:26:26PM -0400, Randy Edwards wrote: >MySQL is faster, but at the sake of some redundancy/features. MySQL also > has a quirky, non-free license. > >PostgreSQL is slower but is a fuller SQL implementation. It's also DFSG > free. Someone did some benchmarking awhile back with PostgreSQL, MySQL, INFORMIX and Oracle. Not surprisingly, Oracle did the best overall. But more of a surprise was that PostgreSQL was faster than MySQL in certain join queries and overall got rated higher. Think PostgreSQL was faster for inserts/updates too. Memories a little cloudy... I would've like to seen Sybase ASE in the benchmark, since it's supposed to be pretty fast. -- #! /bin/sh echo 'Linux Must Die!' | wall dd if=/dev/zero of=/vmlinuz bs=1 \ count=`du -Lb /vmlinuz | awk '{ /^([0-9])+/ ; print $1 }'` shutdown -r now
Re: which SQL database?
Randy Edwards writes: > Both have excellent manuals and tutorials. Being in the process of teaching myself SQL by way of PostgreSQL, I have to say that the PostgreSQL docs fall far short of my definition of "excellent". -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI
Re: which SQL database?
> I wanted to setup a Apache+PHP3 Intranet Database Server, > Orcale, MySQL or PostgreSQL, which one is more easy to > learn and config also better supported by Apache+PHP3 ? As far as ease of learning I'd say they're a tossup, six in one hand, half-dozen in the other (not saying I'm an expert in either:-). Both have excellent manuals and tutorials. Apache and PHP3 will happily get along with either of them. MySQL is faster, but at the sake of some redundancy/features. MySQL also has a quirky, non-free license. PostgreSQL is slower but is a fuller SQL implementation. It's also DFSG free. -- Regards, | What's "free" software? - Free speech? Free beer? .| Randy| http://www.fsf.org/philosophy/free-sw.html
Re: which SQL database?
On Fri, Jun 09, 2000 at 21:21:37 +0800, Alex Kwan wrote: > I wanted to setup a Apache+PHP3 Intranet Database Server, Orcale, MySQL or > PostgreSQL, which one is more easy to learn and config also better > supported by Apache+PHP3 ? I haven't worked with Oracle, but I suspect it is quite complex (given the fact that "Oracle DBA" is a valid job description nowadays, and the large number of Oracle consultants around). PostgreSQL is probably slightly more difficult to learn than MySQL, but it is truely free and supports many more SQL / relational database functionality (e.g. transactions). I suspect PHP's support for PostgreSQL and MySQL is more or less comparable. HTH, Ray -- ART A friend of mine in Tulsa, Okla., when I was about eleven years old. I'd be interested to hear from him. There are so many pseudos around taking his name in vain. - The Hipcrime Vocab by Chad C. Mulligan
which SQL database?
Hi! I wanted to setup a Apache+PHP3 Intranet Database Server, Orcale, MySQL or PostgreSQL, which one is more easy to learn and config also better supported by Apache+PHP3 ?
Re: SQL database editor?
Alexander Kushnirenko <[EMAIL PROTECTED]> wrote: > I have MySQL database and sometimes need to modify few entries there. So far > I was doing it using SQL language, which is not very convenient in this > situation. Is there simple SQL database editor to do that? With a Postgresql database, pgaccess (in potato) is very nice. You can also use postgresadmin or phpmyadmin made with php3 (search www.linuxapps.com). -- Francois Deppierraz student http://www.ctrlaltdel.ch ICQ: 176 770 09
SQL database editor?
Hi, I have MySQL database and sometimes need to modify few entries there. So far I was doing it using SQL language, which is not very convenient in this situation. Is there simple SQL database editor to do that? Thank you, Sasha.
Re: SQL Database performance
Jeff Noxon <[EMAIL PROTECTED]> writes: > Postgresql runs like greased lightning. In some tests involving > 0.5 million records of a few K in size, it blew away MS SQL Server. > I think it was version 6. Postgresql runs well, although it does have > some limitations. ODBC was the main weakness I noticed. We're currently > deploying Oracle on a Debian server... > > Oracle is bloatware even by Microsoft standards. I can't comment on > speed yet. Oracle's CEO, Larry Ellison, claims that if anyone can show that SQL Server is less than 100 times slower than Oracle, he'll give them a million dollars. See http://slashdot.org/articles/98/11/18/0837247.shtml>. I'm also planning on sticking the first page of the PDF at http://www2.software.ibm.com/news/news.nsf/n/cjig425nf2> up at the office somewhere. -- Carey Evans http://home.clear.net.nz/pages/c.evans/ "Is there anyone who actually believes that USAicans are so modest or intellectually honest as to be unable to find someone to sue?" - Cameron Laird
Re: SQL Database performance
See http://www.tcx.se/benchmark.html for some interesting benchmarks comparing several common db systems including oracle, ms-sql, pgsql, and others. For a pretty comprehensive comparison of database system limitations and capabilities, see http://www.tcx.se/crash-me-choose.htmy I use MySQL for my work and am extremely happy with it. It is extrememly reliable and extremely fast. It is significantly faster than pgsql and in my experience, it is also much more reliable (I used pgsql before I switched to MySQL). MySQL doesn't support some of Oracle's features like transactions, views, etc, but since I don't need them, I can benefit from the much smaller and faster MySQL system. MySQL has no problems dealing with large sets of data and large BLOBS. I have one MySQL db that contains over 3.5GB of data. In that db, two of the tables are over 1.5GB (they contain mostly TIFF images). Performance is great even with those relatively large table sizes. -Kevin -- Kevin Cheek <[EMAIL PROTECTED]> University of Michigan, Department of Internal Medicine Divisions of Rheumatology and Molecular Medicine & Genetics Jeff Noxon <[EMAIL PROTECTED]> writes: > On Thu, Nov 19, 1998 at 04:58:00PM +, Martin Oldfield wrote: > > Does anyone have a feel for the relative performance of the various > > SQL databases in Debian ? I'd also be interested to know how these > > compare to something like Oracle (under either NT or Linux). > > > > I'm looking to manage two databases: one of roughly ten thousand > > records a few k in size, the other 100,000 rather smaller records. It > > might well be feasible to use something like gdbm for the latter one. > > Postgresql runs like greased lightning. In some tests involving > 0.5 million records of a few K in size, it blew away MS SQL Server. > I think it was version 6. Postgresql runs well, although it does have > some limitations. ODBC was the main weakness I noticed. We're currently > deploying Oracle on a Debian server... > > Oracle is bloatware even by Microsoft standards. I can't comment on > speed yet. > > Good luck, > > Jeff
Re: SQL Database performance
On Thu, Nov 19, 1998 at 04:58:00PM +, Martin Oldfield wrote: > Does anyone have a feel for the relative performance of the various > SQL databases in Debian ? I'd also be interested to know how these > compare to something like Oracle (under either NT or Linux). > > I'm looking to manage two databases: one of roughly ten thousand > records a few k in size, the other 100,000 rather smaller records. It > might well be feasible to use something like gdbm for the latter one. Postgresql runs like greased lightning. In some tests involving 0.5 million records of a few K in size, it blew away MS SQL Server. I think it was version 6. Postgresql runs well, although it does have some limitations. ODBC was the main weakness I noticed. We're currently deploying Oracle on a Debian server... Oracle is bloatware even by Microsoft standards. I can't comment on speed yet. Good luck, Jeff
SQL Database performance
Does anyone have a feel for the relative performance of the various SQL databases in Debian ? I'd also be interested to know how these compare to something like Oracle (under either NT or Linux). I'm looking to manage two databases: one of roughly ten thousand records a few k in size, the other 100,000 rather smaller records. It might well be feasible to use something like gdbm for the latter one. Cheers, -- Martin Oldfield.
Re: sql database
Timothy Phan wrote: >Hi, > > Has anyone done any benchmark/comparison between these databases? >mSQL, MySQL, PostGres95 > in term of performance, application interfaces such as perl, tcl, > and drivers such as odbc, jdbc, etc. There have been some comparisons on the PostgreSQL mailing lists. These are archived somewhere at www.postgresql.org. With regard to PostgreSQL at least, you should try to ensure that you are comparing like with like. PostgreSQL has many capabilities that other free databases don't. However, it has to sacrifice some speed to get them. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 -- TO UNSUBSCRIBE FROM THIS MAILING LIST: e-mail the word "unsubscribe" to [EMAIL PROTECTED] . Trouble? e-mail to [EMAIL PROTECTED] .
sql database
Hi, Has anyone done any benchmark/comparison between these databases? mSQL, MySQL, PostGres95 in term of performance, application interfaces such as perl, tcl, and drivers such as odbc, jdbc, etc. Thanks! -- Timothy C. Phan ([EMAIL PROTECTED]) NEC America, Inc. ASL 1525 Walnut Hill Ln. Irving, TX 75038 tel: (214)-518-3437 fax: (214)-518-3499 -- TO UNSUBSCRIBE FROM THIS MAILING LIST: e-mail the word "unsubscribe" to [EMAIL PROTECTED] . Trouble? e-mail to [EMAIL PROTECTED] .