Re: Newbie and Debian.

From: Eris (vithant01_at_antispam.comcast.net)
Date: 09/17/04 

Date: Thu, 16 Sep 2004 19:25:22 -0400

On Thu, 16 Sep 2004 23:08:10 +0100, Andy Fraser
<andyfraser31@hotmail.com> wrote:

>In alt.os.linux, Eris uttered these immortal words:
>
>> O.K. I am an old fart. I am just getting into networking, web. Want to
>> set up something my kids can access from there homes in Michigan and
>> Virginia.
>
>Ok. To do what though?
>
>> I have worked on Microsoft SQL Server for years, would like to learn
>> the Linux equivalent and kiss Microsoft good bye.
>
>There is no "the Linux equivalent", not directly anyway. Depending on what
>you want to achieve you could use MySQL or PostgreSQL as I said earlier. It
>depends what features you want though. For example, dynamic Linux-based web
>servers tend to use MySQL because it's small, fast and easy to admin,
>especially for newbies to RDBMSs, but lacks some of the advanced features
>of PostgreSQL and SQL Server.
>
>It sounds like you know what you're doing so maybe PostgreSQL would suit you
>better. Maybe you don't want advanced features and want an easy life in
>which case MySQL may be better. Check them both out and see which one fits
>your purpose. Linux is about choices after all. :-)
>
>> Python is it a decent way to access mySQL or PostgreSQL?
>
>I guess. I've never programmed in Pythin though. I use PHP, Perl, C and C++
>to access MySQL programmaticaly. I don't need the features of PostgreSQL so
>I don't run it very often.
>
>> I guess that an Access or C# interface would be nice.
>
>There's no equivalent to Access yet. Developers are working on it but I
>haven't seen anything that comes close yet. There's a MySQL ODBC driver for
>Access if that helps. You can access the MySQL server on a Linux box over a
>network with it.
>
>> Do I have a GUI
>> to work with in Linux? Forms?
>
>phpMyAdmin is the best I've used for MySQL. It requires a web server that
>works with PHP and PHP installed to work. There's phpPgAdmin for
>PostgreSQL. If you want to create applications a la Access you'll have to
>code it yourself if you can't find a ready-built one that suits you. For
>the time being at least.
>
>> Thanks for all your help, I appreciate it.
>
>I think I'm starting to repeat myself now. It's hard to offer anything
>constructive without knowing exactly what you're going to do. Unfortunately
>the one area where Linux is lacking is in GUI database stuff. Apart from
>that I'm not sure what you're asking so I've posted some general info that
>may point you in the right direction. :-)
You did good thanks!
Basically I never want to use Microsoft again.

Relevant Pages

  • Re: Data Redundancy
    ... MySQL & PostgreSQL each have database-specific replication options. ... For non-database files, ... I have a server that i need to mirror elsewhere for data redundancy ...
    (Debian-User)
  • Re: Newbie and Debian.
    ... There is no "the Linux equivalent", ... you want to achieve you could use MySQL or PostgreSQL as I said earlier. ... of PostgreSQL and SQL Server. ...
    (alt.os.linux)
  • Re: How about MySQL in 64bit Debian?
    ... How about MySQL server in 64bit Debian? ... We also use PostgreSQL, which I happen to prefer, also no problems. ... I'm new to PostgreSQL and MySql, which database server should i use ...
    (Debian-User)
  • Re: Sharing of SSL certificates by different applications
    ... server. ... I am configuring other servers like PostgreSQL, MySQL, Postfix ... Is it possible for the same certificate to be used by all these ...
    (comp.infosystems.www.servers.unix)
  • Re: Running large DBs on FreeBSD
    ... so much better about PostgreSQL? ... I understand that it has some more advanced features, but if they are not used, then what is the advantage? ... we can go on forever on this tangent. ... i'd recommend finding the "gotchas" pages for both mysql and postgres and decide which is the lesser of evils for your app and go with it. ...
    (freebsd-stable)