Slashdot Mirror

← Back to Stories (view on slashdot.org)

Postgres Engine for MySQL Released

Posted by CmdrTaco on

SlashRating© 11.9 slashdottit! tm krow writes "One of the unique qualities of the MySQL server is its ability to have multiple storage engine operate concurrently. Companies like Oracle and Solid have contributed their own storage engines to the open source project. With 5.1 MySQL has added the ability to now do this in a loadable fashion, allowing dynamic engines in the same manner as Apache with its modules. Now PostgreSQL can add its self to the list of databases who have contributed a storage engine to MySQL. I'm releasing today a plugin so that you can now plugin the Postgres database engine into MySQL and have it work natively along side other engines."

78 comments

  1. I'm Lost by Anonymous Coward · · Score: 0

    Is this a April Fools or not?

    1. Re:I'm Lost by beckerist · · Score: 2, Informative

      There are 4 links to corporations home pages. There's 1 link to someone's blog that contains a broken link to a non-existent plug-in. Not only that, I think this would make a much bigger stink if it were real. So, my thoughts: APRIL FOOLS!

    2. Re:I'm Lost by kirun · · Score: 2, Funny
      A clue for you:

      mysql> select * from april;
      Empty set (0.00 sec)
      --
      I'm scared of numbers that can't be written as a fraction. It's an irrational fear.
    3. Re:I'm Lost by Splab · · Score: 1

      Also the fact that Brian has a blackhole engine running next to the pgsql.

    4. Re:I'm Lost by Anonymous Coward · · Score: 1, Informative

      The blackhole engine is real..

    5. Re:I'm Lost by Anonymous Coward · · Score: 0

      There are 4 links to corporations home pages


      PostgreSQL is not a corporation.
    6. Re:I'm Lost by Agret · · Score: 1

      The link to the plugin is working now, check it out.
      I'm downloading it now, it's 7mb but only going 10kb/s so I'm not sure what it'll be.

      --
      Have you metaroderated recently?
    7. Re:I'm Lost by Anonymous Coward · · Score: 0

      The blackhole engine throws away all data sent to it. It's useful in backup and multi-level replication setups because it does write to the binary log which records all changes to data. Also handy for benchmarking database overhead above the storage engine layer.

  2. BUT... by dark_15 · · Score: 5, Funny

    Will it blend?

    --
    Unto the upright there arises light in the darkness...
    1. Re:BUT... by Anonymous Coward · · Score: 0

      That is the question ...

    2. Re:BUT... by Renfield+Spiffioso · · Score: 1

      This is database smoke; don't breathe this.

  3. should speed up Postgresql by Anonymous Coward · · Score: 5, Funny

    One of the problems with Postgresql versus MySQL is that it is typically much, much slower and less capable. THis should address those problems.

    1. Re:should speed up Postgresql by metamatic · · Score: 2, Interesting

      Actually, it's a useful idea. MySQL is only faster than PostgreSQL for "toy" databases (low concurrency, few transactions needed per second), or if you throw away ACID capabilities.

      However, a lot of open source projects use non-portable MySQL "SQL", and hence don't work if you try to use PostgreSQL as your back end. A hack like this that actually worked would let you run crappy open source code on a more scalable database back end.

      --
      GCHQ Quantum Insert installed. If only our tongues were made of glass, how much more careful we would be when we speak
    2. Re:should speed up Postgresql by Master+of+Transhuman · · Score: 2, Insightful

      PostgreSQL is LESS capable than MySQL? (Slower at some things, maybe, but LESS CAPABLE?)

      Leave the crack pipe at home next time.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    3. Re:should speed up Postgresql by jadavis · · Score: 2, Insightful

      A hack like this that actually worked would let you run crappy open source code on a more scalable database back end.

      A lot of PostgreSQL's performance comes from it's cost-based optimizer that chooses the correct plan based on statistically sampling your real data periodically. In other words, as your data changes, your plans change accordingly without administrator intervention. MySQL's optimizer is much more primitive.

      Also, PostgreSQL has much more sophisticated options when planning, like bitmap index scans (which can be ANDed/ORed with other indexes and reorder the tuple fetching in disk order), GIN and GiST indexes, Hash Aggregates, Hash Joins, etc.

      However, if PostgreSQL were just a "storage engine" I don't MySQL's storage API would pass enough information about the high-level query down to the PostgreSQL storage engine. That means PostgreSQL couldn't make good choices for plans.

      A "storage engine" with a simple API for storing/fetching records is fairly uninteresting from a database performance standpoint.

      Granted, PostgreSQL's MVCC is likely to be a win under concurrent access in some situations. But the wide range of performance that PostgreSQL delivers without modification of application queries (or administrator intervention) is where it really shines.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    4. Re:should speed up Postgresql by Anonymous Coward · · Score: 0

      whoosh. as if anyone saying it could possibly get through.

    5. Re:should speed up Postgresql by clambake · · Score: 1

      One of the problems with Postgresql versus MySQL is that it is typically much, much slower and less capable. THis should address those problems.

      Yes yes, this is true, PostgreSQL *IS* so much faster than MySQL, that's well understood... But that's just a small drop in the ocean compared to the much LARGER problem about comparing the two which is that PostgreSQL is a relational database while MySQL is a fancy way to access flat files.

  4. 13 Meg GZ file no less by fruey · · Score: 2, Interesting

    If you're going to get Slashdotted, posting a link to a 13MB file is a bit risky, no?

    Anyone manage to dl it? I gave up a few minutes ago.

    --
    Conversion Rate Optimisation French / English consultant
    1. Re:13 Meg GZ file no less by BinarySkies · · Score: 1

      Forget putting your own rear end on the line with deploying botnets to DDoS public sites, simply post a link to a large downloadable on a slashdot article and you get a very similar, yet much more legal effect :D

    2. Re:13 Meg GZ file no less by tronicum · · Score: 1
      I downloaded about ~ 300 kb (very slow) and did a zcat on the tar. So far it looks like automake stuff, so it looks like source code.

      13 MB is quite a lot if you compare it to 22 MB for the source of MySQL itself. I also wondered that he took "create table april "... as example. That points toward a prank...

    3. Re:13 Meg GZ file no less by Anonymous Coward · · Score: 0
      Anyone manage to dl it? I gave up a few minutes ago.


      Maybe they're counting that only people who actually need to download it, will?

    4. Re:13 Meg GZ file no less by krow · · Score: 1

      Turns out I had not done a "make clean" in the PG directory, so it was a lot larger then what it needed to be. I've updated the tgz with a smaller file.

      --
      You can't grep a dead tree.
  5. Seriously though...can someone explain it by Anonymous Coward · · Score: 0

    I know it's an April 1st joke, but I'm not a DBA or anything close...can someone give a quick summary as to why this is hilarious and people are currently LOL
    Are Postgres and MySQL completely incompatible or something? Like a Lotus 123 plugin for MS-Excel or something?

    1. Re:Seriously though...can someone explain it by Anonymous Coward · · Score: 2, Informative

      They're just rival DBMSes, that's all. It's not actually particularly funny.

    2. Re:Seriously though...can someone explain it by Anonymous Coward · · Score: 1, Informative

      The joke (which, like most jokes sounds lame when you explain it) is that MySQL has so many storage backends, why not use another database as a storage backend? Compatibility is not the issue, but rather the odd notion of designing a database system just to store data in some other database system. It would be similar to writing an entire file system that stored all the data in a specially formatted MS Word document.

    3. Re:Seriously though...can someone explain it by Just+Some+Guy · · Score: 4, Insightful

      can someone give a quick summary as to why this is hilarious and people are currently LOL

      Have you ever laughed at a hopped-up Dodge Neon with a whale tail and three rows of headlights? Well, imagine that the owner had found managed to buy a Ferrari, rip its engine out, and install it in the Dodge. It would be an interesting hack, but why not just drive the Ferrari in the first place?

      --
      Dewey, what part of this looks like authorities should be involved?
    4. Re:Seriously though...can someone explain it by Wdomburg · · Score: 1

      If that's an odd notion, then MySQL is odd already. Solid and Berkley existed as databases long before they become options for MySQL table backends. There would be some value to having a MySQL interface to the arguably more capable (for certain tasks) Postgres storage engine.

    5. Re:Seriously though...can someone explain it by vidarh · · Score: 1
      MySQL can already use another database as a storage backend through federation. The "benefit" a PostgreSQL storage engine would be that you could pick and choose whether PostgreSQL or InnoDB, MyISAM and all other other backends fits the requirements of your app the best without changing your database environment.

      It may have been an April Fools joke this time, but I wouldn't be the slightest bit surprised if someone actually went ahead and implemented this. There are far weirder MySQL backends, such as one that stores the data in a memcached server...

    6. Re:Seriously though...can someone explain it by Iron+Condor · · Score: 2, Funny

      It's kinda like someone making an add-on to firefox to allow it to use IE as a render engine in a given tab.

      Oh, wait...

      --
      We're all born with nothing.
      If you die in debt, you're ahead.
    7. Re:Seriously though...can someone explain it by shaitand · · Score: 1

      Fair enough, why would you put a crappy dodge Postgres backend on a Ferrari like MySQL?

    8. Re:Seriously though...can someone explain it by Just+Some+Guy · · Score: 1

      Fair enough, why would you put a crappy dodge Postgres backend on a Ferrari like MySQL?

      Well, that's not what I'd meant, but I suppose that still works for certain values of "Dodge" and "Ferrari".

      --
      Dewey, what part of this looks like authorities should be involved?
    9. Re:Seriously though...can someone explain it by turing_m · · Score: 1

      It's more like a vim (or even emacs) plugin for notepad.exe. Or a lifetime ticket to a well equipped free weight gym included in the price of a bowflex. Or Michael Bay directing a movie where the protagonist goes to a cinema and watches the Godfather in its entirety. Or GWB outsourcing his presidential duties to a random guy on the street. Or MacDonalds grinding up filet mignon to make patties. Or...

      --
      If I have seen further it is by stealing the Intellectual Property of giants.
    10. Re:Seriously though...can someone explain it by brer_rabbit · · Score: 1

      nice! someone mod that up.

    11. Re:Seriously though...can someone explain it by jadavis · · Score: 1

      The "benefit" a PostgreSQL storage engine would be that you could pick and choose whether PostgreSQL or InnoDB, MyISAM and all other other backends fits the requirements of your app the best without changing your database environment.

      (1) MySQL's "storage engines" cause different behavior at the semantic level. If you change storage engines, there's a good chance your queries will behave differently. What used to work may now fail.

      (2) PostgreSQL has sophisticated performance options which *are* transparent at the semantic level. If you add a GIN index, a GiST index, a functional index, etc., then that will not change the behavior of queries; only the performance. Even though it all uses the same "heap" to store the raw tuples, you can even modify that by changing the "fillfactor", etc.

      (3) PostgreSQL's optimizer is much more sophisticated than that of MySQL. If (when) MySQL's optimizer chooses a bad plan, it won't matter that PostgreSQL is the storage engine; it will still be slow.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
  6. The Lamest April Fools Story Yet by Anonymous Coward · · Score: 0

    C'mon, who's going to believe this one? It's like "OMG Postgres!!!!" No wireless over plumbing. Less space than The Pirate Bay. Lame.

    1. Re:The Lamest April Fools Story Yet by VJ42 · · Score: 4, Funny

      It's like "OMG Postgres!!!!" Perfect tag! :P
      --
      If I have nothing to hide, you have no reason to search me
  7. Mod me up! by apathy+maybe · · Score: 0, Troll

    I was going to make a comment about the date and how other people got modded up, therefore you could mod me up. But then I realised that the mods are probably sick of it by now. So, I'm instead simply asking that you don't mod me down.

    APRIL FOOLS! Mod me up please.

    --
    I wank in the shower.
  8. Eh by Spazntwich · · Score: 3, Funny

    5.1 is old. Wake me up when they've got a true 7.1 setup available.

  9. Can't hold my breath... by Epaminondas+Pantulis · · Score: 3, Insightful

    till they release a DBase III engine...

    1. Re:Can't hold my breath... by xarak · · Score: 1


      When I were young, we 'ad a DL/I and a beating a day we considered ourselves LUCKY.

      --
      Atheism is a non-prophet organisation
  10. SQL Server Engine? by Zebra1024 · · Score: 2, Insightful

    This would have been a better joke if it was Microsoft adding a SQL Server engine.

    1. Re:SQL Server Engine? by Master+of+Transhuman · · Score: 1

      One word: FoxPro.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
  11. MySQL teh suck? by Urusai · · Score: 2, Insightful

    I thought with MySQL going all corporate and proprietary-like, the bandwagon was jumping ship. MySQL always sucked anyway, unless you were operating a flat file type database. In conclusion, quit swinging on MySQL's nuts. Thank you.

    1. Re:MySQL teh suck? by isorox · · Score: 2, Insightful

      The only ways mysql gets into corporate machine are
      1) Grass roots simply installing it
      2) Snr Mgmt being dazzled by golf and wine weekends

      I can get my techliterate boss to point to a costly Mysql enterprise support package in those high up meetings where nothing really gets decided, but decisions float down from, and we are fine to dump Oracle for the latest 2000 queries/day intranet site.

      In reality the support will be mostly Usenet, but it keeps the suits happy knowing that it must be good because it has a corporation selling it.

      I can then arrange a junket to a mysql training course in some exotic country to teach something that could easily be learnt from online docs, but is ammo to go into bat with with suppliers that sold us a painful system to work with (load data from master on a database with 500MB of indexes and several updates per second is not a great way to ensure uptime, but they won't even entertain the idea of a mysql cluster at the moment. This "system" caused me 2 hours of grief this morning (fortunatly experience suggested that we'd need extended downtime).

  12. PLEASE STOP by Anonymous Coward · · Score: 0

    All the effort that went into these AF jokes and not one is funny.

    1. Re:PLEASE STOP by SirTalon42 · · Score: 1

      Effort? You seriously think the /. editors are putting any effort into this? Do you think they EVER put effort into /.?

  13. I for one... by Anonymous Coward · · Score: 0

    ...welcome our new, more [in]efficient database overlords.

  14. Digg this new rating system by Anonymous Coward · · Score: 0, Flamebait

    Hey . I really DIGG this new slashrating system! It's as if microsoft were in the room show the slash guys how to Innovate. My , we've come a long way. Didn't Oracle buy the mySQL transaction engine which meant mySQL were strategically dead in the water. It's a bit naughty to say that Oracle are supplying a plug in, they just bought the most important existing one to blow mySQL out of the water.

    However, I'm sure that the slashdotit is an April fool, just like postgres for mySQL.

  15. As long as it supports Parrot by itsdapead · · Score: 1
    This sounds like the ideal database backend for Parrot.

    That's the original combined Perl/Python scripting language, BTW, not the Perl 6 virtual machine that ripped off the name.

    --
    In a survey of 100 programmers, 111111 thought that duck-typing was a good idea.
  16. laugh if you like... by doom · · Score: 4, Interesting
    Laugh if you like, but you can actually do this trick the other way around, if you like:

    There's a project called "dbilink" that uses the fact that you can run perl inside of postgresql to use DBI to talk to other databases. You can use tables from a mysql database inside of a postgres database...

    1. Re:laugh if you like... by dfetter · · Score: 3, Informative

      Pardon the self-promotion, but you can find DBI-Link at http://pgfoundry.org/projects/dbi-link/ and on EPEL for RHEL/CentOS. Oh, and it's not restricted to MySQL. You can use any DBD with a certain minimal feature set, and I'm trying to reduce that minimum.

      --
      What part of "A well regulated militia" do you not understand?
    2. Re:laugh if you like... by conchur · · Score: 1

      Surely reducing the minimal feature-set isn't a step forward?

    3. Re:laugh if you like... by dfetter · · Score: 1

      > Surely reducing the minimal feature-set isn't a step forward?

      DBI-Link adds on the ability to access external data sources for read and write. It doesn't reduce any of PostgreSQL's capabilities :)

      --
      What part of "A well regulated militia" do you not understand?
    4. Re:laugh if you like... by Master+of+Transhuman · · Score: 1

      Badly worded, of course, but what he meant was that the number of features the TARGET database needed to be usable with DBI-Link was being reduced.

      In other words, he's trying to get DBI-Link to work with MORE databases in the future.

      Oh, wait, were you being funny?

      Never mind.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
  17. When to use then vs. Than by Anonymous Coward · · Score: 0

    Why can't these stupid kids learn the difference between then and than and just when to use the two.

    So often i get turned off from reading /. posts just because of horrible grammar.
    Well i guess this is one more reason that the school system is failing in this country, since kids graduate without the ability to communicate in their own language properly, and to think that Americans despise most immigrants because they don't speak english well either.

    1. Re:When to use then vs. Than by ScrewMaster · · Score: 1

      Why would you say that Americans despise immigrants? I mean, of all nations America is the one that has traditionally been a haven for immigrants from all cultures. We don't like the illegal ones, to be sure, but that has little to do with their English (given that the bulk of them can't speak it at all anyway and show little interest in learning.) It has more to do with the fact that their presence here is disruptive and causing major socioeconomic problems. In any event, hastily-written Slashdot posts are probably not the best way to judge a person's verbal skills anyway, although the writing around here does stink sometimes.

      On the other hand, I agree with you that America's school system is failing miserably when it comes to linguistic skills. I had a girlfriend who was a college-level English instructor (this was back in the mid-eighties.) A significant fraction of the incoming college freshmen she taught were unable to write in full sentences, and required remedial instruction in order to have a hope of functioning in a college environment. My understanding is that the situation has not improved, and is in fact worse. How our high schools manage to graduate functional illiterates is beyond me. No question the system is in deep trouble.

      --
      The higher the technology, the sharper that two-edged sword.
    2. Re:When to use then vs. Than by Master+of+Transhuman · · Score: 2, Insightful

      "of all nations America is the one that has traditionally been a haven for immigrants from all cultures"

      The operative word here is "traditionally".

      Once the immigrants got here, they immediately began discriminating against NEWER immigrants. Look at the histories of the Irish, the Italians, the Poles, the Russians, the Chinese, the Vietnamese, the Middle Easterners, the you-name-it.

      That hasn't stopped.

      It's human nature - if you're not one of "us" - for no matter how small a set of "us" (down to order 1 for me) - you're bad.

      Chimpanzees have better manners.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
  18. its self by Anonymous Coward · · Score: 0

    I believe the author meant itself

  19. MySQL vs Postgres by Redbaran · · Score: 1

    Thank goodness this was just a joke! For a second I thought we wouldn't be able to have flame wars over which one was better!

    The only thing worse would be a linux plugin for windows.

    1. Re:MySQL vs Postgres by Anonymous Coward · · Score: 0
      It's hard to tell if people are dumb or not, on this day... Cygwin --

      Cygwin is a Linux-like environment for Windows

    2. Re:MySQL vs Postgres by Lennie · · Score: 1

      You mean coLinux ?

      --
      New things are always on the horizon
    3. Re:MySQL vs Postgres by SirTalon42 · · Score: 1

      Actually I think CoLinux (http://www.colinux.org/) would be closer...

  20. Re:can someone explain it by symbolset · · Score: 0, Offtopic

    This evolution would bring together the legendary speed of postgresql with the phenomenal consistency and standards compliance of MySQL.

    Which is to say, it's completely backward -- a fusion of the worst of each.

    --
    Help stamp out iliturcy.
  21. Caffeine cigarette by steve426f · · Score: 0, Offtopic

    While reading about the new Postgres engine, i decided to order a couple things from ThinkGeek

    SurgeStix - Inhalable Caffeine Stix
    and
    Two finger volt-meter

  22. Help Needed: Error 2013 by ballmerfud · · Score: 5, Funny

    I compiled and installed the plugin and every time I try it, get the following:

    mysql> INSTALL PLUGIN postgres SONAME 'libpostgres_engine.so';
    ... where am I? Oh God no. No. NO!
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)
    kill(getpid(), 9)

    ERROR 2013: Lost connection to MySQL server during query
    --
    http://uncyclopedia.org/wiki/User:Steve_Ballmer
  23. dept.? by The+Madd+Rapper · · Score: 2, Interesting

    Is it notable that this story doesn't have a "from the ... dept." line? How common is that?

    --
    That's the shit that feds me up
    1. Re:dept.? by Agret · · Score: 1

      In Soviet Russia department writes you.

      --
      Have you metaroderated recently?
  24. Microsoft's ahead of you... by argent · · Score: 1

    The only thing worse would be a linux plugin for windows.

    Windows Services for UNIX

    Microsoft has been using this internally as a "killer app" for converting UNIX sites to Windows by not converting them to Windows for years:

    http://www.securityoffice.net/mssecrets/hotmail.ht ml

  25. this has been suggested before by Anonymous Coward · · Score: 0

    back when Oracle started buying up the good MySQL backends the some of the Postgres team drafted a letter to MySQL pointing out that since Postgres is available under the BSD license, they could use it as a reliable back-end for MySQL

    MySQL gets it speed from two things

    1. defaulting to an unsafe, but fast storage mechanism

    this is lost to a significant extent when a safe storage engine is selected. it's not at all clear that the Postgres storage engine would be any slower then the others (in fact, since the postgres team has been spending a significant amount of effort to speed it up over the years, it's likely to be in the right ballpark)

    2. not implementing the full SQL spec

    the second item would still give them a performance advantage over Postgres for the simpler benchmarks, even when useing the same engine (the cost of a connection and login to the database is considerably higher for postgres, which is why connection pools are more important for it then for MySQL)

    this is a very realistic thing to do, if this does end up being an April Fools joke (which, as others have noted, is odd, given that it's a 13M download) someone should actually do this some time.

    once this is done people could benchmark the Postgres engine against the various other safe MySQL engines, and they could benchmark the Postgres SQL logic (and planner) against the MySQL equivalent.

    the idea of having the option for the two major opensource databased to be able to really be compared in apples to apples tests would be good for both of them.

    David Lang

  26. Yeah but... by guruevi · · Score: 1

    are we going to have to start using VACUUM on MySQL now?

    --
    Custom electronics and digital signage for your business: www.evcircuits.com
    1. Re:Yeah but... by turing_m · · Score: 1

      I suspect that it would be automatically configured to use autovacuum.

      --
      If I have seen further it is by stealing the Intellectual Property of giants.
    2. Re:Yeah but... by Anonymous Coward · · Score: 0
      > are we going to have to start using VACUUM on MySQL now?

      No, it already sucks.

    3. Re:Yeah but... by suggsjc · · Score: 1

      Probably, but luckily Dyson is working on a Roomba killer. At least this way will have some competition in the automated database garbage collection tools.

      --
      When I have a kid, I want to put him in one of those strollers for twins and then run around the mall looking frantic.
  27. Anybody see the "Ballmer joins Linux Foundation" by Master+of+Transhuman · · Score: 1

    story? That was much funnier than this one.

    The only funnier one would be "Richard Stallman hired as Microsoft open source evangelist."

    (Now I wait for the FSF fanatics to tell me the difference between "open source" and "free" software - because they can't take a joke either...)

    --
    Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
  28. Re:Anybody see the "Ballmer joins Linux Foundation by Anonymous Coward · · Score: 0

    Ok, see, there's two types of free, one is free as in beer and the other is free as in no free beer. And open source is when you get a recipe to make this free beer. The problem is, all the good beer runs on Windows and the other beer tastes like penguins or cartoon characters.

    Ok, too confusing, let me try it again.

    See, one is free as in beer and the other is... wait a sec, I was promised free beer. WTF?! What do you mean there's no free beer left?! Ok, this is like the difference between open source and free software, and that is...

    forget it, I'm getting a beer.

  29. Colt by Joseph_Daniel_Zukige · · Score: 1

    Friend used to soup up the Dodge Colt, bore the engine and stuff, for a fast quarter-miler.

    The engine was a Mitsubishi at the time.

    Some guys would pull the engine and mount it on a funny car chassis, IIRC.

    And I always wanted to put an airfoil on the back of my Colt station wagon. And an air ram on the front.