Comments (5)
@cco3 PR at #57
Let me know it that approach works for you.
from scancode.io.
No particular reasons, SQLite should work mostly fine for a single user usage, although it hasn't been extensively tested.
See https://docs.djangoproject.com/en/3.1/ref/databases/#sqlite-notes for the SQLite limitations.
I will provide a simple way to setup SQLite over PostgreSQL with documentation.
In the mean time you can already try a SQLite setup it with the following steps:
- After the
make envfile
do not run themake cleandb
, instead: - Edit the
scancodeio/settings/base.py
and locate theDATABASES
setting - Replace
"ENGINE": "django.db.backends.postgresql"
with"ENGINE": "django.db.backends.sqlite3"
- Replace
"NAME": os.getenv("SCANCODEIO_DB_NAME", "scancodeio")
with"NAME": "sqlite3.db"
- Run
make migrate
In summary:
git clone [email protected]:nexB/scancode.io.git && cd scancode.io
make dev
make envfile
[Edit the settings]
make migrate
We'll add a new make sqlite
command that will take care of the settings and the migration.
from scancode.io.
@tdruez excellent!
@cco3 there is no specific dependency on PostgreSQL at this stage since the latest versions of Django to support JSON fields on all supported DB backends including SQLlite.
Things are not tested yet on SQLlite but are likely to work OK
But you need to be aware that there may be issues with access contention whenever you run more than one pipeline at a time or have more than one project and also when we will start to parallelize specific pipeline steps for performance (soon enough). This will likely break SQLite because of locking so you need to keep this in mind.
from scancode.io.
@tdruez re: #56 (comment)
Edit the scancodeio/settings/base.py and locate the DATABASES setting
Would it be possible to have a local setting file that's not the main version-controlled one?
I created #58
from scancode.io.
@pombredanne this edit in base.py
in not needed anymore, this was just a temporary workaround.
PR #57 allows to override those settings directly in the .env
file.
from scancode.io.
Related Issues (20)
- Store and retrieve on demand scanned packages/archives
- Enhance grouping of non-package files together to additional pipelines
- RFC: Design improved relationships for Package, Dependencies, Embeds and Requirements HOT 4
- RFC: Design improved integration between DejaCode and ScanCode.io HOT 2
- Add security-focused pipeline to scan for effective potential malware detection HOT 2
- Refine pipeline choices in "Add pipeline" modal from project context
- Rethink current CHANGELOG as Release Notes HOT 11
- Package file name may be incorrect in SPDX output for d2d projects with ABOUT files HOT 1
- scancodeio-web-1 | sh: 1: ./manage.py: Permission denied HOT 5
- Cannot install SCIO for dev on a fresh Ubuntu 22.04 desktop by just following instructions HOT 2
- Debian package is not extracted recursively HOT 6
- WARNING Forbidden (CSRF cookie not set.) HOT 5
- test_scanpipe_resolve_dependencies_pipeline_integration_misc takes over 2min to run
- Load nuget-inspector data
- Allow scancode scans as a generic input
- Add API endpoint for downloading project outputs HOT 1
- Feature: back2source: Create dedicated d2d pipelines
- Feature: back2source: Find binary’s corresponding source repositories and commits
- How to access downloads that are password-protected? HOT 2
- DiscoveredPackage entries missing package detection info
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from scancode.io.