[Gllug] Writing C

[Richard Huxton]

Nordlund, Niko wrote:
>  
> SQL. I would need a SQL database engine that is, stable, can handle large
> databases (> 2GB), easily extendible with own functions (at least postgreSQL
> supports dynamic loading of functions written in c)

Postgresql. Oh, and you can write functions in a whole range of languages.

> Graphical interface for developing and administering the SQL database. 

I'd suggest pgadmin (http://www.pgadmin.org), if you want web-based 
access then phpgadmin (http://phppgadmin.sourceforge.net) - or RedHat's 
java-base database tools if you're that way inclined (google for rhdb)

> C. As indicated above I would need to do a bit of C coding to get my
> functions available within SQL. I have some experience in using VB, but I
> would like to move over to C. Any suggestions which editor and compiler
> would be easy to learn? Preferably a nice GUI. I would also need to pass
> data to and from a database. Also, recommendations on what C-books to read
> are welcome. 

No need to - stick to what you know. However, most *nix coders don't go 
the all-in-one devkit route but rather mix and match their favourite tools.
If you're used to VB, perhaps move over to Python/Perl.

> Intranet tools to SQL. We are, at the moment, using VB to pass info between
> our intranet pages and SQL. What would be the easiest Open Source way of
> doing this?

PHP (http://www.php.net) is perhaps the most popular asp-style setup. 
Don't forget that PostgreSQL has ODBC support, so you might be able to 
move over one step at a time.

> VNC. I would like to give a "thin client" a go. Obviously on local network
> we have enough capacity to run X window, but going to another continent
> would need something else. My issue relates to user authentication in VNC.
> Then there is the question of how to do this in a secure fashion.

I think there is an SSL-carried version of VNC, but I always tunnel 
through ssh. You can use putty on Windows 
(http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html).

One thing I would strongly recommend - take it slowly. Identify one 
thing at a time to change and make sure you understand that setup before 
moving on.

-- 
   Richard Huxton
   Archonet Ltd
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug