LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   DBMS for a Client (https://www.linuxquestions.org/questions/linux-newbie-8/dbms-for-a-client-4175530655/)

Nabeel 01-10-2015 09:01 PM
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.

veerain 01-11-2015 10:17 AM
Go with MariaDB or Postgresql. Both are open source and free.

TB0ne 01-11-2015 12:39 PM
Quote:
Originally Posted by Nabeel (Post 5298931)
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/

Nabeel 01-21-2015 06:45 PM
Quote:
Originally Posted by veerain (Post 5299148)
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 (Post 5299224)
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.

TB0ne 01-21-2015 07:50 PM
Quote:
Originally Posted by Nabeel (Post 5304775)
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.

ndc85430 01-22-2015 12:29 AM
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.


All times are GMT -5. The time now is 11:04 AM.