[sqlite] RSQLite.extfuns.dll -- Looking for Linux binary extension

Does anyone know if a Linux binary extension of this is available (.so)? If you load RSQLite package into R you will get the RSQLite.so file that can be used as an extension in a Linux version of SQLite. It works. http://cran.r-project.org/web/packages/RSQLite/index.html (RSQLite.extfuns.dll) is

[sqlite] Where do we post to share code? CTE: Long to Wide format

I love Common Table Expressions (CTE) in SQLite. Databases are long format data but other programs (e.g., IBM SPSS Statistics) are sometimes wide format. Joe Fisher Oregon State University Here's some useful code: CREATE TABLE [long_to_wide] ( [barcode_id] TEXT(16) NOT NULL, [well_no]

[sqlite] Importing ~1000 CSV files faster

I'm running the following script on more than 1000 2MB CSV files and I'd like to speed it up if possible. I noticed that a 'WAL' is running. Is there something better I can do to improve this process? Perhaps one transaction? Perhaps turn something off? It took about 1.5 hours to run. I use

[sqlite] Direct PostgreSQL to SQLite connection?

Looking for a solution to connect directly from a PostgreSQL database to a SQLite database. We need PostgreSQL for it's Window/Analytic functions and other features that SQLite doesn't have. Yet, SQLite is great for collecting data. Every one of our experiments adds 300MB to the SQLite

Re: [sqlite] GUI for SQLite (nobre)

SQLite Expert (Windows) is good and I've been using it for the last 2 years but unfortunately it only does (Windows). Although, it also runs good in WINE on Linux. I've recently started using Valentina Studio (Linux/Windows/Mac) because I need to also run on native Linux, and if I get rich I'll

[sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

Anyone, Does anyone have good or bad experiences using a SQLite database in a shared folder? The 'Dropbox / Drive / SkyDrive / One' are of course a bit different than a SAMBA share because they are copies that get synced versus SAMBA which is the one and only copy. Normally I would just be

Re: [sqlite] Is it possible to use SQLITE to calculate the, streakedness of numeric data?

Frank, Don't really understand your question. Should be no problem to calculate anything once. Just write your algorithm. The problem comes in when you try to calculate it for a set of data. SQLite like MySQL doesn't have SQL 2003/2008 Window Functions. Oracle recently stated they will not be

[sqlite] 1.1GB database - 7.8 million records

Very impressive. With SQLite 3.7.14.1 Took 4 minutes to load a 1.5GB MySQL dump with 7.8 million records. Count(*) takes 5 seconds. Even runs on a USB key. Wow! Also loaded a smaller one (33MB database [30 tables/dumps] in 10 seconds, largest file had 200,000 records). I wrapped the 7.8

[sqlite] 1.1GB database - 7.8 million records

Very impressive. Took 4 minutes to load a 1.5GB MySQL dump with 7.8 million records. Count(*) takes 5 seconds. Even runs on a USB key. Wow! Also loaded a smaller one (33MB database [30 tables/dumps] in 10 seconds). Joe Fisher Oregon State University

[sqlite] SQL:2003 -- Window Functions

Too bad SQLite doesn't yet support SQL Window Functions. Are there any SQLite Extension Libraries that support "SQL:2003 type Window Functions"? I specifically need LEAD and LAG to calculate an event integer timestamp delta between consecutive rows. I've played with some self-join code but

[sqlite] Fwd: How do you load a ".csv" and skip the first line?

om: joe.fis...@tanguaylab.com <joe.fis...@tanguaylab.com> To: sqlite-users@sqlite.org Is there some way to load a ".csv" file into a SQLite database table when the first row (record) of the file contains headers? This does not work? --

[sqlite] How do you load a ".csv" and skip the first line?

Is there some way to load a ".csv" file into a SQLite database table when the first row (record) of the file contains headers? This does not work? -- .separator , .import test.csv ld_assay Here's my database / table: CREATE TABLE [ld_assay] ( [id]

[sqlite] Native API for C# (C sharp) and Visual Studio

We need to move a MS Access database to something more portable. Is the “http://system.data.sqlite.org” the way to go for getting SQLite API access from the Microsoft stuff (Visual Studio, other)? The programmer needs to use C# (c sharpe) for his coding that interacts with the database. Is it a

[sqlite] is SQLite the right tool to analyze a 44GB file

I'm using R (R Studio) with large SQLite databases and it's a dream come true. Here's a simple example of a ToxCast chemical table inside a Substance database. # Load the following libraries into R # DBIR Database Interface # RSQLiteSQLite