Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/erezsh/Preql

An interpreted relational query language that compiles to SQL.
https://github.com/erezsh/Preql

Aggregation funcs now work on single-column tables. Better casts

2e49ec7d6ed21d0673906af56e54f372fe86d3d9 authored over 4 years ago by Erez Sh <[email protected]>
Add string slice operator

5534d4576139254a8a41a1ec844c241021da5e89 authored over 4 years ago by Erez Sh <[email protected]>
Small refactor

0c171bd6d81e8d53d7b893783110a0b8a656248a authored over 4 years ago by Erez Sh <[email protected]>
Refactored arithmetic (finally)

03e9f0c5b6efe10093e4f1e4c7f09a331ef17bf7 authored over 4 years ago by Erez Sh <[email protected]>
Refactored compare (finally)

a4ffe20558d9ad19ed30b19d8c45a2be4e24e73f authored over 4 years ago by Erez Sh <[email protected]>
Better type handling (initial). All tests passing

0d8f30d9509d23f5aaa0401797f5ee769c903d40 authored over 4 years ago by Erez Sh <[email protected]>
Updated runtype to 0.1.4

a50c09e8ce6207c8bd79b819e9cf8c3a220370e9 authored over 4 years ago by Erez Sh <[email protected]>
Fixed setup

745560a2ca8c029ce4fca38773343c1c14a7fffa authored over 4 years ago by Erez Sh <[email protected]>
Merge pull request #1 from erezsh/tals/script

8a4722f3380c8c601a5fca57a0fe6ef56dab7c93 authored over 4 years ago by Erez Shinan <[email protected]>
cli script for preql

b7092cf37d8c6bb16dd19ce19e1779676cf4dc0a authored over 4 years ago by Tal Shiri <[email protected]>
All tests passing

b68b95bc35202f45b660436d7cc560de5f9d7bbf authored over 4 years ago by Erez Sh <[email protected]>
Filenames in errors and small fixes

e8416d4558c7637a0d2bad28bd0eb7a5c50a0123 authored over 4 years ago by Erez Sh <[email protected]>
Happy cleanup

92156d300652a359ec2c30d6072d583be4443a56 authored over 4 years ago by Erez Sh <[email protected]>
New type system! Most tests passing. Mid-work. Cleanup imminent

799bf377edd665db3a6fe6c29a3bf1355b09f806 authored over 4 years ago by Erez Sh <[email protected]>
Small fix

e4398851477c9f11790263022d7ccc5b12854aaa authored over 4 years ago by Erez Sh <[email protected]>
Fixed requirements

1d648fdcd6c33e3774565bfe3e3cf31182bb720c authored over 4 years ago by Erez Sh <[email protected]>
Fixed setup.py

a56dc2b3599d55c94d9761e6727ea3988b92ac4d authored over 4 years ago by Erez Sh <[email protected]>
Added setup.py

c0d7c24b6afb55a735426063e1754ded685ed2f9 authored over 4 years ago by Erez Sh <[email protected]>
Added LICENSE

62cbeee6d6ef2b884c893476b2e8332d191ad304 authored over 4 years ago by Erez Sh <[email protected]>
Faster import_csv (but structs don't work now). Minor fixes

118b59db510f47cc53a817ac9388afe64f3b800a authored over 4 years ago by Erez Sh <[email protected]>
Added reference to docs (initial)

51d850b26d5bda8af0bdfd5c187ac9c85f5cfcd4 authored over 4 years ago by Erez Sh <[email protected]>
Added dict syntax in projection; import_csv; more tutorial

2c26a39be60228852be8a75af49165856314634c authored over 4 years ago by Erez Sh <[email protected]>
Small fixes

f30b077d475f6342779edfe6599890f5bbf3d344 authored over 4 years ago by Erez Sh <[email protected]>
Better table{1} repr, fixed /, added dict syntax, other bugfixes

7a12f13d79f252810b8da9c11321e35ed5b7c79f authored over 4 years ago by Erez Sh <[email protected]>
Tutorial draft making progress + tiny fixes

c253bdd625796088fd8fec7492a6bbb4442ca7c6 authored over 4 years ago by Erez Sh <[email protected]>
Added issubclass to pql. Fixes

38f2082043c7a7aae295889e7c4f9d8b673f7c63 authored over 4 years ago by Erez Sh <[email protected]>
Better errors. Added Not, And

15d3d4e9fe5d6017567a2014c06462789a0c0dda authored over 4 years ago by Erez Sh <[email protected]>
Bugfixes

88695ca2614729916722a1ddcc708175d4bf714c authored over 4 years ago by Erez Sh <[email protected]>
Better errors: Rewrote meta into text_ref, added stacktrace.

90c1361a352e83dc5834cb3bc6f60d6e9bbd2983 authored over 4 years ago by Erez Sh <[email protected]>
Added casting

ebb59d78818c955c0119a2eb86e137b304af7cab authored over 4 years ago by Erez Sh <[email protected]>
Added support for multiline in repl

8b38a0e2bedebb991ece570f9490da1c2f095f58 authored over 4 years ago by Erez Sh <[email protected]>
Added pandas support

fb39a5f9b9b6f478fb7fb8e66cdf689061bf8ff7 authored over 4 years ago by Erez Sh <[email protected]>
Added preql/__main__.py

ac495d5df47c7e3ed027669e1051595cdcbc620b authored over 4 years ago by Erez Sh <[email protected]>
Small refactor, more needed

63b512217128c9564c09340c7a96fe5e7df96476 authored over 4 years ago by Erez Sh <[email protected]>
Added docstrings

0d664ab83cb71d5823b853f83e8998dafbd6ae66 authored over 4 years ago by Erez Sh <[email protected]>
Added variadic params and dict inlining

ae4cc1dac7a8334e44e19c420ac111a63f056546 authored over 4 years ago by Erez Sh <[email protected]>
Added RowInstance tests

7b9e0343e07a871971b3f78bb44d9c96789e611d authored over 4 years ago by Erez Sh <[email protected]>
Bugfixes. Slightly cleaner preql code

7027bf1e58172abeb227f92142f97cdb3734a630 authored over 4 years ago by Erez Sh <[email protected]>
Improvements to REPL

a7fab4ccf32bb448b70982e8aceee9cb37ff71af authored over 4 years ago by Erez Sh <[email protected]>
Some improvements

541113b7b11e31e666818a2bf243dc34ab70caa8 authored over 4 years ago by Erez Sh <[email protected]>
// into /~ and added // as comment

0d5ac60f05672078fece6a85d8531104ccc10c59 authored over 4 years ago by Erez Sh <[email protected]>
Added RowInstance, new and one now behave better

08223d552834dcc90557639cc5b00275b37ec282 authored over 4 years ago by Erez Sh <[email protected]>
Added debug(), added docstrings to most pql functions

ccf14d83f7bb6dc8614137c0ab62333490c7ed7b authored over 4 years ago by Erez Sh <[email protected]>
fixed autocount, temptable & id. all tests passing

8c1e451cfb0b8afd2cb5c98fdb972933554bd443 authored over 4 years ago by Erez Sh <[email protected]>
Refactor. Improving types, Caching works again

e7fd91b8c6ef9d6b7d9870d8c39624399e48881d authored over 4 years ago by Erez Sh <[email protected]>
Simpler sql for projections when values haven't changed

bb44f4f319e060ac8a13286c334921b1b3c829a1 authored over 4 years ago by Erez Sh <[email protected]>
Methods initial + other improvements

b4c389200788bb4a1f1e6850a072178620bca4ee authored over 4 years ago by Erez Sh <[email protected]>
Refactored the grammar to use templates. A little cleaner now

3aac524c2ae358eb983cc0ed6e6624a4147671b7 authored almost 5 years ago by Erez Sh <[email protected]>
Slightly better typing. Preparing for methods

571bfed2b7c91bca0bf0a4acf027d9495b6e4285 authored almost 5 years ago by Erez Sh <[email protected]>
Added some string functions

dd36abc2357b3ac397412ef3126b34af2a887bb4 authored almost 5 years ago by Erez Sh <[email protected]>
Cleanup, more tests working

350dd3c3a97413ffbcda8b0a8189871aa79d84e0 authored almost 5 years ago by Erez Sh <[email protected]>
Reintroduced StructInstance for nested projections. But much cleaner than before.

d38e9f7fa7f2293039f923b60c28da07f7503af6 authored almost 5 years ago by Erez Sh <[email protected]>
Better nested projections. Much more work to do

a30ee48cc089c6db77104964950944097b5008c4 authored almost 5 years ago by Erez Sh <[email protected]>
Some fixes

c56aec4094ebdc14f38bb923f61b0a0962716d6e authored almost 5 years ago by Erez Sh <[email protected]>
Column codenames. Still better than ColumnInstance. More tests. All passing

c5a3263c75c22b901149166fbd351963989311a1 authored almost 5 years ago by Erez Sh <[email protected]>
Small improvement for types

096ddf7927011073edc1fa7e6648bd87674fd21e authored almost 5 years ago by Erez Sh <[email protected]>
Removed column instances. Major cleanup, all tests passing!

No column instances mean:
- Column names are always determined by the type. To change a column n...

266cb419244ce8eb0a96cf6855134c2f9086c4e5 authored almost 5 years ago by Erez Sh <[email protected]>
Refactor and cleanup. Now using sql.ResolveParameters, which is faster

616912ca0f79be9228e4d7dc0986fc54aedc52fc authored almost 5 years ago by Erez Sh <[email protected]>
All tests passing. Benchmark faster. Fixes for caching

cbcc7bdf47b46dbc86dcef238716952884b7f2fb authored almost 5 years ago by Erez Sh <[email protected]>
tmp

9e7600ca1cba824886ae3facca0a55c979a09a71 authored almost 5 years ago by Erez Sh <[email protected]>
Small step towards caching compiled

1e09a3ec91e6c7e074b8b3a8cee3626571efcf4f authored almost 5 years ago by Erez Sh <[email protected]>
Big refactor. All recursion goes through evaluate with access_levels. All tests working.

Refactored simplify into resolve_effects and simplify_ast.

bfe0d5db290f3715ef8d2ce6520adb1988194c10 authored almost 5 years ago by Erez Sh <[email protected]>
Nicer syntax for properties

fbc341a69aa67fc600fe27a02d04a9157fd505d1 authored almost 5 years ago by Erez Sh <[email protected]>
Refactored type initialization of Sql objects (now required only when necessary)

abfb63c02cba535d42314fb50df5ce02e3ce5acb authored almost 5 years ago by Erez Sh <[email protected]>
Some comments and ideas, nothing actually done

b8b72db034987111bf8247805429467d2ab6d72f authored almost 5 years ago by Erez Sh <[email protected]>
Initial casting and generics

79e92b033fc1b856b2ad96f54068ad044d732318 authored almost 5 years ago by Erez Sh <[email protected]>
Introduced the EmptyList, + refactor

9c5d23ca3054fa085c2fbe2e80313a5ddcb191e2 authored almost 5 years ago by Erez Sh <[email protected]>
Saner primary-keys

fd719bc2019f877b26b8a5a42afcef98887de1df authored almost 5 years ago by Erez Sh <[email protected]>
Insert rows working

a2b20477114ed350897fbe7e6ff841b6de983f80 authored almost 5 years ago by Erez Sh <[email protected]>
Added 'for', dict->row

8fa954632d1aedd7380d39d25362918a042fef67 authored almost 5 years ago by Erez Sh <[email protected]>
Added ellipsis exclude

fa21894c2d044822ac532ff405fa038f3ce2e701 authored almost 5 years ago by Erez Sh <[email protected]>
Refactor

a1fa252cccd40388af84a579a3860373ae2afff5 authored almost 5 years ago by Erez Sh <[email protected]>
Small stuff

0859b2ef1399351595a1578cc2b3eba6fabc6803 authored almost 5 years ago by Erez Sh <[email protected]>
Changed ^in -> !in, + Small refactor

ae7946fb4341f72770e31b95bda80ebb19725ba3 authored almost 5 years ago by Erez Sh <[email protected]>
Refactored types. Lots of happy cleanup

7d79ca9e21e2c9096f678aef30cc31a0cfa7cb62 authored almost 5 years ago by Erez Sh <[email protected]>
Small refactoring and cleanup

831cd6ddc176cb46acf88177fbae26cdac0eb1b4 authored almost 5 years ago by Erez Sh <[email protected]>
Slight refactoring. Gearing towards a bigger correction.

9c0084993eb1e00248bb8420b659ebec211952d1 authored almost 5 years ago by Erez Sh <[email protected]>
Towards smarter table interaction. Still need to work out type system and table 'params'

3002de79657a564d744d0e6b02e4ed54260e0259 authored almost 5 years ago by Erez Sh <[email protected]>
Many improvements (Bugfixes, Better API, more features)

5e261a77508fa95775c11a58b635685233aeb796 authored almost 5 years ago by Erez Sh <[email protected]>
Settled on curly braces + new syntax

aa274fb874a3931eaf822efa607506d1363a16b1 authored almost 5 years ago by Erez Sh <[email protected]>
Small stuff

343de665345d6ade6fc8d67d4c74b9fa131431d0 authored almost 5 years ago by Erez Sh <[email protected]>
Now using runtype for dataclasses and multiple dispatch

97cd59b1f7b7e721a947ed6ee5cac677a34e5eb3 authored almost 5 years ago by Erez Sh <[email protected]>
Tiny fix for SQL escaping

d5a4a00b720c40697e847276b44a8644d45aef2e authored almost 5 years ago by Erez Sh <[email protected]>
More little fixes

62d10d75902bae2c80aa2a7669074666c560ac51 authored almost 5 years ago by Erez Sh <[email protected]>
Little fixes

15ccaa47625cc919c3fb5f15246e2d681f998863 authored almost 5 years ago by Erez Sh <[email protected]>
Added delete (very inefficient)

a0f5f5a653ca758068ae5665e1864e5226919e9a authored almost 5 years ago by Erez Sh <[email protected]>
Added the 'one' and 'one?' operators

7813e56f860e259b2689843fc95803bf583da418 authored almost 5 years ago by Erez Sh <[email protected]>
Added default values

88d7746432d3a5e24e8890e0ed511b9a81099442 authored almost 5 years ago by Erez Sh <[email protected]>
List now uses WITH instead of UNION. + refactoring

5a5995746dd39c3604c236dc69161e5b8f2f9ea2 authored about 5 years ago by Erez Sh <[email protected]>
Fix for naming in projection; better types in comparison (still needs work)

fce6151756c7d95a4a3d07d592f3fd875a4ce115 authored about 5 years ago by Erez Sh <[email protected]>
Added support for '_' in repl (but not necessarily in the best way)

40be6b84e1a8915a3cf735ae0c9f55d1a08d1e58 authored about 5 years ago by Erez Sh <[email protected]>
Cleanup

3c8c2af8e6852f9cfebdcdc42184a743fd6005db authored about 5 years ago by Erez Sh <[email protected]>
Re-implemented enum() in core.pql, sql names no longer clash with keywords

ce788373f1760b6ad96772fa74e2952aa8a43ba8 authored about 5 years ago by Erez Sh <[email protected]>
Added random() to core.pql, better error handling (but not great)

39c91c2716288cf8ceba9453ff94aa2c6d7e38ad authored about 5 years ago by Erez Sh <[email protected]>
Added ~ operator (like)

8788e607d9b29b30b28b3b18620fe549637f7e4c authored about 5 years ago by Erez Sh <[email protected]>
Added table slicing syntax

8103708e4ba7068b32188ea5b43e6345da697afe authored about 5 years ago by Erez Sh <[email protected]>
Improved support for lists (still partial)

1b16964cbc33f5ba2bfad72d1ca3ba82d7e17e44 authored about 5 years ago by Erez Sh <[email protected]>
Tiny fixup

396e7acc17211d214712faf3374c503a25dc7ad5 authored about 5 years ago by Erez Sh <[email protected]>
Added core.pql

f6a0b52ce203184d4ff97da87b34e6acd19d7b07 authored about 5 years ago by Erez Sh <[email protected]>
Nicer SQL output. Still needs more work

d87425265322a28cfa2860761636890f2bf18429 authored about 5 years ago by Erez Sh <[email protected]>