Latte
sql.js
Our great sponsors
Latte | sql.js | |
---|---|---|
10 | 43 | |
1,061 | 12,191 | |
0.9% | 0.8% | |
8.6 | 6.5 | |
2 days ago | 3 days ago | |
PHP | JavaScript | |
GNU General Public License v3.0 or later | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Latte
-
State of PHP templating
Have a look at Latte. It gives you a template engine that looks and feels a lot like PHP itself, rather than being a port of Python.
-
Php career guide
FTLOG, use a template engine. Do NOT use PHP itself as a template engine (ironic given its origins). The best are probably Twig (https://twig.symfony.com/) (used by Symfony and a few others) and Latte (https://latte.nette.org/) (less widely used, but its syntax is *way* more learnable as it's more like PHP itself).
- Recommended using template engine in non framework projects?
-
5 PHP Frameworks You've (Probably) Never Heard of
You may have already used some of Nette's tools in other projects you've worked on and not known it! There is the very extendable Tracy for debugging similar to Whoosh, and Latte for intuitive HTML templating.
- Which template engine do you use?
-
First version of PHP Templating Abstraction released
The target of the project is that more libraries / modules allow to use any Template engines the project want and see the more a as data provider. Also this kind of abstraction should make libraries e.g. a async mailer easier be integrated into different frameworks. A common usecase for myself is that Sulu CMS does not only support Twig but also other Template engines like example Latte which has interesting concept context aware escaping.
-
Style your Nette Framework website faster with Stylify CSS
Nette is a PHP framework made by David Grudl and it is a great alternative to Symfony and Laravel. It has an amazing templating system called Latte that uses similar syntax to PHP and by default has context-sensitive escaping (which no other framework has). In my opinion, it is easier to learn, because it comes with a simple structure by default, it has no dependencies and less patterns to learn.
-
How to localize Nette app using contributte/translation and Localazy
In the template file, we passed a variable called project containing a value into the extracted string mentioned before. All of this is done using an array as a second argument of the underscore tag notation. This is how this pairing works using latte templating engine and NEON. We've also used the noescape filter, which disables automatic escaping so the HTML tags are actually rendered and not printed as a text.
-
Lots of blocked attacks and probes..should I worry..
I'd heard great things about Timber, how do you like to use it? I recently wanted to add some templating to a WP2Static addon and went with Latte, I believe my reasoning at the time was for better PHPStan/static analysis support - I'm definitely not a power user of it, just simple templating for now.
sql.js
-
Show HN: Appendable – Index JSONL data and query via CDN
Hi HN! A friend and I were inspired by projects like https://github.com/sql-js/sql.js and the idea of querying files served over CDN with HTTP range requests. We started thinking: what would a database that was specifically designed for this type of use case look like? So we started building one, and we landed on a functional prototype that we're pretty proud of!
With our prototype, Appendable, we're able to serve and query large (GB+) datasets by hosting them on a static file host like Amazon S3 or Cloudflare R2 without running a separate server and worrying about things like tail latency, replication, and connection pooling -- all that is handled for us by the file hoster.
Additionally, one tenet that we have been following is Appendable won't touch your underlying data, so your jsonl file is preserved and we point at that data instead of consuming it into an Appendable-specific file format. This keeps your data yours and makes it easy to introspect the data: just open it up with your favorite editor aka vim.
We're curious what you think, we're excited to build this out further to get the performance even better and add features like pubsub. Everything is open source at https://github.com/kevmo314/appendable.
Kevin and Matthew
- How to show CRUD projects on Github?
-
I made a website where you can use SQLite in your browser
My project is powered by sql.js, I recommend checking that out if you're interested - https://github.com/sql-js/sql.js/
-
How to build interactive way to learn SQL using Next.js and database?
Maybe you can try to use some SQL database compiled as Web Assembly Modules? Like this one for example: https://github.com/sql-js/sql.js
-
Recommendations for data structure and storage
If you want to have persistence, then I would go with a database like Dexie, as it uses IndexedDB and has transactions. If you just want something that's in memory, you could look at Sql.js or something simple like lowdb.
-
I have a large JSON object (~2GB), what's the best way to make a site that lets you search through it and display the results without crashing?
not necessarily. you can host an html/js/sqlite site on github pages for free. json -> sqlite3 js -> sql
-
new release of : https://sql.js.org/
Link: https://sql.js.org
- Web-Projekt - Hilfe, weil ich nicht weiß, was ich benötige :S
- Learn Postgres at the Playground
-
Show HN: CSVFiddle – Query CSV files with DuckDB in the browser
Does it work with really large files? Like, >100mb or so. I was considering making something similar but with sqlite.js [1], but the problem with it is that it loads everything in memory, so I wasn't entirely sure how it will deal with larger workloads.
What are some alternatives?
Twig - Twig, the flexible, fast, and secure template language for PHP
localForage - 💾 Offline storage, improved. Wraps IndexedDB, WebSQL, or localStorage using a simple but powerful API.
Smarty - Smarty is a template engine for PHP, facilitating the separation of presentation (HTML/CSS) from application logic.
LokiJS - javascript embeddable / in-memory database
Blade - View template engine of PHP extracted from Laravel
PouchDB - :koala: - PouchDB is a pocket-sized database.
Mustache - A Mustache implementation in PHP.
WatermelonDB - 🍉 Reactive & asynchronous database for powerful React and React Native apps ⚡️
Plates - Native PHP template system
DB.js - db.js is a wrapper for IndexedDB to make it easier to work against
PHPTAL - PHP Template Attribute Language — template engine for XSS-proof well-formed XHTML and HTML5 pages
litestream - Streaming replication for SQLite.