0

I’m an intermediate programmer, I would want to create a software to manage a cycling race. Basically I have to deal with a database, (order partecipants, compile PDF files with rankings and so on…) but i’d rather not use Access… Any advice?

closed as off-topic by Izzy Sep 1 '16 at 16:27

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Is this question about a programming language or about a database? And frankly, for what you currently describe you can use almost anything. This question needs much more information to advise one over the other. Start with editing your question to answer my first question + is this online or local? + what budget do you have? + what OS?, then add more info – Jan Doggen Sep 1 '16 at 12:51
1

Python is probably the best if you don't want to redistribute your program. It's easy and quick to write and has tons of libraries.

pdfrw - a library for reading, morifying and writing PDFs
sqlite3 - simple sqlite library (included with python)

I think the simplest apporach to your problem is to create a sample PDF in some office program and use it as a base for creatnig leaderboards.

Then load the database in python and add the data into the PDF with pdfrw. If you run cycling races you could also store all of the data in one seperate database and render some statistic graphs with matplotlib and put them in your PDF or your website.

PyQt4 or tkinter are nice if you want some GUIs. I'd say to go with PyQt4.

  • I'm not sure why this answer was given a down vote, it covers the language, PDF and database requirements. The only downside could be the "if you don't want to redistribute" part, as writing in Python wouldn't affect its ability to be redistributed – gabe3886 Sep 1 '16 at 14:08
  • @gabe3886 Yeah, I don't know why I wrote that. Probably because of my experience with compiling PyQt4 and SIP. – Ciprum Sep 1 '16 at 18:29
0

Visual Studio 2015 is an option to consider. Microsoft provides a free community version. You can write code in C#. There is a drag and drop designer included that makes it easy to build UI applications and also bind to data in databases. Windows Forms, WPF and UWP are options for desktop based UI platform.

Syncfusion provides UI controls and file parsing libraries for all of the above platforms.

Essential PDF can be used to generate PDF files.

Visual Studio 2015

The whole suite of controls and libraries is available for free through the community license program if you qualify (less than 1 million USD in revenue). Note: I work for Syncfusion.

Not the answer you're looking for? Browse other questions tagged or ask your own question.