Web UI frontent for SQL Server

@gunnagMar 27.2021

Hi,

I would like to develop a web UI frontend for a Microsoft SQL database. However, I find it difficult to choose the right technology.

It should be a SPA. The cross-platform Web UI should obtain and display data from an SQL server.
What would a good technology stack for the frontend?

Since I have little experience with js-frontend-frameworks, I tend towards a simpler solution like React or Vue. But I’m not sure if this is the right choice at all.

Can someone advise me what would be right here?
Maybe Ionic or Bootstrap could also be a good choice?

Thank you

Gunnag

to post a comment

Full-stack Developer JavaScript

5 Comments(s) _↴

@sibertMar 28.2021 — #> @gunnag#1629705 I would like to develop a web UI frontend for a Microsoft SQL database. However, I find it difficult to choose the right technology.

Interacting with a SQL database may need both frontend (Vue etc) and backend (PHP, Node.js, Python) or why not Go. I have played with Go against Postgresql and found it an interesting choice. http://94.237.92.101:6060/newposts . The "frontend" in Go is about add data to a html template (Angular sort of). Basically you can use vanilla Javascript or React components or what ever you like. In my experiment, I use no magic. Just plain html, css and vanilla Javascript.

@gunnagauthorMar 28.2021 — #First of all, thank you for your help. That helps a lot.

I'm trying to be a little more specific:

- The application should become a product, not just a private game/gimmick.

- Above all, flexibility in the UI would be important, i.e. you should be able to arrange widgets and tiles in any way you want. In the respective tiles it should be possible to display different data records (columns) from the SQL database. Of course, other things should also be shown in the UI, e.g. plots or barcharts. Flexibility is important because different user groups want different data to be specially prepared here.

- The web UI should be able to run on desktop (windows 10, windos server) but also tablets (iOS). So I suspect cross-platform development is necessary

- It is also important that your own icons / widgets can be "planted" in the UI. The more UI elements are available, the better so that you can make a suitable selection.

- All in all, it should be a professional web UI for customers, but unfortunately I have little experience with web UI development. An easy entry (fast time to market) with little maintainability would therefore be desirable. Low maintainability should mean: If there is a small change, it should be able to be integrated with little effort.

Unfortunately, there are thousands of solutions and I am overwhelmed by the right choice of technology stack. If you could point me in the right direction here, that would be great.

With Vue I see the problem that the community is smaller than with React / Angular, and the development at Vue is no longer really stable (see commits on Github). In my opinion, Angular is far too heavy and too complex for a product / customer solution that can be handled by 1-3 people.

I would be happy about your assessment.

Greetings gunna

@sibertMar 28.2021 — #> @gunnag#1629712 The application should become a product, not just a private game/gimmick.

In my case as well. But you have to start somewhere. I did chose Go to achieve the speed that not other technologies could give.

> Above all, flexibility in the UI would be important...

The UI is controlled by either magic (react, bootstrap etc) or hard work (vanillla)

> The web UI should be able to run on desktop (windows 10, windos server) but also tablets (iOS). So I suspect cross-platform development is necessary

Basically you do not have to worry about this. You upload the content to the server and the browser on each device takes care of the multi platform issue. My example is on a Linux server and you can view if from basically any device that have a browser (Old IE may be not that good)

> It is also important that your own icons / widgets can be "planted" in the UI. The more UI elements are available, the better so that you can make a suitable selection.

All icons in my example is "home made" svg. There is no magic behind this. Treat almost as normal images.

> All in all, it should be a professional web UI for customers, but unfortunately I have little experience with web UI development.

There are many ccs libraries out there ([Bootstrap etc](https://geekflare.com/best-css-frameworks/)) that takes care of the "fancy thing". Pick, blend or do it in pure CSS. Whatever suits you.

> Unfortunately, there are thousands of solutions and I am overwhelmed by the right choice of technology stack. If you could point me in the right direction here, that would be great.

There is no "right" direction. There are common ways and odd ways to solve about the same problem. Normally you work with a combination of many technologies:

1. Most common is PHP, html, CSS and Js

2. Also common is Node/Express plus React components.

3. Rather common is Phyton/Django

4. Very odd and scary is Go (as in my example)

Sometimes you borrow components from an other technology to achieve your goal. One Javascript library to get the charts and a CSS library to get the look and feel.

> With Vue I see the problem that the community is smaller than with React / Angular, and the development at Vue is no longer really stable (see commits on Github). In my opinion, Angular is far too heavy and too complex for a product / customer solution that can be handled by 1-3 people.

The biggest communities are the 1, 2 and 3 listed above.

My advice is to test some technologies and pick one that comes closest to reach your goal in a pleasant way. Basically you make website that interacts with a database. Your journey have just begun...

@carolynperryMar 28.2021 — #this is really good thank you for sharing with us

[url=https://get-vidmateapp.com]get-vidmateapp.com[/url]

[url=https://get-mobdroapk.com]get-mobdroapk.com[/url]

@sumaiyaMar 29.2021 — #Important Information to Include on Bridal Shower Invitations

The bridal shower idea first originated inside the Netherlands, wherein legend has it that a Dutch father refused to pay the dowry on his daughter wedding ceremony, because he didn't approve of the marriage. Today, the bridal bathe is a marriage ritual that's practiced in many western international locations specially within the [url=https://www.latestdatabase.com/netherlands-phone-number-list/]Netherlands Phone Number[/url] List and Canada. The birthday celebration is generally prepared by the bridesmaids and is thrown between three months and two weeks earlier than the real wedding ceremony day. There's an awful lot making plans involved in organizing a bridal shower from deciding on the invitations, to the venue preference and running out guest numbers.

After the vicinity of the bridal shower has been decided and the number of visitors agreed upon, the next assignment is the invitation strategy planning stage. The invitations will list a number of critical information, so it is vital they're effectively constructed. I've put together a list of essential factors that need to be included on any bridal shower invitation.

The hostess's call and get in touch with wide variety must be truly listed on the invitation.

Name of the destiny bride, may additionally sound silly however human beings every now and then have more than one bridal bathe party to go to.

If the bathe is a surprise make sure you formidable the lettering on the invitation. You don't need everybody contacting the bride immediately.

Shower date and address of shower vicinity.

Map of place, in particular beneficial if an outside putting is selected.

RSVP date, call and contact number ought to be indexed on the invitation.

Shower theme data.

Couple's redecorating colours for destiny home, now not constantly viable to get particularly if it is a surprise birthday celebration.

Registry statistics, the bride may additionally have set-up a registry at a neighborhood shop.