我的应用程序，SQL或NOSQL的最佳方法？ [英] Best Approach to my Application, SQL or NOSQL?

问题描述

大家好我需要你提出关于创建我的应用程序的最佳方法的建议。



我正在使用VB.net并且它将在线。



主要特点：



在运行时，创建多个具有多个功能的面板...在每个创建的内部面板..有一个添加按钮，每次单击添加按钮时，它都会创建并嵌入一个像拖放一样的功能。顺便说一句..我在Runtime上创建的Panel是一个UserControl嵌入了一个面板用于自定义设计和功能。



所以在运行时我正在创建UserControls功能。



对于每个添加的面板和按钮等..我总是使用Addhandler，Addressof



我将使用像Phpmyadmin这样的数据库。



使用其功能保存创建的面板的最佳方法是什么。



SQL还是NOSQL？或者关于哪些更好的想法？



我对SQL的意思是 - 就像我将数据保存到我创建的按钮和面板中，保存它们.text，location和其他属性，就像在我的数据库中一样，它们是一个文本列，Location，Panel_ID，Button_ID，ParentContainerID等。



我对NOSQL的意义是 - 就像将序列放入结构的序列化方法。然后将结构保存为二进制对象，这样我就不必解析各个属性了。将结构转换为字节数组。然后将字节数组保存到数据库中。

Hello Everyone I need your suggestions on what would be the best approach in creating my App.

I am using VB.net and its going to be online.

Main Features:

On Runtime, Creating multiple Panels with multiple Functions... Within every created Panel.. There is an Add Button where Every time I click Add Button, It is created and embed with a Function like drag and drop. And by the way.. the Panel I created on Runtime is a UserControl embed with a panel For a Customize design and Function.

So on at Runtime I am Creating UserControls with Functions.

For every Added Panels and buttons etc.. I always use Addhandler, Addressof

And I will be using a database like Phpmyadmin.

What would be the best way in Saving the Created Panels with its Functions.

SQL or NOSQL? or any ideas on what would be much better?

What I meant for SQL is - Is like I would save into the database the buttons and panels I created, save their .text, location, and other properties, Like in my database their is an Column for text, Location, Panel_ID, Button_ID, ParentContainerID etc.

What I meant for NOSQL is - Is like a serialization method to put the settings into a structure. Then save the structure as a binary object so I don't have to parse the individual properties. converts a structure to a byte array. Then save the byte array into the database.

推荐答案

这取决于一般的答案。



那里影响你决定的因素有很多，例如：

1）你的编程能力以及你擅长的东西。

2）你的使用模式用户。

3）数据量。

4）你需要的性能水平。

5）你如何部署你的应用程序。

6）您需要如何支持您的申请。

7）您需要多长时间准备申请。



一般情况下，我建议您坚持自己所知并尽快创建应用程序。序列化数据结构可以与您正在使用的存储引擎无关，因此您可以将它们存储在任何RDBM中的blob中，例如，这是一种很好的方式。



如果你有时间并可以获得津贴，那么看看 Key / Value 商店哪些可能适用于任何要求的70％ ，文件商店也可能涵盖99％的大部分要求。

It depends is the general answer.

There are a number of different factors which will effect your decisions such as :
1) your abilities in programming and what you are good at.
2) the usage pattern for your users.
3) the volume of data.
4) the performance levels you need.
5) how you are deploying your application.
6) how you need to support your application.
7) how much time you have to get the application ready.

Generally I would recommend you stick to what you know and create your application as fast as possible. Serializing data structures can be done irrelevant to the storage engine you are using so you can store them in blobs in any RDBMs for example which is a good way to go in any case.

IF you have time and can make allowances then take a look at Key/Value stores which will probably work for 70% of any requirements, Document stores will probably cover 99% of most requirements also.

这篇关于我的应用程序，SQL或NOSQL的最佳方法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！