On what technologies to do the project?

Question

MySQL

The project itself is a program and a website. Both work with the same base. Website in php + MySQL database. But with the program I can not decide. There are options for C#, java, etc.
Requirement for the program: -
adding data - searching
for data
- quick correspondence, such as internal Icq (simplified) - creating
and working with a local database
What options are
C # + mysql. But C, as I heard, works with other databases for a fee, and not with MS SQL, and is not stable.
Java + mysql But for such an application, you will have to install Java extensions on your computer. Not very comfortable.
C#+MS SQL. But the php site will be from scratch. I will write. Never wrote in php to work with ms sql.
What would you recommend to choose.
For information, the program and website are intended to process applications for real estate between agencies.

Answer 1

Why standalone applications at all? Why not make everything web-based?

Answer 2

Is writing everything in C# not an option? The website is asp.net, the program is C#. And there will be no compatibility issues.

Answer 3

Make an API on the site and pull it from the application. If that's what it takes. The most flexible solution, reduces the connectivity of parts.
> But With as I heard paid works with other DB, instead of with MS SQL and it is not stable.
some crap. www.mysql.com/downloads/connector/net/ everything is free, stable. Another question is that all sorts of c# goodies like LINQ do not work with mysql.
> C#+MS sql. But the php site will be from scratch. I will write. Never wrote in php to work with ms sql.
in terms of php, the difference is minimal. Instead of one function, call another, but in general the site should be abstracted from the database, and there should be a layer layer that allows you to migrate from one database to another. The only question is that the SQL itself in MS SQL Server is slightly different from MySQL. You apparently don't know him.
I won’t say about Java, because I don't write on it.
In general, the very fact that you want to hit a remote database from your application (the same one the site works with) is strange. What will you do if port 3306 (or whatever mysql has) is closed in a real estate agency (and this is most often the case, everything is closed except 80)? And if they have an Internet through a proxy, and not SOCKS5, but HTTP (and this is how it most often is)? What will you do with your architecture when you want to check access rights to different objects? How do you prevent the user from editing some rows in the table at the database level and allow editing others? What will you do when you need to change the database structure? Reinstall all 100500 deployed clients because crooked requests are already hard-coded there, and during the reinstallation the whole system will rise (the database has already been updated, but the clients have not yet)?
I repeat - the only right decision is to make an API on the site and pull it out of the application. If everyone wrote in c#, I could advise you to do Web Service, and with php you will most likely have to invent the interaction standard yourself. Without further ado, you can simply pass XML between the site and the program. The program sends XML with request parameters by POST, receives XML with the response, XML processing is available in both c# and php. Or you can use json, but XML is better, it is better supported in c#. Such an architecture will reduce the coherence of parts of the system, add additional levels of abstraction, and free your hands for further development.

Answer 4

I would also make an online application, today there are all the necessary opportunities for this.

Answer 5

It’s okay that everything will work on .NET, the site on asp.net (it’s not so scary), and the application on winforms, you don’t need to write the same code twice - the core is one.
Otherwise, I would suggest using other desktop platforms than .NET.
Otherwise, the whole meaning is lost.

Answer 6

I am currently developing a C# + MySQL program. Of course, such performance as in a bunch of C # + MSSQL cannot be achieved, but everything works stably, without failures. You need to use the connector suggested by Yavanosta . Everything is free.

Answer 7

The site is most likely to be raised on some cms. Then you can use modx by adding the module you need to it. And he knows how to work with MS SQL out of the box.

Answer 8

> Java+mysql But for such an application you have to install Java extensions on your computer. Not very comfortable.
Well, you still have to install the mysql server, right? So I don't see any problem in installing JRE. That's why it's cross-platform.

Answer 9

How many users are expected?
What happens when two users change an object in their databases differently? How to sync it to the server?
What about general directories?

Answer 10

I recommend doing the program in Qt. First, it will run faster than Java or C#. Secondly, unlike C#, it will be completely cross-platform (and additional clients for the same money are very good).