Download the PHP package survos/pixie-bundle without Composer

On this page you can find all versions of the php package survos/pixie-bundle. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of survos/pixie-bundle

Informations about the package pixie-bundle

Pixie Bundle

A Symfony bundle that leverages Sqlite to create an indexed structured datastore without an ORM. In particular, it is a solution for analyzing Excel spreadsheets and nest JSON data.

Inspired by https://gist.github.com/sbrl/c3bfbbbb3d1419332e9ece1bac8bb71c and https://dexie.org/ and the Symfony PDO Cache component.

@todo: finish relations using https://github.com/simonw/til/blob/main/sqlite/related-rows-single-query.md

Translations

A parallel file with a -translation suffix stores the source strings and translation strings. The source table is populated during the import process, or with

The --translate dispatches the requests for translations. The --index currently MUST happen in pixie translate (not the normal pixie:index) in order for the translations from the translations table populate the regular pixie file (in the _transations block)

@todo: move the option to populate source pixie to the index command, and/or have an option that the translations are dynamically populated.

Example

bash bin/console bunny:download data/larco/raw.zip --unzip data/larco/raw

unzip larco-raw.zip -d data/larco/raw/

after some processing...

bin/console bunny:upload data/larco/json/ --zip data/larco/json.zip

bin/console bunny:download data/glam.zip

downloads to data/glam.zip

bin/console bunny:download data/glam.zip --unzip

downloads to data/glam.zip unless it exists, unzips files to data/glam

bin/console bunny:download data/glam.zip --unzip --force

downloads to data/glam.zip even if it exists, unzips files to data/glam

bin/console bunny:download data/flickr.pixie.db

downloads to directory data

bin/console bunny:download data/flickr.pixie.db pixie/

downloads to pixie/flickr.pixie.db

bin/console bunny:download data/flickr.pixie.db x.db

downloads to x.db

bin/console bunny:download data/flickr.pixie.db pixie/x.db

downloads to pixie/x.db

bin/console bunny:download data/glam.zip --unzip --force

downloads to data/glam.zip even if it exists, unzips files to data/glam

bin/console bunny:download data/glam.zip zip/my-filename.zip

downloads to zip/my-filename.zip

bin/console bunny:download data/glam.zip --unzip ../translation

downloads to data/glam.zip, unzips files to ../translation (above the project root).

bin/console bunny:download data/adh.zip --unzip data/adh --cleanup

bash bin/console survos:make:workflow MexMus new,enhanced enhance --entity-class=Survos\PixieBundle\Model\Item bash curl bin/console pixie:init movies --dir=./data/imdb

./pixie/movies.yaml created with 4 tables, configure it and run bin/console pixie:import movies --limit 10

cat > pixie.movies << 'END' (full config) END bin/console pixie:import movies --limit 10
symfony open:local --path="/pixie/movies" bash

explicitly

bin/console pixie:import /path/to/csv/directory -c directory.yaml

use source.dir key, absolute, or relative to bundle data_root). If !exists, use the bundle data_root and append 'code'.

bin/console pixie:import -c code.yaml

bash wget https://dummyjson.com/products products.json json { "ConstituentID": 1, "DisplayName": "Robert Arneson", "ArtistBio": "American, 1930–1992", "Nationality": "American", "Gender": "male", "BeginDate": 1930, "EndDate": 1992, "Wiki QID": null } bash composer require survos/pixie-bundle



Initialize StorageBox with the sqlite database name plus any new tables to be created.

Existing tables can be used, but automatic table creation is disabled. 

## Multi-lingual StorageBox

Specifically for kv lookups of text fields that may have translations

## Credits

Debug icon from https://www.svgrepo.com/svg/11690/database

## Backups

For some reason, the .wal file stays open.  We need a utility that does the following

* execute the query "vacuum into 'xx.backup.db'"
* zip the backup
* move the backup to s3 or bunny

To restore, do the opposite

* Fetch the zipped backup
* optionally rename the existing database
* remove .wal, etc.
* unzip 

### S3 example

aws s3 sync . s3://voxitour/data/pixie --acl public-read  --exclude="*" --include="met.zip"
aws s3 sync s3://voxitour/data/pixie . --acl public-read  --exclude="*" --include="met.zip"

aws s3 sync . s3://voxitour/data/pixie --acl public-read  --exclude="*" --include="x.pixie.db"
aws s3 sync s3://voxitour/data/pixie . --acl public-read  --exclude="*" --include="x.pixie.db"

aws s3 sync s3://voxitour/data/pixie . --acl public-read  --exclude="*" --include="*.zip"

### Notes 

This may come in handy someday

* https://packagist.org/packages/tbachert/spi

All versions of pixie-bundle with dependencies

PHP Build Version
Package Version
Requires ext-pdo Version *
php Version ^8.3
symfony/config Version ^6.4 || ^7.1
symfony/dependency-injection Version ^6.4 || ^7.1
symfony/http-kernel Version ^6.4 || ^7.1
twig/twig Version ^3.4
survos/installer Version ^1.5 || ^2.0
symfony/yaml Version ^6.4 || ^7.1
doctrine/dbal Version ^3.0|^4.0
symfony/property-access Version ^6.4 || ^7.1
halaxa/json-machine Version ^1.1
league/csv Version ^9.9
symfony/twig-bundle Version ^6.4 || ^7.1
symfony/routing Version ^6.4 || ^7.1
symfony/serializer Version ^6.4 || ^7.1
symfony/serializer-pack Version ^1.3
zenstruck/console-extra Version ^1.4
symfony/ux-icons Version ^2.21
symfony/http-client-contracts Version ^3.5
symfony/http-client Version ^6.4 || ^7.1
symfony/asset Version ^7.1
illuminate/collections Version ^11.33
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package survos/pixie-bundle contains the following files

Loading the files please wait ....