Tutorial for DB-Frontend with GUI

Al Bogner

Since weeks I am searching the net from time to time how to build a
small MYSQL-Frontend for a simple small database. The last decision
ist not made, but it looks like, that I will learn Python.

The (non-commercial) DB-frontend should run on a Linux-system only
and it would be nice, but not necessary, if the program could be
ported to Mac or Windows later for free.

I found a lot of interesting links like

http://wxpython.org/
http://boa-constructor.sourceforge.net/
http://www.die-offenbachs.de/detlev/eric3.html
http://doc.trolltech.com/3.2/designer-manual-8.html
http://doc.trolltech.com/3.2/sql.html
http://vtcl.sourceforge.net/
http://starship.python.net/crew/mike...x/Spectix.html
http://pythoncard.sourceforge.net/

It's hard to decide, which one is the easiest way for for a
python-beginner. How reliable is boa-constructor? 0.2.3-alpha seems
to be not very stable.

So, does anyone know a tutorial/howto/link or whatever how to build
a database client with a GUI? Is there a sample database-fronted
built with python in the web, where one can see what is possible?

All recommendations are welcome!

Al

Jul 18 '05 #1

Subscribe Post Reply

11541

email9898989

> So, does anyone know a tutorial/howto/link or whatever how to build

a database client with a GUI? Is there a sample database-fronted
built with python in the web, where one can see what is possible?

Pythoncard includes a dbBrowser sample. But really you can use any
GUI toolkit with the mysql python module:
http://sourceforge.net/projects/mysql-python
http://www.devshed.com/Server_Side/P...SQL/print_html
http://www.codespark.net/v2/articles.asp?CategoryID=45

See also SQLObject which might be a nicer way to do the MySQL coding:
http://sqlobject.org/

Jul 18 '05 #2

Al Bogner

em**********@yahoo.com wrote:

So, does anyone know a tutorial/howto/link or whatever how to
build a database client with a GUI? Is there a sample
database-fronted built with python in the web, where one can see
what is possible?

Pythoncard includes a dbBrowser sample. But really you can use
any GUI toolkit with the mysql python module:
http://sourceforge.net/projects/mysql-python
http://www.devshed.com/Server_Side/P...SQL/print_html
http://www.codespark.net/v2/articles.asp?CategoryID=45

See also SQLObject which might be a nicer way to do the MySQL
coding: http://sqlobject.org/

Thank you for your valuable links!

What are the cons of Spectix? Specitx was the only tookit, which
worked immediately with SuSE 8.2.

The installation of boa-constructor-0.2.3 didn't work, also there
were problems with the installation of eric 3.2.

Al

Jul 18 '05 #3

by: Knigh7 | last post by:

Hi, Could anyone provide me with a sample code, tutorial, or any other direction in which i can upload a CSV file to a mysql databse; its for a small db where the user uploads the CSV with new...

PHP

Anyone know a good Pygresql Tutorial for Interfacing betweenPython &Postgresql

by: Chuck Amadi | last post by:

Hi all Anyone know a good Pygresql Tutorial for Interfacing between Python & Postgresql . Cheers Chuck

Python

An mysql-python tutorial?

by: Dfenestr8 | last post by:

Hi. Been told by the admin of my (free!) server that he'd rather I should learn to use mysql if I want to continue writing cgi scripts there. Not even sure exactly what mysql is. Is there a...

Python

Beginner asp tutorial required + dreamweaver or FP

by: Colin Kingston | last post by:

Hi I have reasonable experience with access. I am just about to start a web based database project for my computer course. I have very very limited experience of frontpage, VB & VB script, I...

ASP / Active Server Pages

looking for tutorial for DB access

by: Dragon | last post by:

Hi, I am looking for a tutorial for DB access to use with VB.net (2005). I know how to go through Server Explorer, drag and drop tables etc. I am more interested in getting all this done via...

Visual Basic .NET

Best form validation tutorial?

by: julie.siebel | last post by:

Hello all! As embarrassing as it is to admit this, I've been designing db driven websites using javascript and vbscript for about 6-7 years now, and I am *horrible* at form validation. To be...

Javascript

VS2003 Tutorial?

by: EPPack | last post by:

I have a full, legal copy of Visual Studio.net 2003 on my work machine, I don't need the free product that was suggested , (unless it has a built in tutorial). However, I have no major clue how to...

ASP.NET

Dataset, Access DB tutorial

by: Søren Reinke | last post by:

Hi there Does anyone know where i can find a good tutorial on how to use Access DB together with datasets and webpages ? I can easily get it to work when wanting to select data fra Access, but...

Visual Basic .NET

Noob Help with Tutorial Needed :>

by: Frustrated LDAP administrator | last post by:

I am trying this lesson involving DBs. "ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_vbcnexpress/html/caf3ecbd-87f5-4748-b990-7395409a19c7.htm" I can successfully create the DB,...

Visual Basic .NET

Creating a Data Abstraction Layer in PHP

by: Motoma | last post by:

This article is cross posted from my personal blog. You can find the original article, in all its splendor, at http://motomastyle.com/creating-a-mysql-data-abstraction-layer-in-php/. Introduction:...

PHP

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Tutorial for DB-Frontend with GUI

Similar topics