Yes, several users have had positive experiences using SQLite in production, especially for small applications due to its low latency and simplicity. However, it's advisable to manage index statistics, use meaningful types, handle write transactions carefully, and ensure the development team is comfortable with database design and management to avoid performance and scaling issues.