SQLite和Flex [英] SQLite and Flex

问题描述

我正在开发一个GPS计算器，该计算器使用大量数据来计算不同的值，例如RMSE(均方根误差)和NSSDA(空间数据的国家标准).数据来自变化很大的各种不同型号的GPS单元，即内部/外部天线；自动，WAAS，DGPS，PPS信号；敞开的，轻的，中型的，重的顶篷；基本上，需要存储大量数据才能计算出各种所需的结果.

I am developing a GPS calculator that uses a lot of data to calculate different values, such as RMSE (root mean square error) and NSSDA (national standard for spatial data). The data is from a variety of different models of GPS units with a great degree in variation, i.e. internal/external antennae; auto, WAAS, DGPS, PPS signal; open, light, medium, heavy canopy; etc. Basically a whole lot of data needs to be stored to compute the huge variety of desired outcomes.

将始终读取数据，并且只有在极少数情况下才会添加新数据.如果确实需要添加它，则它很可能是由开发人员之一而不是该程序的用户提供的.因此，我们对使用SQLite非常感兴趣.我们的服务器上安装了Oracle，但是任何表的创建都必须由高层来完成，有时可能需要数周的时间.因此，SQLite似乎可以为我们工作.我从未使用过SQLite，所以我想知道这是否是正确的选择.但是，有关SQLite和Flex的大多数文档似乎都与AIR应用程序和SQLite作为本地数据库有关.在服务器上使用Flex应用程序执行所需计算的SQLite文件是否还能工作?还是我无法使用SQLite文件?

The data will always be read, and only in rare conditions will new data be added. If it does need to be added, it will most likely be by one of the developers, not users of the program. Because of this, we are very interested in using SQLite. We have Oracle on our server, but any creation of tables must be done by higher-ups, which can sometimes take weeks. For this reason SQLite seems like it might work for us. I have never used SQLite, so I am wondering if it is the right choice. However, most documentation about SQLite and Flex seems to be pertaining to AIR applications and SQLite as a local database. Would having an SQLite file on the server with a flex application performing the desired calculations even work? Or am I way off the mark on the use of SQLite files?

推荐答案

我喜欢sqlLITE，但是我只在Perl中使用了它.

I love sqlLITE but I have only used it with Perl.

您可以使用类似于Amazon的SimpleDB之类的东西，该数据库可以作为webService进行访问.如果您的数据量少于1GB，并且每月使用时间少于25小时，则它是免费的.

You could use something like Amazon's SimpleDB which is a database that can be accessed as a webService. It's also free if you have less than 1GB of data and use it less than 25 hours a month.

链接到simpleDB http://aws.amazon.com/simpledb/

Link to simpleDB http://aws.amazon.com/simpledb/

有一个用于simpleDB的AS3库，但是我不以拥有多个链接为名:-( .. google:"Amazon illustrationlife simpleDB"

There is an AS3 library for simpleDB but I don't have the reputation to have more than one link :-(.. So google: "Amazon illustratedlife simpleDB"

祝你好运

这篇关于SQLite和Flex的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！