473,545 Members | 2,047 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Tutorial for DB-Frontend with GUI

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
2 11550
> 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
em**********@ya hoo.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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1705
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 data every week and deleting the old data. Many Thanks
4
5803
by: Chuck Amadi | last post by:
Hi all Anyone know a good Pygresql Tutorial for Interfacing between Python & Postgresql . Cheers Chuck
5
2995
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 simple tutorial anywhere on the web about using python + mysql?
7
4524
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 have no experience of ASP or dreamweaver. I have office xp pro and am in the process of buying and installing win xp pro. Is there anything else I...
2
1376
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 code so I have more control over it. Thank you.
9
4158
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 honest I usually hire someone to do it for me, grab predone scripts and kind of hack out the parts that I need, or just do very minimal validation...
8
1507
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 create a sophisticated asp.net application in VS. I can find my way around the basic VS interface easily enough thanks to a generic VS class I took,...
2
1227
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 updating and inserting gives me a headache. And trying to Google for it is a bit hard when 'Access' is called 'Access' :)
0
910
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, Create the Access form, and "SEE" the data I earlier manually placed data in the DB outside of my application. However, using my application I cannot...
17
46481
Motoma
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: The goal of this tutorial is to design a Data Abstraction Layer (DAL) in PHP, that will allow us to ignore the intricacies of MySQL and focus our...
0
7475
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
1
7436
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7766
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5341
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
4958
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3463
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1897
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1022
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
715
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.