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]
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]
Is there some killer feature of MySQL that explains its wide use relative to PostgreSQL? [more inside]
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.
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]
Open-source blogging with Postgres. [more inside]
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]
What's the hive mind's opinion on MySQL vs PostgreSQL? [more inside]
I'm interested in moving away from Moveable Type for my blog. Unfortunately, the only DBMS my webhost provides is PostgreSQL
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?
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]
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]
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.
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!