> I am hoping that I am posting this question to the proper list.
> I inherited a team of programmers that have the responsibility to create
> mailing lists. Each member uses MS SQL, with either DTS, or SSIS scripts,
> and has his own customers that makes them subject to peaks and valley’s. I
> am attempting to cross-train as well as standardize the processes to make it
> easier to balance the workload.
> In looking forward, I am getting close to the point of having to add to the
> team, and after reviewing numerous resumes, have decided that the process we
> do, doesn’t really require high level SQL programmers, but does require a
> good understanding
> of database structures and the tools necessary to mine data.
> At the same time, I am looking at reducing cost and thought about switching
> from MS SQL to MySQL. I also thought of adding some kind of GUI front-end
> in order to use less technical people to process data requests. In talking
> with a customer support person at a company that develops front-ends, he
> suggested looking into PostgreSQL and that is why I am here.
> I did not see references to anyone moving from an MS SQL environment to
> PostgreSQL and was curious if anyone has had experience doing that? Also,
> are there any suggestions for front-ends? I need something that can
> generate SQL commands but also allow a passthrough if someone needed to
> write their own.
> I’d like the flexibility to increase my team at a minimal cost as we
> increase volume.
> Any thoughts?
My open source project "The Karoo Project" http://www.zwartberg.com/karoo
does include a set of tools for creating web applications with minimum
"programming". The only programming required is SQL, plsql (optional),
The Karoo Project is actually aimed at making it easy to create large
scalable services in C++, but it so happened that I needed a web front
end, so I added the "surf" front end (which I was just describing).
If you are interested, let me know. the documentation needs writing,
so I'll have to help you a bit.
Otherwise, my advice is that postgresql is better than mysql, though I
have not found any good tools for creating database applications,...
which is why I wrote "surf".
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
In response to
- SQL Server at 2009-11-05 18:06:29 from bob.vanslobig
pgsql-novice by date
|Next:||From: Thomas Løcke||Date: 2009-11-06 08:53:21|
|Subject: Table design for basic user management|
|Previous:||From: Tom Lane||Date: 2009-11-05 22:14:40|
|Subject: Re: Cannot do time-aligned listing with FULL JOIN, get ERROR: FULL JOIN is only supported with merge-joinable join conditions |