14 posts tagged with postgresql.
Displaying 1 through 14 of 14. Subscribe:

Convert a MySQL schema to PostgreSQL

I have a MySQL schema dump. I need to convert it to PostgreSQL. The data is not important right now; I just need to deal with the schema. [more inside]
posted by vogon_poet on May 16, 2015 - 12 answers

Connecting to Postgres through Powershell/Changing Username

I'm trying to log on to Postgres using Powershell and it's not working. I did this before a little while ago and now I can't remember how I did it and it's driving me crazy. [more inside]
posted by Mrs. Pterodactyl on Jun 4, 2014 - 8 answers

Moving from PostgreSQL to SalesForce with Rails 3

If feasible, how do you move the database backend of a Web application built with Rails 3.2 from PostgreSQL to Salesforce (or Database.com)? [more inside]
posted by remi on Jul 19, 2012 - 0 answers

Why do you torment me so?

Is there some killer feature of MySQL that explains its wide use relative to PostgreSQL? [more inside]
posted by wierdo on Mar 2, 2012 - 17 answers

Should I partition really big PostgreSQL tables?

Is it worth partitioning big (>1.5TB) tables in PostgreSQL? Most partitioning stuff seems to be based on the idea of sequential data, where older data is moved off onto secondary hardware or something, but this data is all equally important. I can't figure out if partitioning would be a win when all rows are equally likely to be accessed. If it makes a difference, most queries will access only one row, but multiple row queries will span multiple partitions regardless of the partitioning criteria I choose.
posted by Nothing on Jan 28, 2011 - 10 answers

Multi users on one system and Access

I posted a previous question about fixing permissions on an Access/PostGreSQL d/b I use at work. Now what I'm attempting to do is enable using Access with multiple users on the same machine. [more inside]
posted by diode on Apr 14, 2010 - 5 answers

MySQL and I don't get along.

Open-source blogging with Postgres. [more inside]
posted by enn on Jan 26, 2010 - 7 answers

Visual database browser?

Is there a visual, gui database browser that would let me select a data field and show value of data field in a different table that is referenced by first data field? [more inside]
posted by rainy on Aug 13, 2009 - 6 answers

MySQL vs PostgreSQL?

What's the hive mind's opinion on MySQL vs PostgreSQL? [more inside]
posted by xmutex on May 22, 2008 - 24 answers

Blog software that supports PostgreSQL

I'm interested in moving away from Moveable Type for my blog. Unfortunately, the only DBMS my webhost provides is PostgreSQL. Wordpress doesn't support it. Blosxom seems promising, but I'm behind a firewall and proxy at work, so web-based management is a must. I'm very technical; enough so that I'm considering writing my own blog CMS, and only the time investment is holding me back. What are my options? What do you recommend?
posted by Plutor on Aug 24, 2005 - 10 answers

A better tool that pgAdmin?

What's a good, free database designing/administrating tool which works with postgresql? I've been using pgAdmin III, and while that does the basics, it doesn't have useful features like a buffer of previous queries and their results. [more inside]
posted by orthogonality on Apr 26, 2005 - 5 answers

Beginner level PHP / mySQL project tutorials

GeekLearningFilter: I need to learn how to do some fun stuff with php and MySQL or PostgreSQL. Of course I shall expand on this within... [more inside]
posted by Dreama on Jul 19, 2004 - 5 answers

DB Interfaces and the comparison thereof

I'm looking at database packages and wondering if anyone has had first-hand experience with direct interfaces for PostgreSQL, SQLite, BerkeleyDB or MySQL, either of the command-line variety or via a web-based GUI? I'm very familiar with phpMyAdmin but that's where my experience stops. How might the above compare with phpMyAdmin?

Mind you, I already understand the features/benefits/drawbacks of the databases themselves. It's the interfaces (especially web-based) that I'm interested in.
posted by fooljay on Apr 13, 2004 - 12 answers

Photoshop Gradients

Photoshop gurus: I've got a rectangular photo, which I plop down in the middle of a colored background. I'd like to create a smooth transparency gradient in the photo with respect to the background (more transparent at the top, opaque at the bottom). How would one do this?

(Specifically, I'm contructing a header image for a website... the top of the header is a solid color, with logo, etc. in it, while the bottom of the header is the photo. I'd like the solid area to dissolve into the photo).

Thanks- if anyone ever needs PHP/Postgresql advice, let me know!
posted by gsteff on Mar 23, 2004 - 6 answers

Page: 1