Comments (4)
I took a look at that extension, but unfortunately it appears to be missing IPv6 support and a number of the query operators. It also appears to be unmaintained.
It would probably be cleaner to start a new project for that, but it would also require updates or a replacement for the SQLite extension. If such a thing existed AND was fully functional, then it could be a useful addition here, but I am not interested in taking on such an effort.
If the purpose of such a thing is for testing, it's not's hard to set up PostgreSQL and a user that can create test databases.
from django-postgresql-netfields.
@jimfunk, I'm interested in SQLite parity as well. I would prefer to use netfields+Postgres for our project (we run Postgres in prod), but it's hard to ditch the speed of SQLite for local testing during development.
Would it be feasible to mirror the Postgres functionality for the SQLite backend using a naive column type and do Postgres function equivalents in Python, even if performance is subpar? It seems like a significant code change. Would the project be receptive to such a change? Thanks!
from django-postgresql-netfields.
Upon further review, it seems Django doesn't allow one to implement Functions and Lookups in Python to bridge a feature gap between databases, which I assume is due to the lazy execution of QuerySets. Django functions and lookups only craft custom SQL expressions to meet syntax expectations of whatever the database backend.
from django-postgresql-netfields.
Yes, the functionality here is a lot more than simply storing addresses and converting data upon retrieval. It's about making queries such as "address is in a range." Those kinds of things would require database support. Supposedly that can be done, but it would be module on the SQLite side.
For testing, I simply use a local PostgreSQL instance with a user that can create databases. It's very fast and you don't have to worry about missing any sort of error that would only happen in production.
from django-postgresql-netfields.
Related Issues (20)
- Unsupported lookup 'net_overlaps' for CidrAddressField HOT 6
- How to use Django-Netfields with Django packages requiring a custom manager HOT 2
- loaddata failure with natural keys but successful without them HOT 2
- postgresql_psycopg2 deprecation warning (django-netfields 1.2.2) HOT 4
- extra lookups don`t work HOT 3
- SQL error while deleting from table with InetAddressField. HOT 4
- setup.py packages test directory
- Drop support for unmaintained django/python versions HOT 1
- Support for psycopg3 HOT 3
- Depreciated warning, Removed In Django 41. default_app_config is now detected automatically (in Django 3.2+) HOT 1
- Remove or replace python 2 from CI
- Invalid query when combining with ArrayField and NULL values HOT 1
- 'strict' parameter for network HOT 1
- Problem with ArrayField and ModelSerializer HOT 4
- Lookup by host HOT 10
- Limit fields to a specific family (IPv6, IPv4, or both) HOT 1
- Python field type is str instead of ipaddress.ip_address HOT 1
- Request to support rhs lookup expressions
- Incompatible with Django 3 HOT 2
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 django-postgresql-netfields.