Domain: postgresql.org
Stories and comments across the archive that link to postgresql.org.
Stories · 76
-
PostgreSQL 8.0 Enters Beta
gavinroy writes "As announced in pgsql-announce, PostgreSQL 8.0 Beta is now available. New features include native win32 support, Point in Time Recovery, Tablespaces, and much more! here is the beta history if you want more information." -
PostgreSQL 8.0 Enters Beta
gavinroy writes "As announced in pgsql-announce, PostgreSQL 8.0 Beta is now available. New features include native win32 support, Point in Time Recovery, Tablespaces, and much more! here is the beta history if you want more information." -
UML, PostgreSQL Get Corporate Support
tcopeland writes "An article on NewsForge highlights some changes in the upcoming PostgreSQL release (v7.5) that are funded by Fujitsu. PostgreSQL core team member Josh Berkus says that "Tablespaces, Nested Transactions, and Java support" are being underwritten by Fujitsu; this has also been mentioned on the postgresql-hackers list. He also says that 7.5 will be "...the most significant new release of the software since version 7.0 almost four years ago". Good times for PostgreSQL users!" And ggoebel writes "Jeff Dike posted a notice to the UML [User-mode Linux] developers mailing list: 'The first bit of news is that as of last Monday, I am working for Intel. They generously offered a full-time position, off-site, with my time mostly spent on UML. This basically means that UML is no longer a part-time, after-hours thing for me, so we should start seeing more work happening on it, especially compared to the last month or two.'" -
DoJ - Making Data Public Would 'Crash System'
orthogonal writes "The Justice Department today denied Freedom of Information Act requests to make public data on foreign lobbyists, claiming that '[i]mplementing such a request risks a crash that cannot be fixed and could result in a major loss of data, which would be devastating'. The requestor responded that '[t]his was a new one on us. We weren't aware there were databases that could be destroyed just by copying them,' Bob Williams of the Center for Public Integrity said Tuesday. Maybe we should tell John Ashcroft about open source database and copying solutions?" -
PostgreSQL Ported to GameCube, Linux Progressing
TheFuzzy writes "Hey folks, thought you'd like to know that the guys at Cybertec.at have succeeded in porting PostgreSQL 7.4.1 to the Nintendo GameCube. Now you, too, can turn your former video console into the world's most underpowered database server. And before anyone asks... the Windows port is coming real soon now, so be patient - it says something that the GameCube was easier to convert to than Windows, don't it?" Elsewhere in GameCube homebrew development, it looks like the GameCube Linux project is moving along quite swiftly, with "a 22 MB Debian base system image" now available, and an "ARAM block device driver" also created, now allowing 40mb of space for Linux to run in. -
One Company's Response to SCO
Great_Jehovah writes "The CIO of Just Sports USA received an extortion letter from SCO, started a thread about it on the pgsql-general and then posted his response letter after weighing the various pieces of advice and info he received. Here's hoping that most of SCO's intended victims do the same." An anonymous reader submits a story in a Utah paper about SCO: "The Salt Lake City Weekly paper is running a front page article on the SCO shenanigans. The reporter interviewed Darl, Linus, Bruce Perens and others for the article with new choice quotes from them all." Also, IBM at Linuxworld claims it will win against SCO (miscellaneous plug: CmdrTaco will be speaking at Linuxworld later today). -
PostgreSQL 7.4 Released
Christopher Kings-Lynne writes "PostgreSQL 7.4 has just been released. The list of new features is impressive and includes greatly improved OLAP performance among many other speed improvements." -
PostgreSQL Beta Testers Needed
aliensexfiend writes ""PostgreSQL Beta Testing has begun. The more testers, the merrier. Read the announcement page as well as the Beta info page. Interesting new features include a new Binary I/O protocol, ability to inline simple SQL functions, and an error message wording scheme that provides 3 layers of detail!!."" -
PostgreSQL Beta Testers Needed
aliensexfiend writes ""PostgreSQL Beta Testing has begun. The more testers, the merrier. Read the announcement page as well as the Beta info page. Interesting new features include a new Binary I/O protocol, ability to inline simple SQL functions, and an error message wording scheme that provides 3 layers of detail!!."" -
Open Source Database Clusters?
grugruto asks: "A lot of open source solutions are available to scale web sites with clusters but what about databases? I can't afford an Oracle RAC license but can I have something more reliable and fault tolerant than my single Postgres box? I have seen this recent article that looks promising for open source solutions. Do anyone have experiences with clusters of MySQL , Postgres-R, C-JDBC or other solutions? How does it compare to commercial products?" -
PostgreSQL Inc. Open Sources Replication Solution
Martin Marvinski writes "PostgreSQL Inc, the commercial company providing replication software and support for PostgreSQL, open sourced their eRServer replication product. This makes PostgreSQL one step closer to being able to replace Oracle as the de facto RDBMS standard. More information can be found on PostgreSQL's website." -
Interview With The PostgreSQL Team
Gentu writes "OSNews features an interview with some members of the PostgreSQL team regarding the much needed replication feature, their competition to MySQL, their future plans and a "native" Windows/.NET port." -
PostgreSQL 7.3 Released
rtaylor writes "Nearly a year's worth of work is out. The new tricks include schema support, prepared queries, dependency tracking, improved privileges, table (record) based functions, improved internationalization support, and a whole slew of other new features, fixes, and performance improvements. Release Email - Download Here - Mirror FTP sites (at bottom)." -
PostgreSQL 7.3 Released
rtaylor writes "Nearly a year's worth of work is out. The new tricks include schema support, prepared queries, dependency tracking, improved privileges, table (record) based functions, improved internationalization support, and a whole slew of other new features, fixes, and performance improvements. Release Email - Download Here - Mirror FTP sites (at bottom)." -
PostgreSQL 7.3 Released
rtaylor writes "Nearly a year's worth of work is out. The new tricks include schema support, prepared queries, dependency tracking, improved privileges, table (record) based functions, improved internationalization support, and a whole slew of other new features, fixes, and performance improvements. Release Email - Download Here - Mirror FTP sites (at bottom)." -
PostgreSQL 7.3 Released
rtaylor writes "Nearly a year's worth of work is out. The new tricks include schema support, prepared queries, dependency tracking, improved privileges, table (record) based functions, improved internationalization support, and a whole slew of other new features, fixes, and performance improvements. Release Email - Download Here - Mirror FTP sites (at bottom)." -
What is Holding SAP-DB Back?
Derek Neighbors queries: "The current story about MySQL 4.0 has erupted into a Postgres vs. MySQL debate. We at GNU Enterprise, who have used about all Free and Propietary databases, would like to know why exactly people arent using SAP-DB? It clearly is on par with Oracle, is GPL and frankly has an awesome support team in SAP AG. There was a PG vs SAP-DB recently. Someone else mentioned that you can get CDROMs for free. So again the question is 'What exactly is hindering a wider acceptance of SAP-DB in Free/Open Software projects?'" -
PostgreSQL vs. SAP?
Johann asks: "As my friend and I embark on building a large web site using open source development tools, I planned on using PostgreSQL. I was reminded that another 'enterprize' database is now released under the GPL - SAP DB. Since there have been countless Pg vs. MySQL comparisons on Slashdot, I wanted to ask: how does SAP DB compare technically to Pg?" -
Slashback: Regionalism, Rivalry, Zensur
Slashback with more (below) on: censorship in germany, Xbox gushing, *nix-ish Window managers on That Darn Operating System, and more. Enjoy!Even the Gates family probably hates being ripped off by region coding. jmcmurry writes: "I just tried out my daughters Winnie The Pooh from Poland, which can only be played (until today) on my Mac Cube running OS X (I did the region free crack when running OS 9). I own an Xbox with DVD player and thought, hey wouldnt hurt to try it out, since I was in the market to buy a Region Free DVD player (which can cost $400 an up) I plugged everything in, put the DVD in, and lo and behold, it plays the DVD from Poland (region code 2) This makes up for the cost of the Xbox ..."
Nein! Nein! Speaking of things that do (or don't) work by region, several readers submitted information which indicates the pooh-poohing of alleged censorship-by-DNS manipulation in Germany's state of Nordrhein-Westfalen was premature. It turns out that some interesting redirects which seemed to be a technical error or a misguided proof-of-concept, and which were quickly turned off, were reinstated shortly thereafter.
Thorsten Hornung was among the several to write on this topic. "Meanwhile ISIS has reblocked the sites, as Heise online reported (German!) due to pressure from the president of the local Government Mr. Büssow.
The local government of Düsseldorf which is responible for media services in North Rhine-Westphalia has posted a statement on its site (German) about the initial lift of the blockade saying that it believes the censoring meassures have been lifted due to complaints by users. Much worse is that furthermore public accuse people complaining about the censorship to be Right Extremists: 'The local government believes, due to the content of many emails it received today, that they [People Complaining] are users of Right Extremist Internet Content.'
The German Constitution (Grundgesetz) does not allow censorship however there are some restrictions on free speech especially regarding Nazi propaganda."
Winners sometimes use Gnomes. Prashant writes: "Cygwin is turning out to be a breeze of fresh air for people stuck on windows for one reason or another. I can use the familiar bash shell on any platform(win, *nix) I am on, and don't have to deal with the DOS prompt. I use all the gnu tools from cygwin distro. rcs, cvs, vim, perl, python, ruby, apache the list goes on. Not only that, I successfully ran postgresql on Cygwin. The XFree86 port of Cygwin itself can be huge cost saving over commercial X-servers for Windows. I have tried KDE on Cygwin version 1.1.2. I was impressed with it. Here is something new: GNOME ported to Cygwin as well. Let the rivalry ontinue on Windows.
It's all about having options. I would love be 100% Linux user but again sometimes it's not you who decides what os runs on your machine. So till Windows gets replaced by Linux by the authorities, happy cygwining."
This addition brought to you by ... Solar Power! basfromasd writes "The winner of the 3000 km World Solar Challenge race from Darwin to Adelaide has reached the finish in a record breaking time. The winning car, Nuna, was built by the Alpha Centauri team, consisting of 10 university students of TU Delft and University of Amsterdam. Some technical details can be found at their site and at ESA. Results and pictures of the race are at the Centre for Photovoltaic Engineering of UNSW website. Well done for a first time contestant, showing that skill and intelligence can match the resources of factory sponsored teams. They found some good sponsors though: GaAs solar cells are not cheap. Neither are Li-Ion batteries. Some of the solar cells were used in the Hubble Space Telescope before and brought back to earth in 1993. The other cars did not make it before today's curfew. The runner up, Aurora, stopped just outside of Adelaide for the night and is expected to finish tomorrow morning."
-
PostgreSQL 7.1 Released
Moosbert writes: "The latest and greatest PostgreSQL has been released. Major new features include write-ahead logging for better performance and reliability, outer joins, unlimited row size, and more complex queries (subselects in FROM, views with aggregates, etc.). Get yours from a mirror." -
Microsoft Access As A Client For Free Databases?
Daniel Dvorkin asks: "A few months ago, the small but growing company I work for decided that our current FileMaker-based database solution wasn't working. As DBA, I recommended a MySQL server with a Perl or PHP-based front end. My boss, who despite being a Mac guy has recently developed an inexplicable mania for all things Microsoft, is insisting that I develop everything with Access as a front end. I'm deeply unhappy about this, but I'm hoping that I might be able to salvage a little bit of the situation by using MySQL on Linux rather than SQL Server on NT for the back end." Think something like this might be possible? Read on for more informaiton. Updated!"Can this be done effectively? Is there any good documentation on connecting Access to Non-Microsoft DB servers in general, and MySQL in particular? No 'ODBC RTFM' flames, please; I'm looking for something a little deeper here."
I'm not very familiar with ODBC beyond it's basic use, so I really can't answer this question, but might this be possible if the MySQL server were somehow treated as an ODBC source? It would be tremendous coup if somehow the power of the Access front end could be used with MySQL (or PostgreSQL, or mSQL or any other open sourced RDBMS)? MySQL does have some ODBC functionality and as well as other ODBC related links on their site.
For those of you who want to immediately play around and see if this is possible, you can find the MySQL ODBC driver, here and a PostgreSQL ODBC driver here.
(My apologies. The story went live right as I was still editing it to include links in the last two paragraphs...)
-
Open Source Databases Revisited
pusakat writes "If you've been following performance comparisons of the different Open Source databases, Tim Perdue revisits PostgreSQL v. MySQL with production data from SourceForge and comes up with interesting results. This may be fodder for yet another 'my database is better than your database' exchange from both camps but the results are interesting anyway." -
Migrating From MS/IIS to Linux/Apache?
Mixhaus asks: "I'm trying to promote the Linux culture in my company. I want to migrate or at least start all new web projects on a Linux/Apache setup. Currently all the development is done on IIS/ASP with MSSQL 7.0. Has anybody done this kind of migration before? Any suggestions?""These are some of the questions that come up to my mind:
- Be able to migrate IIS to Apache first, and still be able to access the MSSQL databases (FreeTDS?)
- Use a scripting syntax similar to ASP so that the programmers don't have much of a headache learning new stuff (PHP looks like a solution).
- Migrate MSSQL 7 to MySQL, PostgreSQL or other (Which one is better for web development?)
- Web log reports (I need to generate reports on the web site usage. What weblog report generators are available for Linux? Which ones do you use? Are there any that generate graphs, charts, etc..?)
-
Is there An Enterprise-Level Open Source RDBMS?
Colm@TCD asks: "This is something I've run up against, and I'm sure that anyone else who's trying to bring Linux and Open Source software into 'enterprise' systems has encountered the same problem: Are there any OSS 'enterprise-quality' RDBMSs out there? Many (most) business setups require a fast, solid database engine to run back-end stuff. Fast SQL support isn't enough, though -- these systems need to be able to fail-over automatically to a backup machine in the event of the main system falling over. What are the best of the available systems? Are there ways of taking the existing systems like PostgreSQL and making them failover-able?" -
Feature:Whatever Happened to ANDF?
Bruce Stephens has written in with a writeup on something he considers pretty cool- perhaps you'll agree. It's about something you may not have heard of:ANDF. Looks interesting for the hardcore. Whatever happened to ANDF?Once upon a time, there was a neat technology called ANDF: Architecture Neutral Distribution Format. It even merits a place in the GNU Project's task list: provide a decompiler for ANDF. (I'm not sure whether this item is still there; it's probably not high on the list of tasks!)
I haven't seen it mentioned much in years, however.
How does ANDF work?ANDF is a format: it's a flattened representation of the abstract syntax tree for a program. Programs are compiled using a number of tools:
- A producer, which produces target-independent ANDF from source
- A linker, which links together some target-independent ANDF capsules
- An installer, which combines target-independent capsules and target-specific ones, and knows how to produce target-specific code.
Much of 3 can actually be fairly portable. Many optimizations can be cast as portable manipulations of an abstract syntax tree. What's more target-specific is which of these manipulations you use. More than that; ANDF can represent a range of levels of detail, so even quite low-level things can be done using code that is shared between targets.
So, if you want to draw a line between developers (who compile code to produce binaries) and users (who just want to use the code), you have a range of places where you can put it. Somewhere between 2 and 3 seems obvious, but it might fit somewhere inside 3, depending on what optimizations the developer wants to make, and what kinds can sensibly be left to the user to do on installation.
APIsTo make all this properly work, you need to abstract APIs. A C program which
#includedstdio.hwould tend to include lots of details about the size ofFILE(and probably internal details, assuming some functions were macros which delved insideFILE). That's going to be hard to install on a completely different target.So, such APIs are represented explicitly.
#include stdio.hmakes available tokens likeFILEand so on, with well-defined properties, but with undefined implementation. When installing, the installer provides implementations. Tokens are nodes in the abstract syntax tree (with subtrees as arguments, possibly), and these are substituted at installation time with their implementation on the specific target.And, obviously, the installer may be able to perform further optimizations on the subtituted tree (since it's still a well-defined abstract syntax tree).
The potential benefitsWith suitable coordination and standardisation, binaries could be distributed which users could install wherever they wanted. The substitution of macros for the various paths (prefix and so on) could be deferred, to be provided by a simple capsule which gets linked on installation.
Different implementations of some things could be provided. For example, programs could use MMX style operations (using a suitably defined API), and users with suitable processors could install with a capsule which uses the MMX features of their processor. Users without such processors wouldn't lose anything, since they'd install with software implementations of the API. These would not (necessarily) be function-calls, they'd be proper macro-like things, so further optimizations could be performed. Thus, there'd probably be no disadvantage for people without MMX processors compared to native compilation (with conditional macros, say).
Portability could be greatly improved; people would program to well-defined APIs, and users with those APIs available would be able to use the results. They'd even be able to get and use the results in binary (without having to compile it themselves). In a different operating system. On a different processor (with different endianness, with a different word-size, even).
An excuse to hide sourceWouldn't this just encourage concealing source? After all, the Windows world has lots of "freely available" programs. The catch is that they're binary only, so you can't improve them, or learn from them.
Possibly. But there are good, pragmatic reasons for wanting to share source, and these would remain. Apache would still have been developed, and would still be being distributed in source, even if we'd had this technology years ago. And people will sell binaries without source, regardless of the obstacles you put in their way; this technology would simply change things a little.
P-code, JVM, ...The format isn't much like previous universal intermediate languages. Largely, they were abstractions of machines; this is an abstraction of programs, or of programming languages. i.e., it retains all the interesting information that you need for performing optimizations; it just loses details like variable names.
Vaporware"This could be cool. But it doesn't exist/costs money/is proprietary and closed source."
Judge for yourself: TenDRA. I'm not a lawyer, but that copyright looks pretty Open Source(TM) to me. (There are probably patents covering it, but who can tell, with software patents?)
- You can download source, documentation, tools
- APIs for ISO C, POSIX, XPG3/4, X11R5 and probably a few I've forgotten
- Producers for C and C++; installers are claimed to be good for Intel ELF and SPARC, and a number of others (possibly of lesser quality) are included; performance seems acceptable compared with egcs on my Linux box
What it doesn't include is a C++ library. (A port of
libstdc++would be nice, if anybody wants something to do.) The C++ looks pretty complete in other respects, however, although I'm not a C++ expert, either. The whole thing looks cleanly written. The C checker is worth the download on its own (IMHO).The C and C++ producers can write out their symbol tables, in a documented format. Such information would be helpful when writing a source-navigator (!), which is what I'm (slowly) working on at the moment. (I'm writing a Perl module which will read in and parse such files, which people could then process in wacky ways. (My plan is to write the information to a relational database like PostgreSQL, but I'm a little way off that.))
EGCSI just don't see where this technology fits, given that there's already egcs, which produces pretty good code, on more targets than just about anything else.
The hacker in me feels it darned well ought to fit somewhere, though. This is cool technology; it deserves to be played with.
-
PostgreSQL 6.3 Released
Eugenio Sanchez wrote in to say "PostgreSQL 6.3 has been released. It includes lots of enhancements and fixes, included the much sought capability of performing subselects, and a greater subset of SQL '92. The PostgreSQL homepage is at The PostgreSQL Home Page." I know the SQL database war is a hot one with everyone, but a new version ups the stakes for everyone. I need to build an SQL server that can house millions of records and get them fast. Each SQL Server that releases a new version makes that more of an inexpensive reality.