LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-10-2015, 10:01 PM   #1
Nabeel
Member
 
Registered: Nov 2009
Location: Pakistan
Distribution: Ubuntu
Posts: 294

Rep: Reputation: 17
DBMS for a Client


A client asked me to create a Database for his school, to house all the student records etc. This isn't usually what I do as I am doing my Major in Game programing. Now I went with Access or Base but they both will need to be installed on his machine. I tried going with SQLite But it doesn't have a front-end. So in short, I want to devalop A SQL baseed DB with a simple GUI Frontend. Where Should I head now, Or Any books which feature such cases. The database will be initially be offline.
 
Old 01-11-2015, 11:17 AM   #2
veerain
Senior Member
 
Registered: Mar 2005
Location: Earth bound to Helios
Distribution: Custom
Posts: 2,524

Rep: Reputation: 319Reputation: 319Reputation: 319Reputation: 319
Go with MariaDB or Postgresql. Both are open source and free.
 
Old 01-11-2015, 01:39 PM   #3
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,933

Rep: Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692
Quote:
Originally Posted by Nabeel View Post
A client asked me to create a Database for his school, to house all the student records etc. This isn't usually what I do as I am doing my Major in Game programing. Now I went with Access or Base but they both will need to be installed on his machine. I tried going with SQLite But it doesn't have a front-end. So in short, I want to devalop A SQL baseed DB with a simple GUI Frontend. Where Should I head now, Or Any books which feature such cases. The database will be initially be offline.
Similar to what you asked FOUR YEARS AGO, isn't it?
http://www.linuxquestions.org/questi...ttware-901597/
 
Old 01-21-2015, 07:45 PM   #4
Nabeel
Member
 
Registered: Nov 2009
Location: Pakistan
Distribution: Ubuntu
Posts: 294

Original Poster
Rep: Reputation: 17
Quote:
Originally Posted by veerain View Post
Go with MariaDB or Postgresql. Both are open source and free.
That is altough An excellent recommendation, I already have the database ready in SQLite. I just want to create a Frontend/Interface for that database, Since I am not satisfied with access or base forms as they give too much access to the user. I tried googling for such but nothing worthwhile came. If any one here could suggest some book or referance other open source projects , Preferably ones that create this interface with python. I hope I am being understandable as english is not my first language so I usually struggle with it.

Quote:
Originally Posted by TB0ne View Post
Similar to what you asked FOUR YEARS AGO, isn't it?
http://www.linuxquestions.org/questi...ttware-901597/
This was back when I was a College Fresh Men, I needed that for my college assignments.
 
Old 01-21-2015, 08:50 PM   #5
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,933

Rep: Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692Reputation: 3692
Quote:
Originally Posted by Nabeel View Post
That is altough An excellent recommendation, I already have the database ready in SQLite. I just want to create a Frontend/Interface for that database, Since I am not satisfied with access or base forms as they give too much access to the user. I tried googling for such but nothing worthwhile came. If any one here could suggest some book or referance other open source projects , Preferably ones that create this interface with python. I hope I am being understandable as english is not my first language so I usually struggle with it.


This was back when I was a College Fresh Men, I needed that for my college assignments.
And the answer hasn't changed. There are THOUSANDS of very easily found tutorials for accessing MySQL with Python, Ruby, PHP, Perl, and pretty much every other language. Again, as you were told years ago, migrate your data from one database to another, and move forward.

Last edited by TB0ne; 01-22-2015 at 01:32 PM.
 
Old 01-22-2015, 01:29 AM   #6
ndc85430
Member
 
Registered: Apr 2014
Distribution: Slackware
Posts: 92

Rep: Reputation: Disabled
I'd write a small web application for the user to manage their records. There are many web application frameworks for Python - Django is a popular one, but I'm using Flask for a small project.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
DBMS and RAID Performance Triton46 Linux - Hardware 2 12-16-2011 10:51 AM
Is there a good DBMS client tool for Linux? jdruin Linux - Software 0 12-03-2008 09:13 AM
Installing PostgreSQL DBMS Hady Linux - Software 1 04-28-2004 06:44 AM
Postgres DBMS??! Hady Linux - Newbie 4 04-27-2004 04:19 PM
which DBMS to learn rvijay17 Linux - General 11 03-17-2003 03:38 PM


All times are GMT -5. The time now is 09:19 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration