Re: [sqlite] Using SQLite in embedded environment
On Sat, Jun 28, 2008 at 8:37 PM, dcharno <[EMAIL PROTECTED]> wrote: > Steven Woody wrote: >> On Sat, Jun 28, 2008 at 11:30 AM, dcharno <[EMAIL PROTECTED]> wrote: As an option, we also think about Berkeley DB, do you experts has experience using Berkeley DB on ARM/Linux with ulibc or glibc? >>> Berkeley DB may also be an option. It really depends upon what you are >>> trying to accomplish, what your data set looks like, etc. >>> >>> Ironically yes; I am translating Berkeley DB databases into SQLite for >>> analysis. >> >> :-) sounds like a good method > > Except for legacy issues, I can't think of any reason you'd ever need both. > > If your options are SQLite and Berkeley DB then a couple of points to > consider: > > With SQLite, you obviously have the full power of SQL to model your > system's data and write arbitrarily complex queries to filter and > analyze your data. And SQL is standard so it is well documented and > easy for other team members to access. > > Berkeley DB is a persistent hash table. Its good if your data is > primarily key/value based and you only need to do key lookup. But, its > really just a storage layer. It doesn't provide any type of query > capability for filtering or searching through your data -- all of that > has to be written as a layer above Berkeley DB by you. > > Berkeley DB is a bit bigger than SQL Berkeley DB bigger? Why? To my understand, Bkerkeley DB is database core and and many SQL are based on it. > > Compare the licenses. Be sure to read the license of Berkeley DB to > make sure it is compatible with your application. > >http://en.wikipedia.org/wiki/Berkeley_DB#Licensing > > SQLite is in the public domain, so you are free to do with it what you > please. > >http://www.sqlite.org/copyright.html > > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite in embedded environment
Steven Woody wrote: > On Sat, Jun 28, 2008 at 11:30 AM, dcharno <[EMAIL PROTECTED]> wrote: >>> As an option, we also think about Berkeley DB, do you experts has >>> experience using Berkeley DB on ARM/Linux with ulibc or glibc? >> Berkeley DB may also be an option. It really depends upon what you are >> trying to accomplish, what your data set looks like, etc. >> >> Ironically yes; I am translating Berkeley DB databases into SQLite for >> analysis. > > :-) sounds like a good method Except for legacy issues, I can't think of any reason you'd ever need both. If your options are SQLite and Berkeley DB then a couple of points to consider: With SQLite, you obviously have the full power of SQL to model your system's data and write arbitrarily complex queries to filter and analyze your data. And SQL is standard so it is well documented and easy for other team members to access. Berkeley DB is a persistent hash table. Its good if your data is primarily key/value based and you only need to do key lookup. But, its really just a storage layer. It doesn't provide any type of query capability for filtering or searching through your data -- all of that has to be written as a layer above Berkeley DB by you. Berkeley DB is a bit bigger than SQL Compare the licenses. Be sure to read the license of Berkeley DB to make sure it is compatible with your application. http://en.wikipedia.org/wiki/Berkeley_DB#Licensing SQLite is in the public domain, so you are free to do with it what you please. http://www.sqlite.org/copyright.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite in embedded environment
On Sat, Jun 28, 2008 at 11:30 AM, dcharno <[EMAIL PROTECTED]> wrote: >> As an option, we also think about Berkeley DB, do you experts has >> experience using Berkeley DB on ARM/Linux with ulibc or glibc? > > Berkeley DB may also be an option. It really depends upon what you are > trying to accomplish, what your data set looks like, etc. > > Ironically yes; I am translating Berkeley DB databases into SQLite for > analysis. :-) sounds like a good method ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite in embedded environment
> As an option, we also think about Berkeley DB, do you experts has > experience using Berkeley DB on ARM/Linux with ulibc or glibc? Berkeley DB may also be an option. It really depends upon what you are trying to accomplish, what your data set looks like, etc. Ironically yes; I am translating Berkeley DB databases into SQLite for analysis. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite in embedded environment
2008/6/28 dcharno <[EMAIL PROTECTED]>: >> I am considering to use SQLite in my current embedded application >> project. It's a ARM9/Linux. Do you experts think it is a good idea? >> And, is there any tips or considerations in this combination? > > Currently using SQLite on an ARM7 running ucLinux. > > SQLite is an excellent choice for many embedded applications, but you > need to read up to make sure it is an appropriate match for your > problem. A good starting point is: > > http://www.sqlite.org/whentouse.html > > The things I really like: > > - the library is very small, but you get an awful lot of functionality. > > - SQLite uses a single database file and its cross platform. So, > you can pull the database over to a PC and easily do analysis > of your data using a variety of languages like python or tcl. > > - the mailing list has lots of very smart and helpful people. > > HTH > As an option, we also think about Berkeley DB, do you experts has experience using Berkeley DB on ARM/Linux with ulibc or glibc? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite in embedded environment
> I am considering to use SQLite in my current embedded application > project. It's a ARM9/Linux. Do you experts think it is a good idea? > And, is there any tips or considerations in this combination? Currently using SQLite on an ARM7 running ucLinux. SQLite is an excellent choice for many embedded applications, but you need to read up to make sure it is an appropriate match for your problem. A good starting point is: http://www.sqlite.org/whentouse.html The things I really like: - the library is very small, but you get an awful lot of functionality. - SQLite uses a single database file and its cross platform. So, you can pull the database over to a PC and easily do analysis of your data using a variety of languages like python or tcl. - the mailing list has lots of very smart and helpful people. HTH ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite in embedded environment
2008/6/26 Alex Katebi <[EMAIL PROTECTED]>: > Steven, > > If SQLite runs on ARM9/Linux, then I don't see any problems. I think you > should watch the SQLite video on youtube. > http://www.youtube.com/watch?v=giAMt8Tj-84 Thank you. I will go youtube > > Enjoy! > -Alex > > 2008/6/24 Steven Woody <[EMAIL PROTECTED]>: > >> Hi, >> >> I am considering to use SQLite in my current embedded application >> project. It's a ARM9/Linux. Do you experts think it is a good idea? >> And, is there any tips or considerations in this combination? >> >> Thank you. >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite in embedded environment
Steven, If SQLite runs on ARM9/Linux, then I don't see any problems. I think you should watch the SQLite video on youtube. http://www.youtube.com/watch?v=giAMt8Tj-84 Enjoy! -Alex 2008/6/24 Steven Woody <[EMAIL PROTECTED]>: > Hi, > > I am considering to use SQLite in my current embedded application > project. It's a ARM9/Linux. Do you experts think it is a good idea? > And, is there any tips or considerations in this combination? > > Thank you. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Using SQLite in embedded environment
Hi, I am considering to use SQLite in my current embedded application project. It's a ARM9/Linux. Do you experts think it is a good idea? And, is there any tips or considerations in this combination? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users