Hi, I have several questions about the C languages and the Geany IDE for the Raspberry Pi. Also a question at the end about spreadsheets and databases.
Question #1: Does C# count as being in the C/C++ camp?
Question #2: It's my understanding that C# is built upon C. Does this mean that I can write C programs in a C# IDE by simply only using syntax and commands compatible with C and avoiding any syntax or commands that are specific to C#?
Question #3: I have a copy of Geany for Windows. It's a GUI editor. According to their website it is compatible with C, C# and C++ among other languages as listed here. Is that right? I haven't really used it yet. All I've done is open the editor and looked it over briefly.
Question #4: One reason I downloaded Geany for Windows is because I understand that Geany also runs on the Raspberry Pi and can be downloaded using apt-get Geany. The question here: Is the Pi version of Geany a GUI editor that runs on the Pi Desktop, or is it just a command line compiler? I haven't installed it yet on the Pi. Also, will it compile all three too, C, C# and C++?
Question #5: If I write C console programs in the Geany Windows GUI editor, can I then copy that source code to a text file and compile it with Geany on the Raspberry Pi so the programs can run on the Raspberry Pi? The reason I'm asking is because it's much easier to type and edit the source on my Notebook than on my Raspberry Pi.
Question #6: This is just a general question about C/C#/C++ in general. Where can I find a good tutorial for writing an interface program to a spreadsheet or database? I need a tutorial that starts out really simple. The main thing I want to do is store information from the C program in a spreadsheet format that I can also open in Libre Office. I'd like to be able to edit the information from either place. In other words, I want the C program to be able to add, delete, or change the data, but I would like to also retain the ability to manually add, delete or change the data outside of the program as well using Libre Office.
Question #7 Database Question: This question isn't specific to C programming. But I'm just curious what the difference is between a spreadsheet and a database? I use spreadsheets all the time, but I haven't really used the Libre Database. Are they basically the same thing with the database simply offering a different user interface and better query options? Also if I started out with just programming to a spreadsheet could I update that later to a full database without loss of effort? Or would it be better to learn the structure of a Database first and then program directly to that?
Thanks in advance for all replies, suggestions, and comments.