Hi Jacob
Thank you.
On my machine (Win7) SQLite is not working though. Either Julia crashes
after "using SQLite" or I get the error below:
Executing .juliarc.jl... done
_
_ _ _(_)_ | A fresh approach to technical computing
(_) | (_) (_) | Documentation: http://docs.julialang.org
_ _ _| |_ __ _ | Type "?help" for help.
| | | | | | |/ _` | |
| | |_| | | | (_| | | Version 0.4.0 (2015-10-08 06:20 UTC)
_/ |\__'_|_|_|\__'_| | Official http://julialang.org/ release
|__/ | x86_64-w64-mingw32
julia> versioninfo()
Julia Version 0.4.0
Commit 0ff703b* (2015-10-08 06:20 UTC)
Platform Info:
System: Windows (x86_64-w64-mingw32)
CPU: Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz
WORD_SIZE: 64
BLAS: libopenblas (USE64BITINT DYNAMIC_ARCH NO_AFFINITY Sandybridge)
LAPACK: libopenblas64_
LIBM: libopenlibm
LLVM: libLLVM-3.3
julia> using SQLite
INFO: Recompiling stale cache file
C:\Users\workstation\.julia\lib\v0.4\SQLite.j
i for module SQLite.
Please submit a bug report with steps to reproduce this fault, and any
error mes
sages that follow (in their entirety). Thanks.
Exception: EXCEPTION_ACCESS_VIOLATION at 0x64f749d2 --
jl_deserialize_lambdas_fr
om_mod at C:\Program Files\Juno\resources\app\julia\bin\libjulia.dll
(unknown li
ne)
jl_deserialize_lambdas_from_mod at C:\Program
Files\Juno\resources\app\julia\bin
\libjulia.dll (unknown line)
jl_deserialize_lambdas_from_mod at C:\Program
Files\Juno\resources\app\julia\bin
\libjulia.dll (unknown line)
jl_restore_incremental at C:\Program
Files\Juno\resources\app\julia\bin\libjulia
.dll (unknown line)
_require_from_serialized at loading.jl:84
jlcall__require_from_serialized_3803 at (unknown line)
jl_apply_generic at C:\Program
Files\Juno\resources\app\julia\bin\libjulia.dll (
unknown line)
require at loading.jl:225
jlcall_require_3246 at (unknown line)
jl_apply_generic at C:\Program
Files\Juno\resources\app\julia\bin\libjulia.dll (
unknown line)
jl_init_serializer at C:\Program
Files\Juno\resources\app\julia\bin\libjulia.dll
(unknown line)
jl_eval_with_compiler_p at C:\Program
Files\Juno\resources\app\julia\bin\libjuli
a.dll (unknown line)
jl_eval_module_expr at C:\Program
Files\Juno\resources\app\julia\bin\libjulia.dl
l (unknown line)
jl_eval_with_compiler_p at C:\Program
Files\Juno\resources\app\julia\bin\libjuli
a.dll (unknown line)
jl_eval_module_expr at C:\Program
Files\Juno\resources\app\julia\bin\libjulia.dl
l (unknown line)
jl_eval_with_compiler_p at C:\Program
Files\Juno\resources\app\julia\bin\libjuli
a.dll (unknown line)
jl_eval_with_compiler_p at C:\Program
Files\Juno\resources\app\julia\bin\libjuli
a.dll (unknown line)
jl_parse_eval_all at C:\Program
Files\Juno\resources\app\julia\bin\libjulia.dll
(unknown line)
jl_load_ at C:\Program Files\Juno\resources\app\julia\bin\libjulia.dll
(unknown
line)
include at boot.jl:261
jl_apply_generic at C:\Program
Files\Juno\resources\app\julia\bin\libjulia.dll (
unknown line)
include_from_node1 at loading.jl:304
jl_apply_generic at C:\Program
Files\Juno\resources\app\julia\bin\libjulia.dll (
unknown line)
jl_interpret_toplevel_expr at C:\Program
Files\Juno\resources\app\julia\bin\libj
ulia.dll (unknown line)
jl_interpret_toplevel_thunk_with at C:\Program
Files\Juno\resources\app\julia\bi
n\libjulia.dll (unknown line)
jl_eval_with_compiler_p at C:\Program
Files\Juno\resources\app\julia\bin\libjuli
a.dll (unknown line)
jl_f_tuple at C:\Program Files\Juno\resources\app\julia\bin\libjulia.dll
(unknow
n line)
anonymous at none:2
jl_eval_with_compiler_p at C:\Program
Files\Juno\resources\app\julia\bin\libjuli
a.dll (unknown line)
jl_f_tuple at C:\Program Files\Juno\resources\app\julia\bin\libjulia.dll
(unknow
n line)
process_options at client.jl:284
_start at client.jl:411
jlcall__start_1845 at (unknown line)
jl_apply_generic at C:\Program
Files\Juno\resources\app\julia\bin\libjulia.dll (
unknown line)
unknown function (ip: 00000000004018D0)
unknown function (ip: 000000000040282B)
unknown function (ip: 000000000040140C)
unknown function (ip: 000000000040153B)
BaseThreadInitThunk at C:\Windows\system32\kernel32.dll (unknown line)
RtlUserThreadStart at C:\Windows\SYSTEM32\ntdll.dll (unknown line)
ERROR: LoadError: Failed to precompile DataStreams to
C:\Users\workstation\.juli
a\lib\v0.4\DataStreams.ji
in error at error.jl:21
while loading C:\Users\workstation\.julia\SQLite\src\SQLite.jl, in
expression st
arting on line 1
ERROR: Failed to precompile SQLite to
C:\Users\workstation\.julia\lib\v0.4\SQLit
e.ji
in error at error.jl:21
julia>
Am Dienstag, 27. Oktober 2015 06:25:50 UTC+1 schrieb Jacob Quinn:
>
> Hey everyone,
>
> I know it's been mentioned here and there, but now it's official: two new
> packages have been officially released for 0.4, DataStreams.jl and CSV.jl.
> SQLite.jl has also gone through a big overhaul to modernize the code and
> rework the data processing interface.
>
> DataStreams.jl is a new package with a lofty goal and not a lot of code.
> It aims to put forth a data ingestion/processing framework that can be used
> by all types of data-reader/ingestion/source/sink/writer type packages. The
> basic idea is that for a type of data source, defining a `Source` and
> `Sink` types, and then implementing the various combinations of
> `Data.stream!(::Source, ::Sink)` methods that make sense. For example,
> CSV.jl and SQLite.jl now both have `Source` and `Sink` types, and I've
> simply defined the following methods between the two packages:
>
> Data.stream!(source::CSV.Source, sink::SQLite.Sink) => parse a CSV file
> represented by `source` directly into the SQLite table represented by `sink`
> Data.stream!(source::SQLite.Source, sink::CSV.Sink) => fetch the SQLite
> table represented by `source` directly out to a CSV file represented by
> `sink`
>
> The DataStreams.jl package also defines a `Data.Table` type which is
> simply:
>
> type Table{T}
> schema::Data.Schema
> data::T
> end
>
> this is meant as a "backend-agnostic" kind of type that represents an
> in-memory Julia structure. Currently the default constructors put a
> `Vector{NullableVector}` as the `.data` field, but it could really be
> anything you wanted (e.g. DataFrame, Matrix, etc.). The aim of `Data.Table`
> certainly isn't to replace something like DataFrames, but rather to act as
> a default "pure julia type" with the DataStreams.jl framework. Indeed, to
> do a non-copying convert of a `Data.Table` to a `DataFrame` is just:
> `DataFrame(dt::Data.Table)`.
>
> You can see more details in the blog post I wrote up here:
> http://julialang.org/blog/2015/10/datastreams/
>
> A big thanks to a number of people as well who have helped encourage and
> develop these packages with me. I truly love the community and caliber of
> people around here and just want to say thanks.
>
> DataStreams.jl: https://github.com/JuliaDB/DataStreams.jl
> CSV.jl: https://github.com/JuliaDB/CSV.jl
> SQLite.jl: https://github.com/JuliaDB/SQLite.jl
>
> -Jacob
>
